ruby-rails 2:4.2.10 is not compatible with PostgreSQL 10 (sequence handling changed since 9.x)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
rails (Ubuntu) |
New
|
Undecided
|
Unassigned | ||
redmine (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
From PostgreSQL v10, the sequence object has altered, moving attributes such as "increment_by" and "min_value" to the pg_sequences catalog, rather than holding them in the sequence itself.
The rails package on Ubuntu 18.04 does not seem to have caught up with this.
The error was encountered using the community supported script to migrate Trac projects to Redmine.
Error text given was:
ActiveRecord:
LINE 1: ...sues_id_seq"', (SELECT COALESCE(
: SELECT setval(
/usr/share/
/usr/share/
Caused by:
PG::UndefinedCo
LINE 1: ...sues_id_seq"', (SELECT COALESCE(
/usr/share/
/usr/share/
Tasks: TOP => redmine:
summary: |
- ruby-rails 2:4.2.10 does not utilise PGSQL 10 sequence model + ruby-rails 2:4.2.10 is not compatible with PostgreSQL 10 (sequence + handling changed since 9.x) |
Cleaner details found at: https:/ /help.heroku. com/WKJ027JH/ rails-error- after-upgrading -to-postgres- 10