ruby-rails 2:4.2.10 is not compatible with PostgreSQL 10 (sequence handling changed since 9.x)

Bug #1776931 reported by Rich James
6
This bug affects 1 person
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::StatementInvalid: PG::UndefinedColumn: ERROR: column "increment_by" does not exist
LINE 1: ...sues_id_seq"', (SELECT COALESCE(MAX("id")+(SELECT increment_...
                                                             ^
: SELECT setval('"public"."issues_id_seq"', (SELECT COALESCE(MAX("id")+(SELECT increment_by FROM "public"."issues_id_seq"), (SELECT min_value FROM "public"."issues_id_seq")) FROM "issues"), false)
/usr/share/redmine/lib/tasks/migrate_from_trac.initial.rake:561:in `migrate'
/usr/share/redmine/lib/tasks/migrate_from_trac.initial.rake:782:in `block (2 levels) in <top (required)>'

Caused by:
PG::UndefinedColumn: ERROR: column "increment_by" does not exist
LINE 1: ...sues_id_seq"', (SELECT COALESCE(MAX("id")+(SELECT increment_...
                                                             ^
/usr/share/redmine/lib/tasks/migrate_from_trac.initial.rake:561:in `migrate'
/usr/share/redmine/lib/tasks/migrate_from_trac.initial.rake:782:in `block (2 levels) in <top (required)>'
Tasks: TOP => redmine:migrate_from_trac

Revision history for this message
Rich James (rich.james) wrote :
Rich James (rich.james)
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)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.