Project

General

Profile

Actions

Bug #17372

closed

Installation of foreman_tasks fails on Debian jessie

Added by Dirk Götz almost 8 years ago. Updated over 6 years ago.

Status:
Duplicate
Priority:
Normal
Assignee:
Category:
-
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

I have an installation of foreman on Debian jessie updated to 1.13.1 and afterwards wanted to install remote execution using the installer which failed during database migration and seeding. To find out in which step it fails I purged the packages and run the installer one by one which showed problem exists in tasks plugin package. Database got only the empty table "dynflow_schema_info" created before it fails. Dropping the table and running foreman-rake db:seed gave me this error:

rake aborted!
Sequel::DatabaseError: PG::DuplicateColumn: ERROR:  column "version" of relation "dynflow_schema_info" already exists
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:187:in `async_exec'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:187:in `block in execute_query'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/logging.rb:44:in `log_connection_yield'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:187:in `execute_query'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:174:in `block in execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:150:in `check_disconnect_errors'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:174:in `execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:526:in `_execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:342:in `block (2 levels) in execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:547:in `check_database_errors'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:342:in `block in execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/connecting.rb:251:in `block in synchronize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:107:in `hold'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/connecting.rb:251:in `synchronize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:342:in `execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/query.rb:52:in `execute_dui'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/query.rb:45:in `execute_ddl'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:420:in `block in apply_alter_table'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:420:in `each'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:420:in `apply_alter_table'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:425:in `apply_alter_table_generator'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:81:in `alter_table'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:602:in `schema_dataset'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:452:in `initialize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:522:in `initialize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:399:in `new'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:399:in `run'
/usr/share/foreman/vendor/ruby/2.1.0/gems/dynflow-0.8.15/lib/dynflow/persistence_adapters/sequel.rb:218:in `migrate_db'
/usr/share/foreman/vendor/ruby/2.1.0/gems/dynflow-0.8.15/lib/dynflow/persistence_adapters/sequel.rb:44:in `initialize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:146:in `new'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:146:in `initialize_persistence'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:105:in `block in world_config'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:101:in `tap'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:101:in `world_config'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:62:in `initialize_world'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow.rb:40:in `initialize!'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/engine.rb:156:in `block in <class:Engine>'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:36:in `call'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:45:in `block in run_load_hooks'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:44:in `each'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:44:in `run_load_hooks'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application/finisher.rb:62:in `block in <module:Finisher>'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:30:in `instance_exec'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:30:in `run'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:55:in `block in run_initializers'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:54:in `run_initializers'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:352:in `initialize!'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/railtie.rb:194:in `public_send'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/railtie.rb:194:in `method_missing'
/usr/share/foreman/config/environment.rb:5:in `<top (required)>'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:328:in `require_environment!'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:457:in `block in run_tasks_blocks'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/railties/databases.rake:182:in `block (2 levels) in <top (required)>'
PG::DuplicateColumn: ERROR:  column "version" of relation "dynflow_schema_info" already exists
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:187:in `async_exec'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:187:in `block in execute_query'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/logging.rb:44:in `log_connection_yield'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:187:in `execute_query'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:174:in `block in execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:150:in `check_disconnect_errors'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:174:in `execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:526:in `_execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:342:in `block (2 levels) in execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:547:in `check_database_errors'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:342:in `block in execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/connecting.rb:251:in `block in synchronize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/connection_pool/threaded.rb:107:in `hold'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/connecting.rb:251:in `synchronize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/adapters/postgres.rb:342:in `execute'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/query.rb:52:in `execute_dui'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/query.rb:45:in `execute_ddl'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:420:in `block in apply_alter_table'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:420:in `each'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:420:in `apply_alter_table'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:425:in `apply_alter_table_generator'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/database/schema_methods.rb:81:in `alter_table'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:602:in `schema_dataset'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:452:in `initialize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:522:in `initialize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:399:in `new'
/usr/share/foreman/vendor/ruby/2.1.0/gems/sequel-4.37.0/lib/sequel/extensions/migration.rb:399:in `run'
/usr/share/foreman/vendor/ruby/2.1.0/gems/dynflow-0.8.15/lib/dynflow/persistence_adapters/sequel.rb:218:in `migrate_db'
/usr/share/foreman/vendor/ruby/2.1.0/gems/dynflow-0.8.15/lib/dynflow/persistence_adapters/sequel.rb:44:in `initialize'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:146:in `new'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:146:in `initialize_persistence'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:105:in `block in world_config'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:101:in `tap'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:101:in `world_config'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow/configuration.rb:62:in `initialize_world'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/dynflow.rb:40:in `initialize!'
/usr/share/foreman/vendor/ruby/2.1.0/gems/foreman-tasks-0.8.2/lib/foreman_tasks/engine.rb:156:in `block in <class:Engine>'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:36:in `call'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:45:in `block in run_load_hooks'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:44:in `each'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/lazy_load_hooks.rb:44:in `run_load_hooks'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application/finisher.rb:62:in `block in <module:Finisher>'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:30:in `instance_exec'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:30:in `run'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:55:in `block in run_initializers'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/initializable.rb:54:in `run_initializers'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:352:in `initialize!'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/railtie.rb:194:in `public_send'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/railtie.rb:194:in `method_missing'
/usr/share/foreman/config/environment.rb:5:in `<top (required)>'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `block in require'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:240:in `load_dependency'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activesupport-4.2.7.1/lib/active_support/dependencies.rb:274:in `require'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:328:in `require_environment!'
/usr/share/foreman/vendor/ruby/2.1.0/gems/railties-4.2.7.1/lib/rails/application.rb:457:in `block in run_tasks_blocks'
/usr/share/foreman/vendor/ruby/2.1.0/gems/activerecord-4.2.7.1/lib/active_record/railties/databases.rake:182:in `block (2 levels) in <top (required)>'
Tasks: TOP => db:abort_if_pending_migrations => environment
(See full trace by running task with --trace)

As it looked very similar to http://projects.theforeman.org/issues/12993, I did the same workaround and pinned the pg gem to 0.15.1 (already exsiting from previous installation) by changing /usr/share/foreman/bundler.d/postgresql.rb to look like:

group :postgresql do
  #gem 'pg', '~> 0.15'
  gem 'pg', '0.15.1'
end

Running migrate and seed afterwards worked fine, also running the installer to finish installating for foreman_remote_execution.

Information about the system:

# cat /etc/os-release 
PRETTY_NAME="Debian GNU/Linux 8 (jessie)" 
NAME="Debian GNU/Linux" 
VERSION_ID="8" 
VERSION="8 (jessie)" 
ID=debian
HOME_URL="http://www.debian.org/" 
SUPPORT_URL="http://www.debian.org/support" 
BUG_REPORT_URL="https://bugs.debian.org/" 

/usr/share/foreman# bundler list
Gems included by the bundle:
  * actionmailer (4.2.7.1)
  * actionpack (4.2.7.1)
  * actionview (4.2.7.1)
  * activejob (4.2.7.1)
  * activemodel (4.2.7.1)
  * activerecord (4.2.7.1)
  * activerecord-session_store (1.0.0)
  * activesupport (4.2.7.1)
  * addressable (2.4.0)
  * algebrick (0.7.3)
  * ancestry (2.2.1)
  * apipie-params (0.0.5)
  * apipie-rails (0.3.7)
  * arel (6.0.3)
  * audited (4.2.2)
  * audited-activerecord (4.2.2)
  * builder (3.2.2)
  * bundler (1.7.4)
  * coffee-rails (4.2.1)
  * coffee-script (2.4.1)
  * coffee-script-source (1.10.0)
  * colorize (0.7.7)
  * concurrent-ruby (1.0.2)
  * concurrent-ruby-edge (0.2.2)
  * css_parser (1.4.6)
  * daemons (1.2.4)
  * deacon (1.0.0)
  * deep_cloneable (2.2.2)
  * deface (1.0.2)
  * diffy (3.0.7)
  * domain_name (0.5.20160826)
  * dynflow (0.8.15)
  * erubis (2.7.0)
  * excon (0.54.0)
  * execjs (2.7.0)
  * facter (1.7.6)
  * fast_gettext (1.1.0)
  * fog-core (1.42.0)
  * fog-json (1.0.2)
  * fog-libvirt (0.3.0)
  * fog-vsphere (1.5.0)
  * fog-xml (0.1.2)
  * foreman-tasks (0.8.2)
  * foreman-tasks-core (0.1.1)
  * foreman_bootdisk (8.0.2)
  * foreman_remote_execution (1.2.1)
  * foreman_remote_execution_core (1.0.1)
  * foreman_setup (5.0.0)
  * foreman_templates (3.1.0)
  * formatador (0.2.5)
  * friendly_id (5.1.0)
  * gettext_i18n_rails (1.7.2)
  * git (1.2.9.1)
  * globalid (0.3.7)
  * http-cookie (1.0.3)
  * i18n (0.7.0)
  * json (1.8.3)
  * ldap_fluff (0.4.4)
  * little-plugger (1.1.4)
  * logging (2.1.0)
  * loofah (2.0.3)
  * mail (2.6.4)
  * mime-types (3.1)
  * mime-types-data (3.2016.0521)
  * mini_portile2 (2.1.0)
  * minitest (5.1.0)
  * multi_json (1.12.1)
  * net-ldap (0.15.0)
  * net-scp (1.2.1)
  * net-ssh (3.2.0)
  * netrc (0.11.0)
  * nokogiri (1.6.8.1)
  * oauth (0.5.1)
  * parse-cron (0.1.4)
  * pg (0.15.1)
  * polyglot (0.3.5)
  * rabl (0.12.0)
  * rack (1.6.4)
  * rack-jsonp (1.3.1)
  * rack-protection (1.4.0)
  * rack-test (0.6.3)
  * rails (4.2.7.1)
  * rails-deprecated_sanitizer (1.0.3)
  * rails-dom-testing (1.0.7)
  * rails-html-sanitizer (1.0.3)
  * rails-i18n (4.0.9)
  * rails-observers (0.1.2)
  * railties (4.2.7.1)
  * rake (11.3.0)
  * rbvmomi (1.9.4)
  * responders (2.3.0)
  * rest-client (2.0.0)
  * roadie (3.2.0)
  * roadie-rails (1.1.1)
  * ruby-libvirt (0.7.0)
  * ruby2ruby (2.3.1)
  * ruby_parser (3.8.3)
  * safemode (1.2.4)
  * scoped_search (3.3.0)
  * secure_headers (1.4.1)
  * sequel (4.37.0)
  * sexp_processor (4.7.0)
  * sinatra (1.4.6)
  * sprockets (3.7.0)
  * sprockets-rails (2.3.3)
  * sqlite3 (1.3.12)
  * thor (0.19.1)
  * thread_safe (0.3.5)
  * tilt (2.0.5)
  * trollop (2.1.2)
  * turbolinks (2.5.3)
  * tzinfo (1.2.2)
  * unf (0.1.4)
  * unf_ext (0.0.7.2)
  * validates_lengths_from_database (0.5.0)
  * webpack-rails (0.9.9)
  * will_paginate (3.1.5)
  * x-editable-rails (1.5.5)

# dpkg -l | grep postgres
ii  foreman-postgresql                    1.13.1-1                             all          metapackage providing PostgreSQL dependencies for Foreman
ii  postgresql-9.4                        9.4.9-0+deb8u1                       amd64        object-relational SQL database, version 9.4 server
ii  postgresql-client-9.4                 9.4.9-0+deb8u1                       amd64        front-end programs for PostgreSQL 9.4
ii  postgresql-client-common              165+deb8u1                           all          manager for multiple PostgreSQL client versions
ii  postgresql-common                     165+deb8u1                           all          PostgreSQL database-cluster manager

# grep -v '^$\|^\s*\#' /etc/postgresql/*/main/postgresql.conf
data_directory = '/var/lib/postgresql/9.4/main' # use data in another directory
hba_file = '/etc/postgresql/9.4/main/pg_hba.conf' # host-based authentication file
ident_file = '/etc/postgresql/9.4/main/pg_ident.conf' # ident configuration file
external_pid_file = '/var/run/postgresql/9.4-main.pid' # write an extra PID file
port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories
ssl = true # (change requires restart)
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem' # (change requires restart)
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key' # (change requires restart)
shared_buffers = 128MB # min 128kB
dynamic_shared_memory_type = posix # the default is the first option
log_line_prefix = '%t ' # special values:
log_timezone = localtime
stats_temp_directory = '/var/run/postgresql/9.4-main.pg_stat_tmp'
datestyle = 'iso, mdy'
timezone = localtime
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
listen_addresses = localhost

Any more information I can give you to reproduce or solve the problem?


Related issues 3 (0 open3 closed)

Related to foreman-tasks - Bug #17875: ruby-foreman-tasks fails to intsall on debian/ubuntuDuplicate12/29/2016Actions
Related to Packaging - Bug #20050: ruby-sequel-pg DEB pollutes Foreman ruby gem environmentClosedIvan Necas06/19/2017Actions
Related to foreman-tasks - Bug #12993: PostgreSQL DuplicateColumn ErrorClosed01/05/2016Actions
Actions #1

Updated by Dominik Bittl almost 8 years ago

Seems to be still there in 1.14.0~rc2-1 on ubuntu 14.04.

Actions #2

Updated by Anonymous almost 8 years ago

  • Related to Bug #17875: ruby-foreman-tasks fails to intsall on debian/ubuntu added
Actions #3

Updated by Anonymous almost 8 years ago

  • Assignee set to Ivan Necas

Ivan, where there new insights in the meanwhile about this?

Actions #4

Updated by Ivan Necas over 7 years ago

I've not had a reproducer to try it with so far: will try to get some to be able to investigate further.

Actions #5

Updated by Dominik Bittl over 7 years ago

Are there any news? Is there a workaround to get my production system up running again?

Actions #6

Updated by Dirk Götz over 7 years ago

Have you tried the workaround from my initial report? Pinning Foreman to the older version of the pg gem worked quite fine in the environment I was affected by this bug.

Actions #7

Updated by Dominik Bittl over 7 years ago

Foreman gets up and working with this workaround but the package ruby-foreman-tasks and can't be installed anymore. See http://projects.theforeman.org/issues/17875 for more details.

Actions #8

Updated by Marek Hulán over 7 years ago

  • Related to Bug #20050: ruby-sequel-pg DEB pollutes Foreman ruby gem environment added
Actions #9

Updated by Anonymous over 6 years ago

  • Related to Bug #12993: PostgreSQL DuplicateColumn Error added
Actions #10

Updated by Anonymous over 6 years ago

  • Status changed from New to Duplicate
Actions

Also available in: Atom PDF