Bug #9936
closedkatello-installer 2.1 fails due to foreman-rake-db:migrate when following yum install procedure on CentOS 6.6
Description
When following the Katello 2.1 install procedure for CentOS 6.6 on the following page:
http://www.katello.org/docs/2.1/installation/index.html
The install process fails with the following error when running 'katello-installer' (with no flags)[root@katello /root]# katello-installer
/Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]: Failed to call refresh: /usr/sbin/foreman-rake db:migrate returned 1 instead of one of [0]
/Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]: /usr/sbin/foreman-rake db:migrate returned 1 instead of one of [0]
/Stage[main]/Foreman::Database/Foreman::Rake[db:seed]/Exec[foreman-rake-db:seed]: Failed to call refresh: /usr/sbin/foreman-rake db:seed returned 1 instead of one of [0]
/Stage[main]/Foreman::Database/Foreman::Rake[db:seed]/Exec[foreman-rake-db:seed]: /usr/sbin/foreman-rake db:seed returned 1 instead of one of [0]
/Stage[main]/Foreman_proxy::Register/Foreman_smartproxy[<hostname removed>]: Could not evaluate: 500 Internal Server Error
/Stage[main]/Foreman_proxy::Register/Foreman_smartproxy[<hostname removed>]: Failed to call refresh: 500 Internal Server Error
/Stage[main]/Foreman_proxy::Register/Foreman_smartproxy[<hostname removed>]: 500 Internal Server Error
Installing Done [100%] [.......................................................................................................................................]
Something went wrong! Check the log for ERROR-level output
The full log is at /var/log/katello-installer/katello-installer.log
When looking at the log the first error is:[ WARN 2015-03-28 17:23:25 main] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: An error has occurred, this and all later migrations canceled:
[ WARN 2015-03-28 17:23:25 main] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns:
[ WARN 2015-03-28 17:23:25 main] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: PGError: ERROR: column reference "id" is ambiguous
[ WARN 2015-03-28 17:23:25 main] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: LINE 1: SELECT id FROM "discovery_attribute_sets" INNER JOIN "hosts"...
[ WARN 2015-03-28 17:23:25 main] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: ^
[ WARN 2015-03-28 17:23:25 main] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: : SELECT id FROM "discovery_attribute_sets" INNER JOIN "hosts" ON "hosts"."id" = "discovery_attribute_sets"."host_id" WHERE "hosts"."managed" = 't'
[ WARN 2015-03-28 17:23:25 main] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns:
This is using a vanilla CentOS 6.6 image following the procedure. The only exception to the procedure is that 'yum downgrade puppet-3.7.4'
was run after 'yum install katello'
to resolve the Puppet 3.7.5 issue which has already been raised in the bug tracker.