ERROR: column "version" of relation "dynflow_schema_info" already exists

Support
, ,
1

Problem:
After installing foreman-installer --enable-foreman-plugin-remote-execution --enable-foreman-proxy-plugin-remote-execution-ssh

i get the error > Sequel::DatabaseError: PG::DuplicateColumn: ERROR: column “version” of relation “dynflow_schema_info” already exists

and foreman is broken, i have to use an older snapshot. Because i dont now how to fix the issue

Expected outcome:
Working Foreman
Foreman and Proxy versions:
1.16.1-1
Foreman and Proxy plugin versions:
cat /etc/apt/sources.list.d/foreman.list
deb http://deb.theforeman.org/ stretch 1.16
deb http://deb.theforeman.org/ plugins 1.16
Other relevant data:
Sequel::DatabaseError: PG::DuplicateColumn: ERROR: column “version” of relation “dynflow_schema_info” already exists

i tried the manual way to. I already use the foreman_ansible plugin successfully. Dont know if it matters.

1 Like
2

The same issue with 1.17RC1 on the Ubuntu 16.04.4

3

Can you tell me if you find an workaround for Ubuntu?

4

Didn’t find yet

5

Hi,

We are tracking the issue here http://projects.theforeman.org/issues/20050#note-37

We found the cause to it and the fix should be to apt remove ruby-sequel-pg, as that’s causing version conflicts.

The ultimate fix should be done in Debian packaging to isolate the gems used for Foreman server from the system ones (probably via bundle exec.

1 Like
6

thanks mate