9:15 p.m.
Hi!
I'm looking at Katello 1.4 right now and I've run into an issue
upgrading my server. The katello-upgrade script is complaining that it
did not return zero and suggests I try again. I did just that and....
it gave me the same answer.
I am seeing a few errors in the logs. First is this :
10/24/13 20:32:03 Applying migration
pulp_rpm.migrations.0007_inventoried_custom_metadata failed. See log
for details.
10/24/13 20:32:03 2013-10-24 20:32:03,406 db:CRITICAL: Applying
migration pulp_rpm.migrations.0007_inventoried_custom_metadata failed.
10/24/13 20:32:03 2013-10-24 20:32:03,407 db:CRITICAL: [Errno 2] No such
file or directory:
'/var/lib/pulp/working/repos/Undrground-centos6-6_os_x86_64/importers/isos/x86_64/CentOS-6.4-x86_64-netinstall.iso'
10/24/13 20:32:03 2013-10-24 20:32:03,407 db:CRITICAL: Traceback (most
recent call last):
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp/server/db/manage.py", line 79, in
migrate_database
10/24/13 20:32:03 update_current_version=not options.test)
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp/server/db/migrate/models.py",
line 161, in apply_migration
10/24/13 20:32:03 migration.migrate()
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 43, in migrate
10/24/13 20:32:03 inventory_custom_metadata()
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 55, in inventory_custom_metadata
10/24/13 20:32:03 migrate_repo(repo)
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 100, in migrate_repo
10/24/13 20:32:03 content_unit = create_content_unit(ftype_data,
relative_path)
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 128, in create_content_unit
10/24/13 20:32:03 unit_data['_storage_path'] =
get_content_storage_path(relative_path)
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 143, in get_content_storage_path
10/24/13 20:32:03 fix_owner(storage_dir)
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 161, in fix_owner
10/24/13 20:32:03 _recursive_fix_owner(start_path)
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 159, in _recursive_fix_owner
10/24/13 20:32:03 _recursive_fix_owner(os.path.join(path, c))
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 159, in _recursive_fix_owner
10/24/13 20:32:03 _recursive_fix_owner(os.path.join(path, c))
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 159, in _recursive_fix_owner
10/24/13 20:32:03 _recursive_fix_owner(os.path.join(path, c))
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 159, in _recursive_fix_owner
10/24/13 20:32:03 _recursive_fix_owner(os.path.join(path, c))
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 159, in _recursive_fix_owner
10/24/13 20:32:03 _recursive_fix_owner(os.path.join(path, c))
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 159, in _recursive_fix_owner
10/24/13 20:32:03 _recursive_fix_owner(os.path.join(path, c))
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 159, in _recursive_fix_owner
10/24/13 20:32:03 _recursive_fix_owner(os.path.join(path, c))
10/24/13 20:32:03 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0007_inventoried_custom_metadata.py",
line 154, in _recursive_fix_owner
10/24/13 20:32:03 os.chown(path, apache_uid, apache_gid)
10/24/13 20:32:03 OSError: [Errno 2] No such file or directory:
'/var/lib/pulp/working/repos/Undrground-centos6-6_os_x86_64/importers/isos/x86_64/CentOS-6.4-x86_64-netinstall.iso'
It seems to be complaining about the absence of that file. However,
it's there :
$ ls -la
/var/lib/pulp/working/repos/Undrground-centos6-6_os_x86_64/importers/isos/x86_64/CentOS-6.4-x86_64-netinstall.iso
lrwxrwxrwx. 1 apache apache 122 Jul 10 10:01
/var/lib/pulp/working/repos/Undrground-centos6-6_os_x86_64/importers/isos/x86_64/CentOS-6.4-x86_64-netinstall.iso
->
../../../../../../../../../../content/distribution/ks-CentOS-6.4-x86_64/../../isos/x86_64/CentOS-6.4-x86_64-netinstall.iso
There's also another error in the changesets :
10/24/13 20:24:45 Starting step Migrate candlepin database
10/24/13 20:24:56 Migrating candlepin database
10/24/13 20:24:56 INFO 10/24/13 8:24 PM:liquibase: Successfully acquired
change log lock
10/24/13 20:24:56 INFO 10/24/13 8:24 PM:liquibase: Reading from
databasechangelog
10/24/13 20:24:56 INFO 10/24/13 8:24 PM:liquibase: Reading from
databasechangelog
10/24/13 20:24:56 INFO 10/24/13 8:24 PM:liquibase: Marking ChangeSet:
db/changelog/20130315171104-migrate-upstream-uuid.xml::20130315171104-1::jesusr::(Checksum:
3:0f47c338be7288047c4f8070fb5f8c3b) ran despite precondition failure due
to onFail='MARK_RAN':
10/24/13 20:24:56 db/changelog/changelog-update.xml : Column
'upstream_name' does not exist
10/24/13 20:24:56
10/24/13 20:24:56 INFO 10/24/13 8:24 PM:liquibase: Marking ChangeSet:
db/changelog/20130315171104-migrate-upstream-uuid.xml::20130315171104-2::jesusr::(Checksum:
3:912ed8de23dd289344ac372cc4d421c3) ran despite precondition failure due
to onFail='MARK_RAN':
10/24/13 20:24:56 db/changelog/changelog-update.xml : Column
'upstream_name' does not exist
10/24/13 20:24:56
Though the rest of them seem to have run fine. And finally, the last
error is that foreman is not starting :
10/24/13 20:25:34 Starting step Start foreman service
10/24/13 20:25:34 Starting foreman: Starting server on 127.0.0.1:5500 ...
10/24/13 20:25:34 >> Deleting stale PID file tmp/pids/thin.5500.pid
10/24/13 20:25:34 Starting server on 127.0.0.1:5501 ...
10/24/13 20:25:35 >> Deleting stale PID file tmp/pids/thin.5501.pid
10/24/13 20:25:35 [ OK ]
10/24/13 20:31:08 tomcat6 (pid 8990) is running... [ OK ]
10/24/13 20:31:08 httpd (pid 8821) is running...
10/24/13 20:31:08 mongod (pid 8757) is running...
10/24/13 20:31:08 qpidd (pid 8706) is running...
10/24/13 20:31:08 elasticsearch (pid 9084) is running...
10/24/13 20:31:08 Foreman dead but pid file exists
10/24/13 20:31:08 dead but pid file exists
10/24/13 20:31:08 katello is not running.
10/24/13 20:31:08 delayed_job is not running.
10/24/13 20:31:08 delayed_job_monitor is not running.
It appears that maybe there's a / missing from the pid path? I'm not
sure where that's set, though.
Can anyone offer some assistance?
Thanks!
--
---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- Niven's Inverse of Clarke's Third Law
6:20 a.m.
New subject: error when running katello-remove.sh
Hi,
After an unsuccesfull install of katello 1.4 on fedora 19, I try to remove it with the
katello-remove.sh script.
This script has two errors that prevent it from running:
"No Match for argument: tomcat6"
and
"Error: Trying to remove "systemd", which is protected"
Kind regards,
Jorick Astrego
Netbulae B.V.
10:16 a.m.
New subject: error when running katello-remove.sh
On 10/25/2013 04:20 AM, Jorick Astrego wrote:
Hi,
After an unsuccesfull install of katello 1.4 on fedora 19, I try to remove it with the
katello-remove.sh script.
This script has two errors that prevent it from running:
"No Match for argument: tomcat6"
and
"Error: Trying to remove "systemd", which is protected"
ah, that remove script is outdated and currently only works on
EL6(Centos6). Working on a patch now.
stay tuned,
Mike
--
Mike McCune
mmccune AT redhat.com
Red Hat Engineering | Portland, OR
Systems Management | 650-254-4248
10:32 a.m.
New subject: error when running katello-remove.sh
On 10/25/2013 04:20 AM, Jorick Astrego wrote:
Hi,
After an unsuccesfull install of katello 1.4 on fedora 19, I try to remove it with the
katello-remove.sh script.
This script has two errors that prevent it from running:
"No Match for argument: tomcat6"
and
"Error: Trying to remove "systemd", which is protected"
Kind regards,
Jorick Astrego
Netbulae B.V.
Just sent a patch which you can try out here:
https://raw.github.com/mccun934/katello-misc/1e114322427ca82d3acf9df5c0fa...
added a confirm dialog in there since it is fairly destructive.
Mike
--
Mike McCune
mmccune AT redhat.com
Red Hat Engineering | Portland, OR
Systems Management | 650-254-4248
10:58 a.m.
New subject: error when running katello-remove.sh
Hey Jorick,
While we fix the remove data script, can you provide us any information on why it was
unsuccessful?
If the installer errored out somewhere, would it be possible to provide us the logs under
/var/log/katello/katello-configure ?
Partha
----- Original Message -----
From: "Jorick Astrego" <j.astrego(a)netbulae.eu>
To: katello(a)lists.fedorahosted.org
Sent: Friday, October 25, 2013 7:20:41 AM
Subject: error when running katello-remove.sh
Hi,
After an unsuccesfull install of katello 1.4 on fedora 19, I try to remove it
with the katello-remove.sh script.
This script has two errors that prevent it from running:
"No Match for argument: tomcat6"
and
"Error: Trying to remove "systemd", which is protected"
Kind regards,
Jorick Astrego
Netbulae B.V.
_______________________________________________
katello mailing list
katello(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/katello
5:38 a.m.
New subject: Re[2]: error when running katello-remove.sh
Hi Partha,
Will run the updated remove script after debugging.
The problem I have is the install finishes but the services don't start:
katello-service status
Redirecting to /bin/systemctl status httpd.service
httpd.service - The Apache HTTP Server
  Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled)
  Active: active (running) since Mon 2013-10-28 11:16:17 CET; 17min ago
 Process: 1948 ExecStop=/usr/sbin/httpd $OPTIONS -k graceful-stop (code=exited,
status=0/SUCCESS)
 Main PID: 1975 (httpd)
  Status: "Total requests: 0; Current requests/sec: 0; Current traffic:  0
B/sec"
  CGroup: name=systemd:/system/httpd.service
          ├─1975 /usr/sbin/httpd -DFOREGROUND
          ├─1976 (wsgi:pulp)    -DFOREGROUND
          ├─1977 /usr/sbin/httpd -DFOREGROUND
          ├─1978 /usr/sbin/httpd -DFOREGROUND
          ├─1979 /usr/sbin/httpd -DFOREGROUND
          ├─1980 /usr/sbin/httpd -DFOREGROUND
          └─1981 /usr/sbin/httpd -DFOREGROUND
Oct 28 11:16:17 hq-ma01 httpd[1975]: AH00548: NameVirtualHost has no effect and will be
removed in the next release /etc/httpd/conf.d/katello.conf:6
Oct 28 11:16:17 hq-ma01 systemd[1]: Started The Apache HTTP Server.
Oct 28 11:22:37 hq-ma01 systemd[1]: Started The Apache HTTP Server.
Redirecting to /bin/systemctl status mongod.service
mongod.service - High-performance, schema-free document-oriented database
  Loaded: loaded (/usr/lib/systemd/system/mongod.service; enabled)
  Active: active (running) since Mon 2013-10-28 11:16:05 CET; 17min ago
 Main PID: 1809 (mongod)
  CGroup: name=systemd:/system/mongod.service
          └─1809 /usr/bin/mongod --quiet -f /etc/mongodb.conf run
Oct 28 11:16:05 hq-ma01 mongod[1807]: about to fork child process, waiting until server is
ready for connections.
Oct 28 11:16:05 hq-ma01 mongod[1807]: forked process: 1809
Oct 28 11:16:05 hq-ma01 mongod[1807]: all output going to: /var/log/mongodb/mongodb.log
Oct 28 11:16:05 hq-ma01 mongod[1807]: log file [/var/log/mongodb/mongodb.log] exists;
copied to temporary file [/var/log/mongodb/mongodb.log.2013-10-28T10-16-05]
Oct 28 11:16:05 hq-ma01 mongod[1807]: child process started successfully, parent exiting
Oct 28 11:16:05 hq-ma01 systemd[1]: Started High-performance, schema-free
document-oriented database.
Oct 28 11:22:37 hq-ma01 systemd[1]: Started High-performance, schema-free
document-oriented database.
Redirecting to /bin/systemctl status qpidd.service
qpidd.service - An AMQP message broker daemon.
  Loaded: loaded (/usr/lib/systemd/system/qpidd.service; enabled)
  Active: active (running) since Mon 2013-10-28 11:16:13 CET; 17min ago
    Docs: man:qpidd(1)
          http://qpid.apache.org/
 Main PID: 1934 (qpidd)
  CGroup: name=systemd:/system/qpidd.service
          └─1934 /usr/sbin/qpidd --config /etc/qpid/qpidd.conf
Oct 28 11:16:13 hq-ma01 systemd[1]: Started An AMQP message broker daemon..
Oct 28 11:16:13 hq-ma01 qpidd[1934]: 2013-10-28 11:16:13 [Security] notice SSL plugin not
enabled, you must set --ssl-cert-db to enable it.
Oct 28 11:16:13 hq-ma01 qpidd[1934]: 2013-10-28 11:16:13 [Store] notice Journal
"TplStore": Created
Oct 28 11:16:13 hq-ma01 qpidd[1934]: 2013-10-28 11:16:13 [Store] notice Store module
initialized; store-dir=/var/lib/qpidd/.qpidd
Oct 28 11:16:13 hq-ma01 qpidd[1934]: 2013-10-28 11:16:13 [Store] warning Message store
plugin: No storage providers available.
Oct 28 11:16:13 hq-ma01 qpidd[1934]: 2013-10-28 11:16:13 [Network] notice Listening on
TCP/TCP6 port 5672
Oct 28 11:16:13 hq-ma01 qpidd[1934]: 2013-10-28 11:16:13 [Broker] notice Broker running
Oct 28 11:22:42 hq-ma01 systemd[1]: Started An AMQP message broker daemon..
elasticsearch.service - LSB: Starts elasticsearch
  Loaded: loaded (/etc/rc.d/init.d/elasticsearch)
  Active: active (running) since Mon 2013-10-28 11:13:06 CET; 20min ago
  CGroup: name=systemd:/system/elasticsearch.service
          └─884 /bin/java -Xms256m -Xmx256m -Xss256k -Djava.awt.headless=true
-XX:+UseParNewGC -XX:+UseConcMarkSweepGC -XX:CMSInitiatingOccupancyFraction=75
-XX:+UseCMSInitiatingOccupancyOnly -XX:+HeapDumpOnOutOfMemoryError -Delastic...
Oct 28 11:13:06 hq-ma01 runuser[877]: pam_unix(runuser:session): session opened for user
elasticsearch by (uid=0)
Oct 28 11:13:06 hq-ma01 systemd[1]: Started LSB: Starts elasticsearch.
Oct 28 11:22:42 hq-ma01 systemd[1]: Started LSB: Starts elasticsearch.
Foremanforeman.service - SYSV: Init script for foreman
  Loaded: loaded (/etc/rc.d/init.d/foreman)
  Active: active (exited) since Mon 2013-10-28 11:22:43 CET; 10min ago
 Process: 2240 ExecStart=/etc/rc.d/init.d/foreman start (code=exited, status=0/SUCCESS)
Oct 28 11:22:42 hq-ma01 foreman[2240]: Starting foreman: Starting server on 127.0.0.1:5500
...
Oct 28 11:22:43 hq-ma01 foreman[2240]: Starting server on 127.0.0.1:5501 ...
Oct 28 11:22:43 hq-ma01 systemd[1]: Started SYSV: Init script for foreman.
foreman.service - SYSV: Init script for foreman
  Loaded: loaded (/etc/rc.d/init.d/foreman)
  Active: active (exited) since Mon 2013-10-28 11:22:43 CET; 10min ago
 Process: 2240 ExecStart=/etc/rc.d/init.d/foreman start (code=exited, status=0/SUCCESS)
Oct 28 11:22:42 hq-ma01 foreman[2240]: Starting foreman: Starting server on 127.0.0.1:5500
...
Oct 28 11:22:43 hq-ma01 foreman[2240]: Starting server on 127.0.0.1:5501 ...
Oct 28 11:22:43 hq-ma01 systemd[1]: Started SYSV: Init script for foreman.
katello is not running.
delayed_job is not running.
delayed_job_monitor is not running.
Attached the logfiles and this error gets my attention:
WARNING: Nokogiri was built against LibXML version 2.9.0, but has dynamically loaded
2.9.1
[ERROR] There has been an error when creating the index -- elasticsearch returned:
400 : {"error":"IndexAlreadyExistsException[[katello_changeset] Already
exists]","status":400}
[ERROR] There has been an error when creating the index -- elasticsearch returned:
400 : {"error":"IndexAlreadyExistsException[[katello_contentview] Already
exists]","status":400}
> Exiting!
/usr/share/gems/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:1161:in
`async_exec': PG::Error: ERROR:Â relation "content_view_definition_bases"
does not exist (ActiveRecord::StatementInvalid)
LINE 5:Â Â Â Â Â Â Â Â Â Â Â Â Â WHERE a.attrelid = '"content_view_definition_ba...
                                       ^
:Â Â Â Â Â Â Â Â Â Â Â Â SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                    pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid,
a.atttypmod
             FROM pg_attribute a LEFT JOIN pg_attrdef d
               ON a.attrelid = d.adrelid AND a.attnum = d.adnum
            WHERE a.attrelid =
'"content_view_definition_bases"'::regclass
              AND a.attnum > 0 AND NOT a.attisdropped
            ORDER BY a.attnum
   from
/usr/share/gems/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:1161:in
`exec_no_cache'
   from
/usr/share/gems/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:660:in
`block in exec_query'
   from
/usr/share/gems/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
`block in log'
   from
/usr/share/gems/gems/activesupport-3.2.13/lib/active_support/notifications/instrumenter.rb:20:in
`instrument'
   from
/usr/share/gems/gems/activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
`log'
   from
/usr/share/gems/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:659:in
`exec_query'
   from
/usr/share/gems/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:1286:in
`column_definitions'
   from
/usr/share/gems/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:855:in
`columns'
   from
/usr/share/gems/gems/activerecord-3.2.13/lib/active_record/connection_adapters/schema_cache.rb:12:in
`block in initialize'
   from /usr/share/gems/gems/activerecord-3.2.13/lib/active_record/model_schema.rb:228:in
`yield'
   from /usr/share/gems/gems/activerecord-3.2.13/lib/active_record/model_schema.rb:228:in
`columns'
   from /usr/share/gems/gems/activerecord-3.2.13/lib/active_record/model_schema.rb:237:in
`columns_hash'
   from /usr/share/gems/gems/activerecord-3.2.13/lib/active_record/inheritance.rb:19:in
`descends_from_active_record?'
   from /usr/share/gems/gems/activerecord-3.2.13/lib/active_record/inheritance.rb:25:in
`finder_needs_type_condition?'
   from /usr/share/gems/gems/activerecord-3.2.13/lib/active_record/base.rb:455:in
`relation'
   from /usr/share/gems/gems/activerecord-3.2.13/lib/active_record/scoping/named.rb:37:in
`scoped'
   from /usr/share/gems/gems/activerecord-3.2.13/lib/active_record/querying.rb:9:in
`where'
   from /usr/share/katello/app/models/content_view_definition.rb:33:in
`<class:ContentViewDefinition>'
   from /usr/share/katello/app/models/content_view_definition.rb:13:in `<top
(required)>'
   from /usr/share/rubygems/rubygems/core_ext/kernel_require.rb:55:in `require'
   from /usr/share/rubygems/rubygems/core_ext/kernel_require.rb:55:in `require'
   from
/usr/share/gems/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:251:in `block
in require'
   from
/usr/share/gems/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:236:in
`load_dependency'
   from
/usr/share/gems/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:251:in
`require'
   from
/usr/share/gems/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:359:in
`require_or_load'
   from
/usr/share/gems/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:313:in
`depend_on'
   from
/usr/share/gems/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in
`require_dependency'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/engine.rb:439:in `block (2 levels)
in eager_load!'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/engine.rb:438:in `each'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/engine.rb:438:in `block in
eager_load!'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/engine.rb:436:in `each'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/engine.rb:436:in
`eager_load!'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/application/finisher.rb:53:in
`block in <module:Finisher>'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/initializable.rb:30:in
`instance_exec'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/initializable.rb:30:in `run'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/initializable.rb:55:in `block in
run_initializers'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/initializable.rb:54:in `each'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/initializable.rb:54:in
`run_initializers'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/application.rb:136:in
`initialize!'
   from /usr/share/gems/gems/railties-3.2.13/lib/rails/railtie/configurable.rb:30:in
`method_missing'
   from /usr/share/katello/config/environment.rb:5:in `<top (required)>'
   from /usr/share/rubygems/rubygems/core_ext/kernel_require.rb:55:in `require'
   from /usr/share/rubygems/rubygems/core_ext/kernel_require.rb:55:in `require'
   from /usr/share/katello/config.ru:3:in `block in <main>'
   from /usr/share/gems/gems/rack-1.4.5/lib/rack/builder.rb:51:in `instance_eval'
   from /usr/share/gems/gems/rack-1.4.5/lib/rack/builder.rb:51:in `initialize'
   from /usr/share/katello/config.ru:1:in `new'
   from /usr/share/katello/config.ru:1:in `<main>'
   from /usr/share/gems/gems/thin-1.5.0/lib/rack/adapter/loader.rb:33:in `eval'
   from /usr/share/gems/gems/thin-1.5.0/lib/rack/adapter/loader.rb:33:in `load'
   from /usr/share/gems/gems/thin-1.5.0/lib/thin/controllers/controller.rb:181:in
`load_rackup_config'
   from /usr/share/gems/gems/thin-1.5.0/lib/thin/controllers/controller.rb:71:in
`start'
   from /usr/share/gems/gems/thin-1.5.0/lib/thin/runner.rb:187:in `run_command'
   from /usr/share/gems/gems/thin-1.5.0/lib/thin/runner.rb:152:in `run!'
   from /usr/share/gems/gems/thin-1.5.0/bin/thin:6:in `<top (required)>'
   from /usr/share/katello/script/thin:24:in `load'
   from /usr/share/katello/script/thin:24:in `<main>'
   from caused by: (PG::Error) ERROR: relation "content_view_definition_bases"
does not exist
LINE 5:Â Â Â Â Â Â Â Â Â Â Â Â Â WHERE a.attrelid = '"content_view_definition_ba...
                                       ^
   from    ... skipped 58 lines
Â
Â
Â
-----Original Message-----
From: "Partha Aji" <paji(a)redhat.com>
To: katello(a)lists.fedorahosted.org
Date: 25/10/2013 18:59
Subject: Re: error when running katello-remove.sh
Hey Jorick,
While we fix the remove data script, can you provide us any information on why it was
unsuccessful?
If the installer errored out somewhere, would it be possible to provide us the logs under
/var/log/katello/katello-configure ?
Partha
----- Original Message -----
> From: "Jorick Astrego" <j.astrego(a)netbulae.eu>
> To: katello(a)lists.fedorahosted.org
> Sent: Friday, October 25, 2013 7:20:41 AM
> Subject: error when running katello-remove.sh
>
> Hi,
>
> After an unsuccesfull install of katello 1.4 on fedora 19, I try to remove it
> with the katello-remove.sh script.
>
> This script has two errors that prevent it from running:
>
> "No Match for argument: tomcat6"
>
> and
>
> "Error: Trying to remove "systemd", which is protected"
>
> Kind regards,
>
> Jorick Astrego
> Netbulae B.V.
>
>
>
>
>
> _______________________________________________
> katello mailing list
> katello(a)lists.fedorahosted.org
> https://lists.fedorahosted.org/mailman/listinfo/katello
>
_______________________________________________
katello mailing list
katello(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/katello
7:42 a.m.
New subject: Re[2]: error when running katello-remove.sh
The removal script now runs. But I get an error that I also got before:
error reading information on service signo: No such file or directory
error: %preun(signo-0.0.22-1.fc19.noarch) scriptlet failed, exit status 1
Error in PREUN scriptlet in rpm package signo-0.0.22-1.fc19.noarch
I thought it had to do with the old imperfect removal but now when I reinstalled and
remove katello, I still get the error.
Â
Kind regards,
Jorick Astrego
Â
-----Original Message-----
From: "Partha Aji" <paji(a)redhat.com>
To: katello(a)lists.fedorahosted.org
Date: 25/10/2013 18:59
Subject: Re: error when running katello-remove.sh
Hey Jorick,
While we fix the remove data script, can you provide us any information on why it was
unsuccessful?
If the installer errored out somewhere, would it be possible to provide us the logs under
/var/log/katello/katello-configure ?
Partha
----- Original Message -----
> From: "Jorick Astrego" <j.astrego(a)netbulae.eu>
> To: katello(a)lists.fedorahosted.org
> Sent: Friday, October 25, 2013 7:20:41 AM
> Subject: error when running katello-remove.sh
>
> Hi,
>
> After an unsuccesfull install of katello 1.4 on fedora 19, I try to remove it
> with the katello-remove.sh script.
>
> This script has two errors that prevent it from running:
>
> "No Match for argument: tomcat6"
>
> and
>
> "Error: Trying to remove "systemd", which is protected"
>
> Kind regards,
>
> Jorick Astrego
> Netbulae B.V.
>
>
>
>
>
> _______________________________________________
> katello mailing list
> katello(a)lists.fedorahosted.org
> https://lists.fedorahosted.org/mailman/listinfo/katello
>
_______________________________________________
katello mailing list
katello(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/katello
11:17 p.m.
New subject: Re[2]: error when running katello-remove.sh
Sorry for the delay in responding.
Working on fixing this in the signo.spec, but meanwhile you can do the following
1) systemctl disable signo.service
2) rpm -e signo --noscripts
and then try running Mike's Katello_remove script
Partha
----- Original Message -----
From: "Jorick Astrego" <j.astrego(a)netbulae.eu>
To: katello(a)lists.fedorahosted.org
Sent: Monday, October 28, 2013 8:42:56 AM
Subject: Re[2]: error when running katello-remove.sh
The removal script now runs. But I get an error that I also got before:
error reading information on service signo: No such file or directory
error: %preun(signo-0.0.22-1.fc19.noarch) scriptlet failed, exit status 1
Error in PREUN scriptlet in rpm package signo-0.0.22-1.fc19.noarch
I thought it had to do with the old imperfect removal but now when I
reinstalled and remove katello, I still get the error.
Â
Kind regards,
Jorick Astrego
Â
-----Original Message-----
> From: "Partha Aji" <paji(a)redhat.com>
> To: katello(a)lists.fedorahosted.org
> Date: 25/10/2013 18:59
> Subject: Re: error when running katello-remove.sh
>
> Hey Jorick,
>
> While we fix the remove data script, can you provide us any information on
> why it was unsuccessful?
> If the installer errored out somewhere, would it be possible to provide us
> the logs under /var/log/katello/katello-configure ?
>
>
> Partha
>
> ----- Original Message -----
> > From: "Jorick Astrego" <j.astrego(a)netbulae.eu>
> > To: katello(a)lists.fedorahosted.org
> > Sent: Friday, October 25, 2013 7:20:41 AM
> > Subject: error when running katello-remove.sh
> >
> > Hi,
> >
> > After an unsuccesfull install of katello 1.4 on fedora 19, I try to
> > remove it
> > with the katello-remove.sh script.
> >
> > This script has two errors that prevent it from running:
> >
> > "No Match for argument: tomcat6"
> >
> > and
> >
> > "Error: Trying to remove "systemd", which is protected"
> >
> > Kind regards,
> >
> > Jorick Astrego
> > Netbulae B.V.
> >
> >
> >
> >
> >
> > _______________________________________________
> > katello mailing list
> > katello(a)lists.fedorahosted.org
> > https://lists.fedorahosted.org/mailman/listinfo/katello
> >
> _______________________________________________
> katello mailing list
> katello(a)lists.fedorahosted.org
> https://lists.fedorahosted.org/mailman/listinfo/katello
_______________________________________________
katello mailing list
katello(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/katello
11:05 a.m.
New subject: Re[2]: Re[2]: error when running katello-remove.sh
Thanks for the help, I got it running now.
I found the problem after spotting this in db_seed.log:
cat db_seed.log
WARNING: Nokogiri was built against LibXML version 2.9.0, but has dynamically loaded
2.9.1
** Invoke seed_with_logging (first_time)
** Invoke db:seed (first_time)
** Execute db:seed
** Invoke db:abort_if_pending_migrations (first_time)
** Invoke environment (first_time)
** Execute environment
** Invoke db:load_config (first_time)
** Execute db:load_config
** Execute db:abort_if_pending_migrations
rake aborted!
Unable to create first org: Label is invalid;Label cannot contain characters other than
ascii alpha numerals, '_', '-'.
/usr/share/katello/db/seeds.rb:59:in `<top (required)>'
/usr/share/gems/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:245:in
`load'
This pointed me to this bug:
https://bugzilla.redhat.com/show_bug.cgi?id=902990
As I didn't have any strange characters or spaces in the ssl_ca_org name or other
fields and the installer doesn't throw an error anymore, it took some time to figure
it out.
Either it went wrong because I put " " around the e-mail address or I had an
extra space before the ssl value.
I think it would be a good idea to validate the input and throw an error before the
configure process runs and fails.Â
Â
Kind regards,
Jorick Astrego
Netbulae B.V.
-----Original Message-----
Subject: Re: Re[2]: error when running katello-remove.sh
From: "Partha Aji" <paji(a)redhat.com>
To: katello(a)lists.fedorahosted.org
Date: 29/10/2013 04:17:39
Sorry for the delay in responding.
Working on fixing this in the signo.spec, but meanwhile you can do the following
1) systemctl disable signo.service
2) rpm -e signo --noscripts
and then try running Mike's Katello_remove script
Partha
----- Original Message -----
> From: "Jorick Astrego" <j.astrego(a)netbulae.eu>
> To: katello(a)lists.fedorahosted.org
> Sent: Monday, October 28, 2013 8:42:56 AM
> Subject: Re[2]: error when running katello-remove.sh
>
> The removal script now runs. But I get an error that I also got before:
>
> error reading information on service signo: No such file or directory
> error: %preun(signo-0.0.22-1.fc19.noarch) scriptlet failed, exit status 1
> Error in PREUN scriptlet in rpm package signo-0.0.22-1.fc19.noarch
>
> I thought it had to do with the old imperfect removal but now when I
> reinstalled and remove katello, I still get the error.
>
> Â
>
> Kind regards,
>
>
> Jorick Astrego
>
> Â
> -----Original Message-----
> > From: "Partha Aji" <paji(a)redhat.com>
> > To: katello(a)lists.fedorahosted.org
> > Date: 25/10/2013 18:59
> > Subject: Re: error when running katello-remove.sh
> >
> > Hey Jorick,
> >
> > While we fix the remove data script, can you provide us any information on
> > why it was unsuccessful?
> > If the installer errored out somewhere, would it be possible to provide us
> > the logs under /var/log/katello/katello-configure ?
> >
> >
> > Partha
> >
> > ----- Original Message -----
> > > From: "Jorick Astrego" <j.astrego(a)netbulae.eu>
> > > To: katello(a)lists.fedorahosted.org
> > > Sent: Friday, October 25, 2013 7:20:41 AM
> > > Subject: error when running katello-remove.sh
> > >
> > > Hi,
> > >
> > > After an unsuccesfull install of katello 1.4 on fedora 19, I try to
> > > remove it
> > > with the katello-remove.sh script.
> > >
> > > This script has two errors that prevent it from running:
> > >
> > > "No Match for argument: tomcat6"
> > >
> > > and
> > >
> > > "Error: Trying to remove "systemd", which is
protected"
> > >
> > > Kind regards,
> > >
> > > Jorick Astrego
> > > Netbulae B.V.
> > >
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > katello mailing list
> > > katello(a)lists.fedorahosted.org
> > > https://lists.fedorahosted.org/mailman/listinfo/katello
> > >
> > _______________________________________________
> > katello mailing list
> > katello(a)lists.fedorahosted.org
> > https://lists.fedorahosted.org/mailman/listinfo/katello
>
>
>
> _______________________________________________
> katello mailing list
> katello(a)lists.fedorahosted.org
> https://lists.fedorahosted.org/mailman/listinfo/katello
>
_______________________________________________
katello mailing list
katello(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/katello
7:30 a.m.
New subject: Content View Definitions problems
Hi,
Somehow I got problems with the "Content View Definitions"
I configured a "New view definition" and used the Publish button. After that I
used the Publish option a second time.
I now have two content views and I try to remove one of them, I get the following error:
Wed, 30 Oct 2013 11:18:48 +0000 error Netbulae Failed to generate version 2 of content
view 'Servers'.
404 Resource Not Found (RestClient::ResourceNotFound)
{"http_request_method": "GET", "exception": null,
"error_message": "Missing resource(s):
repo=Netbulae-Library-Servers-Fedora19-i386_os", "_href":
"/pulp/api/v2/repositories/Netbulae-Library-Servers-Fedora19-i386_os/",
"http_status": 404, "traceback": null, "resources":
{"repo": "Netbulae-Library-Servers-Fedora19-i386_os"}}
Wed, 30 Oct 2013 11:18:24 +0000 error Netbulae 404 Resource Not Found
(RestClient::ResourceNotFound)
{"http_request_method": "POST", "exception": null,
"error_message": "Missing resource(s):
repo_id=Netbulae-Library-Servers-Fedora19-i386_os", "_href":
"/pulp/api/v2/repositories/Netbulae-Library-Servers-Fedora19-i386_os/search/units/",
"http_status": 404, "traceback": null, "resources":
{"repo_id": "Netbulae-Library-Servers-Fedora19-i386_os"}}
Wed, 30 Oct 2013 11:18:16 +0000 error Netbulae ERROR: update or delete on table
"content_views" violates foreign key constraint
"systems_content_view_id_fk" on table "systems" DETAIL: Key (id)=(4)
is still referenced from table "systems". (PG::Error)
Now the system has disappeared from the "Systems>All" view. It is still
listed in the System Group but I'm getting errors while trying to modify anything.
The second problem I'm having is what led me to this issue. I created two environments
Library>Mobile and Library>Servers.
When I try to change the registered system from Library to Library>Servers I have to
pick a content view it comes up empty. When I choose the default Library, I see
"Default Content view" and my own published content view.
How do I associate a content view to the correct environment?
For the rest the 1.4 release is looking very nice.
Kind regards,
Jorick Astrego
Netbulae B.V.
7:47 a.m.
New subject: Content View Definitions problems
Jorick,
It looks like we have a foreign key bug with content views that belong to systems. After
you hit it, you begin to get the other errors you've hit as the pulp content is
deleted even though the content view is not. I've reproduced this and opened a bug:
https://github.com/Katello/katello/issues/3287d
As for moving or creating a system in a non-Library environment, you have to have a
content view in that environment. This can be done by promoting a content view into that
environment in the changesets section. Let us know if you need more help.
Thanks.
David
----- Original Message -----
| From: "Jorick Astrego" <j.astrego(a)netbulae.eu>
| To: katello(a)lists.fedorahosted.org
| Sent: Wednesday, October 30, 2013 8:30:22 AM
| Subject: Content View Definitions problems
|
| Hi,
|
| Somehow I got problems with the "Content View Definitions"
|
| I configured a "New view definition" and used the Publish button. After that
| I used the Publish option a second time.
|
| I now have two content views and I try to remove one of them, I get the
| following error:
|
| Wed, 30 Oct 2013 11:18:48 +0000 error Netbulae Failed to generate version 2
| of content view 'Servers'.
| 404 Resource Not Found (RestClient::ResourceNotFound)
| {"http_request_method": "GET", "exception": null,
"error_message": "Missing
| resource(s): repo=Netbulae-Library-Servers-Fedora19-i386_os", "_href":
| "/pulp/api/v2/repositories/Netbulae-Library-Servers-Fedora19-i386_os/",
| "http_status": 404, "traceback": null, "resources":
{"repo":
| "Netbulae-Library-Servers-Fedora19-i386_os"}}
| Wed, 30 Oct 2013 11:18:24 +0000 error Netbulae 404 Resource Not Found
| (RestClient::ResourceNotFound)
| {"http_request_method": "POST", "exception": null,
"error_message": "Missing
| resource(s): repo_id=Netbulae-Library-Servers-Fedora19-i386_os",
"_href":
|
"/pulp/api/v2/repositories/Netbulae-Library-Servers-Fedora19-i386_os/search/units/",
| "http_status": 404, "traceback": null, "resources":
{"repo_id":
| "Netbulae-Library-Servers-Fedora19-i386_os"}}
| Wed, 30 Oct 2013 11:18:16 +0000 error Netbulae ERROR: update or delete on
| table "content_views" violates foreign key constraint
| "systems_content_view_id_fk" on table "systems" DETAIL: Key (id)=(4)
is
| still referenced from table "systems". (PG::Error)
|
| Now the system has disappeared from the "Systems>All" view. It is still
| listed in the System Group but I'm getting errors while trying to modify
| anything.
|
|
| The second problem I'm having is what led me to this issue. I created two
| environments Library>Mobile and Library>Servers.
| When I try to change the registered system from Library to Library>Servers I
| have to pick a content view it comes up empty. When I choose the default
| Library, I see "Default Content view" and my own published content view.
| How do I associate a content view to the correct environment?
|
| For the rest the 1.4 release is looking very nice.
|
| Kind regards,
|
| Jorick Astrego
| Netbulae B.V.
|
|
|
|
|
| _______________________________________________
| katello mailing list
| katello(a)lists.fedorahosted.org
| https://lists.fedorahosted.org/mailman/listinfo/katello
|
1:59 p.m.
On 10/24/2013 07:15 PM, Jason Frisvold wrote:
Hi!
I'm looking at Katello 1.4 right now and I've run into an issue
upgrading my server. The katello-upgrade script is complaining that it
did not return zero and suggests I try again. I did just that and....
it gave me the same answer.
I am seeing a few errors in the logs. First is this :
looks like it is the result of this bug:
https://bugzilla.redhat.com/show_bug.cgi?id=993644
myself and others are reproducing the issue locally and working on a
workaround that might get you past this.
Mike
--
Mike McCune
mmccune AT redhat.com
Red Hat Engineering | Portland, OR
Systems Management | 650-254-4248
4:09 p.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 10/25/2013 02:59 PM, Mike McCune wrote:
looks like it is the result of this bug:
https://bugzilla.redhat.com/show_bug.cgi?id=993644
myself and others are reproducing the issue locally and working on
a workaround that might get you past this.
I just re-created the symlinks and that fixed the error about the file
not being there.
But.. re-running the upgrade still fails. I get this during the
mongo migration step :
10/25/13 16:54:44 Starting step Migrate MongoDB database
10/25/13 16:54:44
/usr/lib/python2.6/site-packages/pulp/server/db/connection.py:103:
DeprecationWarning: The safe parameter is deprecated. Please use write co
ncern options instead.
10/25/13 16:54:44 return method(*args, **kwargs)
10/25/13 16:59:00 Applying migration
pulp_rpm.migrations.0011_new_importer failed. See log for details.
10/25/13 16:59:00 2013-10-25 16:59:00,076 db:CRITICAL: Applying
migration pulp_rpm.migrations.0011_new_importer failed.
10/25/13 16:59:00 2013-10-25 16:59:00,076 db:CRITICAL: 'repodata'
10/25/13 16:59:00 2013-10-25 16:59:00,098 db:CRITICAL: Traceback (most
recent call last):
10/25/13 16:59:00 File
"/usr/lib/python2.6/site-packages/pulp/server/db/manage.py", line 79,
in migrate_database
10/25/13 16:59:00 update_current_version=not options.test)
10/25/13 16:59:00 File
"/usr/lib/python2.6/site-packages/pulp/server/db/migrate/models.py",
line 161, in apply_migration
10/25/13 16:59:00 migration.migrate()
10/25/13 16:59:00 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0011_new_importer.py",
line 29, in migrate
10/25/13 16:59:00 _migrate_collection(type_id)
10/25/13 16:59:00 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0011_new_importer.py",
line 39, in _migrate_collection
10/25/13 16:59:00 text = package['repodata']['primary'].encode(codec)
10/25/13 16:59:00 KeyError: 'repodata'
10/25/13 16:59:00
10/25/13 16:59:02 Beginning database migrations.
10/25/13 16:59:02 Migration package pulp.server.db.migrations is up to
date at version 6
10/25/13 16:59:02 Migration package pulp_puppet.plugins.migrations is
up to date at version 0
10/25/13 16:59:02 Applying pulp_rpm.migrations version 7
10/25/13 16:59:02 Migration to pulp_rpm.migrations version 7 complete.
10/25/13 16:59:02 Applying pulp_rpm.migrations version 8
10/25/13 16:59:02 Migration to pulp_rpm.migrations version 8 complete.
10/25/13 16:59:02 Applying pulp_rpm.migrations version 9
10/25/13 16:59:02 Migration to pulp_rpm.migrations version 9 complete.
10/25/13 16:59:02 Applying pulp_rpm.migrations version 10
10/25/13 16:59:02 Migration to pulp_rpm.migrations version 10 complete.
10/25/13 16:59:02 Applying pulp_rpm.migrations version 11
10/25/13 16:59:02 Database migrations complete.
10/25/13 16:59:02 Loading content types.
10/25/13 16:59:02 Content types loaded.
10/25/13 16:59:02 Successfuly finished step: Migrate MongoDB database
Not sure what's wrong there.. It says that step completed, despite
the errors. Then we get to the part where it starts foreman, it seems
to start foreman and then errors out :
Step: Start foreman service (9/16)
Runs: always
Description: Start the service
Do you want to proceed with this step?: [(y)es/(n)o/(s)kip]: y
Starting step Start foreman service
Starting foreman: Starting server on 127.0.0.1:5500 ...
Starting server on 127.0.0.1:5501 ...
[ OK ]
Upgrade script did not return zero, investigate, stop services and
re-run upgrade.
More info in /var/log/katello/katello_upgrade.log
Foreman is apparently dead, though :
$ katello-service status
tomcat6 (pid 21813) is running... [ OK ]
httpd (pid 21646) is running...
mongod (pid 21587) is running...
qpidd (pid 21538) is running...
elasticsearch (pid 21906) is running...
Foreman dead but pid file exists
dead but pid file exists
katello is not running.
delayed_job is not running.
delayed_job_monitor is not running.
There's a big nasty ruby error in the foreman log.. here's a snippet :
/opt/rh/ruby193/root/usr/share/gems/gems/thin-1.3.1/lib/thin/daemonizing.rb:158:in
`delete': Permission denied - tmp/pids/thin.5501.pid (Errno::EACCES)
from
/opt/rh/ruby193/root/usr/share/gems/gems/thin-1.3.1/lib/thin/daemonizing.rb:158:in
`remove_pid_file'
from
/opt/rh/ruby193/root/usr/share/gems/gems/thin-1.3.1/lib/thin/daemonizing.rb:59:in
`block in daemonize'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/inheritance.rb:143:in
`rescue in find_sti_class': The single-table inheritance mechanism
failed to locate the subclass: 'General'. This error is raised because
the column 'category' is reserved for storing the class in case of
inheritance. Please rename this column if you didn't intend it to be
used for storing the inheritance class or overwrite
Setting.inheritance_column to use another column for that information.
(ActiveRecord::SubclassNotFound)
from
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/inheritance.rb:136:in
`find_sti_class'
Thoughts?
Mike
- --
- ---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
- ---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- - Niven's Inverse of Clarke's Third Law
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.15 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
iEYEARECAAYFAlJq3hcACgkQO80o6DJ8UvmYawCfSqbjvghrCGH7+utB+LkL5oKS
S6wAmwQb1ZfMzzwgkB0GTNgHl+JoH0Di
=5/l6
-----END PGP SIGNATURE-----
5:28 p.m.
----- Original Message -----
From: "Jason 'XenoPhage' Frisvold"
<xenophage(a)godshell.com>
To: "Mike McCune" <mmccune(a)redhat.com>, katello(a)lists.fedorahosted.org
Sent: Friday, October 25, 2013 5:09:43 PM
Subject: Re: Katello 1.4 Upgrade Failure
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
But.. re-running the upgrade still fails. I get this during the
mongo migration step :
10/25/13 16:54:44 Starting step Migrate MongoDB database
10/25/13 16:54:44
/usr/lib/python2.6/site-packages/pulp/server/db/connection.py:103:
DeprecationWarning: The safe parameter is deprecated. Please use write co
ncern options instead.
10/25/13 16:54:44 return method(*args, **kwargs)
10/25/13 16:59:00 Applying migration
pulp_rpm.migrations.0011_new_importer failed. See log for details.
10/25/13 16:59:00 2013-10-25 16:59:00,076 db:CRITICAL: Applying
migration pulp_rpm.migrations.0011_new_importer failed.
10/25/13 16:59:00 2013-10-25 16:59:00,076 db:CRITICAL: 'repodata'
10/25/13 16:59:00 2013-10-25 16:59:00,098 db:CRITICAL: Traceback (most
recent call last):
10/25/13 16:59:00 File
"/usr/lib/python2.6/site-packages/pulp/server/db/manage.py", line 79,
in migrate_database
10/25/13 16:59:00 update_current_version=not options.test)
10/25/13 16:59:00 File
"/usr/lib/python2.6/site-packages/pulp/server/db/migrate/models.py",
line 161, in apply_migration
10/25/13 16:59:00 migration.migrate()
10/25/13 16:59:00 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0011_new_importer.py",
line 29, in migrate
10/25/13 16:59:00 _migrate_collection(type_id)
10/25/13 16:59:00 File
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0011_new_importer.py",
line 39, in _migrate_collection
10/25/13 16:59:00 text =
package['repodata']['primary'].encode(codec)
10/25/13 16:59:00 KeyError: 'repodata'
10/25/13 16:59:00
10/25/13 16:59:02 Beginning database migrations.
10/25/13 16:59:02 Migration package pulp.server.db.migrations is up to
date at version 6
10/25/13 16:59:02 Migration package pulp_puppet.plugins.migrations is
up to date at version 0
10/25/13 16:59:02 Applying pulp_rpm.migrations version 7
10/25/13 16:59:02 Migration to pulp_rpm.migrations version 7 complete.
10/25/13 16:59:02 Applying pulp_rpm.migrations version 8
10/25/13 16:59:02 Migration to pulp_rpm.migrations version 8 complete.
10/25/13 16:59:02 Applying pulp_rpm.migrations version 9
10/25/13 16:59:02 Migration to pulp_rpm.migrations version 9 complete.
10/25/13 16:59:02 Applying pulp_rpm.migrations version 10
10/25/13 16:59:02 Migration to pulp_rpm.migrations version 10 complete.
10/25/13 16:59:02 Applying pulp_rpm.migrations version 11
10/25/13 16:59:02 Database migrations complete.
10/25/13 16:59:02 Loading content types.
10/25/13 16:59:02 Content types loaded.
10/25/13 16:59:02 Successfuly finished step: Migrate MongoDB database
Not sure what's wrong there.. It says that step completed, despite
the errors. Then we get to the part where it starts foreman, it seems
to start foreman and then errors out :
Step: Start foreman service (9/16)
Runs: always
Description: Start the service
Do you want to proceed with this step?: [(y)es/(n)o/(s)kip]: y
Starting step Start foreman service
Starting foreman: Starting server on 127.0.0.1:5500 ...
Starting server on 127.0.0.1:5501 ...
[ OK ]
Upgrade script did not return zero, investigate, stop services and
re-run upgrade.
More info in /var/log/katello/katello_upgrade.log
Foreman is apparently dead, though :
$ katello-service status
tomcat6 (pid 21813) is running... [ OK ]
httpd (pid 21646) is running...
mongod (pid 21587) is running...
qpidd (pid 21538) is running...
elasticsearch (pid 21906) is running...
Foreman dead but pid file exists
dead but pid file exists
katello is not running.
delayed_job is not running.
delayed_job_monitor is not running.
There's a big nasty ruby error in the foreman log.. here's a snippet :
/opt/rh/ruby193/root/usr/share/gems/gems/thin-1.3.1/lib/thin/daemonizing.rb:158:in
`delete': Permission denied - tmp/pids/thin.5501.pid (Errno::EACCES)
from
/opt/rh/ruby193/root/usr/share/gems/gems/thin-1.3.1/lib/thin/daemonizing.rb:158:in
`remove_pid_file'
from
/opt/rh/ruby193/root/usr/share/gems/gems/thin-1.3.1/lib/thin/daemonizing.rb:59:in
`block in daemonize'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/inheritance.rb:143:in
`rescue in find_sti_class': The single-table inheritance mechanism
failed to locate the subclass: 'General'. This error is raised because
the column 'category' is reserved for storing the class in case of
inheritance. Please rename this column if you didn't intend it to be
used for storing the inheritance class or overwrite
Setting.inheritance_column to use another column for that information.
(ActiveRecord::SubclassNotFound)
from
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/inheritance.rb:136:in
`find_sti_class'
Thoughts?
Curious about your setup. Did you have foreman setup with Katello 1.3 and are trying to
migrate upwards to 1.4?
Or dd you are you trying to do something like a yum update katello-foreman-all and then
running the upgrade scripts.
Would it be possible for you to send me or mike your
/var/log/katello/katello-configure/main.log and the upgrade log so that we can trace this
better..
Partha
5:33 p.m.
----- Original Message -----
From: "Partha Aji" <paji(a)redhat.com>
To: katello(a)lists.fedorahosted.org
Sent: Friday, October 25, 2013 6:28:11 PM
Subject: Re: Katello 1.4 Upgrade Failure
----- Original Message -----
> From: "Jason 'XenoPhage' Frisvold" <xenophage(a)godshell.com>
> To: "Mike McCune" <mmccune(a)redhat.com>,
katello(a)lists.fedorahosted.org
> Sent: Friday, October 25, 2013 5:09:43 PM
> Subject: Re: Katello 1.4 Upgrade Failure
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> But.. re-running the upgrade still fails. I get this during the
> mongo migration step :
>
> 10/25/13 16:54:44 Starting step Migrate MongoDB database
> 10/25/13 16:54:44
> /usr/lib/python2.6/site-packages/pulp/server/db/connection.py:103:
> DeprecationWarning: The safe parameter is deprecated. Please use write co
> ncern options instead.
> 10/25/13 16:54:44 return method(*args, **kwargs)
> 10/25/13 16:59:00 Applying migration
> pulp_rpm.migrations.0011_new_importer failed. See log for details.
> 10/25/13 16:59:00 2013-10-25 16:59:00,076 db:CRITICAL: Applying
> migration pulp_rpm.migrations.0011_new_importer failed.
> 10/25/13 16:59:00 2013-10-25 16:59:00,076 db:CRITICAL: 'repodata'
> 10/25/13 16:59:00 2013-10-25 16:59:00,098 db:CRITICAL: Traceback (most
> recent call last):
> 10/25/13 16:59:00 File
> "/usr/lib/python2.6/site-packages/pulp/server/db/manage.py", line 79,
> in migrate_database
> 10/25/13 16:59:00 update_current_version=not options.test)
> 10/25/13 16:59:00 File
> "/usr/lib/python2.6/site-packages/pulp/server/db/migrate/models.py",
> line 161, in apply_migration
> 10/25/13 16:59:00 migration.migrate()
> 10/25/13 16:59:00 File
>
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0011_new_importer.py",
> line 29, in migrate
> 10/25/13 16:59:00 _migrate_collection(type_id)
> 10/25/13 16:59:00 File
>
"/usr/lib/python2.6/site-packages/pulp_rpm/migrations/0011_new_importer.py",
> line 39, in _migrate_collection
> 10/25/13 16:59:00 text =
package['repodata']['primary'].encode(codec)
> 10/25/13 16:59:00 KeyError: 'repodata'
> 10/25/13 16:59:00
> 10/25/13 16:59:02 Beginning database migrations.
> 10/25/13 16:59:02 Migration package pulp.server.db.migrations is up to
> date at version 6
> 10/25/13 16:59:02 Migration package pulp_puppet.plugins.migrations is
> up to date at version 0
> 10/25/13 16:59:02 Applying pulp_rpm.migrations version 7
> 10/25/13 16:59:02 Migration to pulp_rpm.migrations version 7 complete.
> 10/25/13 16:59:02 Applying pulp_rpm.migrations version 8
> 10/25/13 16:59:02 Migration to pulp_rpm.migrations version 8 complete.
> 10/25/13 16:59:02 Applying pulp_rpm.migrations version 9
> 10/25/13 16:59:02 Migration to pulp_rpm.migrations version 9 complete.
> 10/25/13 16:59:02 Applying pulp_rpm.migrations version 10
> 10/25/13 16:59:02 Migration to pulp_rpm.migrations version 10 complete.
> 10/25/13 16:59:02 Applying pulp_rpm.migrations version 11
> 10/25/13 16:59:02 Database migrations complete.
> 10/25/13 16:59:02 Loading content types.
> 10/25/13 16:59:02 Content types loaded.
> 10/25/13 16:59:02 Successfuly finished step: Migrate MongoDB database
>
> Not sure what's wrong there.. It says that step completed, despite
> the errors. Then we get to the part where it starts foreman, it seems
> to start foreman and then errors out :
>
> Step: Start foreman service (9/16)
> Runs: always
> Description: Start the service
>
> Do you want to proceed with this step?: [(y)es/(n)o/(s)kip]: y
> Starting step Start foreman service
> Starting foreman: Starting server on 127.0.0.1:5500 ...
> Starting server on 127.0.0.1:5501 ...
> [ OK ]
> Upgrade script did not return zero, investigate, stop services and
> re-run upgrade.
> More info in /var/log/katello/katello_upgrade.log
>
> Foreman is apparently dead, though :
>
> $ katello-service status
> tomcat6 (pid 21813) is running... [ OK ]
> httpd (pid 21646) is running...
> mongod (pid 21587) is running...
> qpidd (pid 21538) is running...
> elasticsearch (pid 21906) is running...
> Foreman dead but pid file exists
> dead but pid file exists
> katello is not running.
> delayed_job is not running.
> delayed_job_monitor is not running.
>
> There's a big nasty ruby error in the foreman log.. here's a snippet :
>
> /opt/rh/ruby193/root/usr/share/gems/gems/thin-1.3.1/lib/thin/daemonizing.rb:158:in
> `delete': Permission denied - tmp/pids/thin.5501.pid (Errno::EACCES)
> from
> /opt/rh/ruby193/root/usr/share/gems/gems/thin-1.3.1/lib/thin/daemonizing.rb:158:in
> `remove_pid_file'
> from
> /opt/rh/ruby193/root/usr/share/gems/gems/thin-1.3.1/lib/thin/daemonizing.rb:59:in
> `block in daemonize'
>
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/inheritance.rb:143:in
> `rescue in find_sti_class': The single-table inheritance mechanism
> failed to locate the subclass: 'General'. This error is raised because
> the column 'category' is reserved for storing the class in case of
> inheritance. Please rename this column if you didn't intend it to be
> used for storing the inheritance class or overwrite
> Setting.inheritance_column to use another column for that information.
> (ActiveRecord::SubclassNotFound)
> from
>
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/inheritance.rb:136:in
> `find_sti_class'
>
>
> Thoughts?
>
>
Partha
_______________________________________________
katello mailing list
katello(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/katello
Sorry last email didn't come out right. I meant to say that I was curious
about your setup.
a) Did you have foreman setup with Katello 1.3 via katello-configure-foreman and are now
trying to updgrade to 1.4? OR
b) You installed foreman as a separate entity after installing katello 1.3, and are now
trying to upgrade katello
In any case would it be possible for you to send me or mike your
/var/log/katello/katello-configure/main.log and the upgrade log so that we can trace this
better..
Thanks
Partha
8:25 p.m.
Partha Aji wrote:
Sorry last email didn't come out right. I meant to say that I was
curious about your setup.
a) Did you have foreman setup with Katello 1.3 via katello-configure-foreman and are now
trying to updgrade to 1.4? OR
I believe it's this one. I installed katello-configure-foreman.
In any case would it be possible for you to send me or mike your
/var/log/katello/katello-configure/main.log and the upgrade log so that we can trace this
better..
Yup. On its way.
Thanks
Partha
--
---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- Niven's Inverse of Clarke's Third Law
10:32 p.m.
Jason Frisvold wrote:
> In any case would it be possible for you to send me or mike your
/var/log/katello/katello-configure/main.log and the upgrade log so that we can trace this
better..
Yup. On its way.
Any luck with the data I sent?
--
---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- Niven's Inverse of Clarke's Third Law
5:20 p.m.
Hey Jason,
Apologize for the delay. I did try upgrading from a katello 1.3 installed via
katello-configure-foreman to katello 1.4. Unfortunately the foreman migration from 1.1 to
1.3 is non trivial and its a major change including changes in configuration files etc. At
this point I cannot help with this issue much other than say, try uninstalling foreman
packages from katello 1.3 and then try upgrading katello.
Partha
----- Original Message -----
From: "Jason Frisvold" <xenophage(a)godshell.com>
To: katello(a)lists.fedorahosted.org
Sent: Wednesday, November 13, 2013 11:32:33 PM
Subject: Re: Katello 1.4 Upgrade Failure
Jason Frisvold wrote:
>> In any case would it be possible for you to send me or mike your
>> /var/log/katello/katello-configure/main.log and the upgrade log so that
>> we can trace this better..
>
> Yup. On its way.
Any luck with the data I sent?
--
---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- Niven's Inverse of Clarke's Third Law
_______________________________________________
katello mailing list
katello(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/katello
9:28 p.m.
Partha Aji wrote:
Hey Jason,
Apologize for the delay. I did try upgrading from a katello 1.3 installed via
katello-configure-foreman to katello 1.4. Unfortunately the foreman migration from 1.1 to
1.3 is non trivial and its a major change including changes in configuration files etc. At
this point I cannot help with this issue much other than say, try uninstalling foreman
packages from katello 1.3 and then try upgrading katello.
No problem. Tried your suggestion, same error. So I skipped the
foreman step. I get to step 12, the database migration and I get an
error about foreign key violations. Any suggestions?
11/15/13 22:19:15 Starting step Migrate Katello database
11/15/13 22:19:19 WARNING: Nokogiri was built against LibXML version
2.9.0, but has dynamically loaded 2.7.6
11/15/13 22:19:21 ** Invoke db:migrate (first_time)
11/15/13 22:19:21 ** Invoke environment (first_time)
11/15/13 22:19:21 ** Execute environment
11/15/13 22:19:25 ** Invoke db:load_config (first_time)
11/15/13 22:19:25 ** Execute db:load_config
11/15/13 22:19:25 ** Execute db:migrate
11/15/13 22:19:25 rake aborted!
11/15/13 22:19:25 An error has occurred, this and all later migrations
canceled:
11/15/13 22:19:25
11/15/13 22:19:25 PGError: ERROR: insert or update on table
"changeset_users" violates foreign key constraint
"changeset_users_changeset_id_fk"
11/15/13 22:19:25 DETAIL: Key (changeset_id)=(1) is not present in
table "changesets".
11/15/13 22:19:25 : ALTER TABLE "changeset_users" ADD CONSTRAINT
"changeset_users_changeset_id_fk" FOREIGN KEY ("changeset_id")
REFERENCES "changesets"(id) INITIALLY DEFERRED
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`async_exec'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`block in execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
`block in log'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in
`instrument'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
`log'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in
`execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:19:in
`add_foreign_key'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:466:in
`block in method_missing'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`block in say_with_time'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`say_with_time'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:458:in
`method_missing'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:334:in
`method_missing'
11/15/13 22:19:25
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:5:in
`add_foreign_key_deferred'
11/15/13 22:19:25
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:51:in `up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:370:in
`up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block (2 levels) in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:123:in
`with_connection'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:389:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:528:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:720:in
`block (2 levels) in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`call'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`block in ddl_transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in
`transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in
`transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`ddl_transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:719:in
`block in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:570:in
`up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:551:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:153:in
`block (2 levels) in <top (required)>'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `call'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `block in execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:158:in `block in
invoke_with_call_chain'
11/15/13 22:19:25 /opt/rh/ruby193/root/usr/share/ruby/monitor.rb:211:in
`mon_synchronize'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:151:in
`invoke_with_call_chain'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:144:in `invoke'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:116:in `invoke_task'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block (2
levels) in top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block in
top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:88:in `top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:66:in `block in run'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:63:in `run'
11/15/13 22:19:25 /opt/rh/ruby193/root/usr/bin/rake:32:in `<main>'
11/15/13 22:19:25 caused by: (PGError) ERROR: insert or update on table
"changeset_users" violates foreign key constraint
"changeset_users_changeset_id_fk"
11/15/13 22:19:25 DETAIL: Key (changeset_id)=(1) is not present in
table "changesets".
11/15/13 22:19:25
11/15/13 22:19:25 ... skipped 52 lines
11/15/13 22:19:25 caused by: (ActiveRecord::InvalidForeignKey) PGError:
ERROR: insert or update on table "changeset_users" violates foreign key
constraint "changeset_users_changeset_id_fk"
11/15/13 22:19:25 DETAIL: Key (changeset_id)=(1) is not present in
table "changesets".
11/15/13 22:19:25 : ALTER TABLE "changeset_users" ADD CONSTRAINT
"changeset_users_changeset_id_fk" FOREIGN KEY ("changeset_id")
REFERENCES "changesets"(id) INITIALLY DEFERRED
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`async_exec'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`block in execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
`block in log'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in
`instrument'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
`log'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in
`execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:19:in
`add_foreign_key'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:466:in
`block in method_missing'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`block in say_with_time'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`say_with_time'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:458:in
`method_missing'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:334:in
`method_missing'
11/15/13 22:19:25
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:5:in
`add_foreign_key_deferred'
11/15/13 22:19:25
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:51:in `up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:370:in
`up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block (2 levels) in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:123:in
`with_connection'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:389:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:528:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:720:in
`block (2 levels) in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`call'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`block in ddl_transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in
`transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in
`transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`ddl_transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:719:in
`block in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:570:in
`up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:551:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:153:in
`block (2 levels) in <top (required)>'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `call'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `block in execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:158:in `block in
invoke_with_call_chain'
11/15/13 22:19:25 /opt/rh/ruby193/root/usr/share/ruby/monitor.rb:211:in
`mon_synchronize'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:151:in
`invoke_with_call_chain'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:144:in `invoke'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:116:in `invoke_task'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block (2
levels) in top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block in
top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:88:in `top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:66:in `block in run'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:63:in `run'
11/15/13 22:19:25 /opt/rh/ruby193/root/usr/bin/rake:32:in `<main>'
11/15/13 22:19:25 ... skipped 0 lines
11/15/13 22:19:25 caused by: (PGError) ERROR: insert or update on table
"changeset_users" violates foreign key constraint
"changeset_users_changeset_id_fk"
11/15/13 22:19:25 DETAIL: Key (changeset_id)=(1) is not present in
table "changesets".
11/15/13 22:19:25
11/15/13 22:19:25 ... skipped 52 lines
11/15/13 22:19:25 Tasks: TOP => db:migrate
11/15/13 22:19:25 == AddForeignKeys: migrating
=================================================
11/15/13 22:19:25 -- execute("delete from providers where
organization_id not in (select id from organizations)")
11/15/13 22:19:25 -> 0.0008s
11/15/13 22:19:25 -- execute("delete from task_statuses where
organization_id not in (select id from organizations)")
11/15/13 22:19:25 -> 0.0008s
11/15/13 22:19:25 -- execute("delete from notices where organization_id
not in (select id from organizations)")
11/15/13 22:19:25 -> 0.0008s
11/15/13 22:19:25 -- execute("delete from user_notices where user_id not
in (select id from users)")
11/15/13 22:19:25 -> 0.0007s
11/15/13 22:19:25 -- execute("delete from user_notices where user_id is
null")
11/15/13 22:19:25 -> 0.0002s
11/15/13 22:19:25 -- execute("delete from user_notices where notice_id
not in (select id from notices)")
11/15/13 22:19:25 -> 0.0004s
11/15/13 22:19:25 -- execute("delete from pools where id in (select
pool_id from key_pools where activation_key_id not in (select id from
activation_keys))")
11/15/13 22:19:25 -> 0.0008s
11/15/13 22:19:25 -- execute("delete from key_pools where
activation_key_id not in (select id from activation_keys)")
11/15/13 22:19:25 -> 0.0002s
11/15/13 22:19:25 -- execute("delete from key_system_groups where
activation_key_id not in (select id from activation_keys)")
11/15/13 22:19:25 -> 0.0003s
11/15/13 22:19:25 -- execute("delete from marketing_engineering_products
where engineering_product_id not in (select id from products)")
11/15/13 22:19:25 -> 0.0005s
11/15/13 22:19:25 -- execute("delete from roles_users where role_id not
in (select id from roles)")
11/15/13 22:19:25 -> 0.0005s
11/15/13 22:19:25 -- execute("delete from roles_users where user_id not
in (select id from users)")
11/15/13 22:19:25 -> 0.0002s
11/15/13 22:19:25 -- add_foreign_key("activation_keys",
"content_views",
{:name=>"activation_keys_content_view_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0026s
11/15/13 22:19:25 -- add_foreign_key("activation_keys",
"environments",
{:name=>"activation_keys_environment_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0016s
11/15/13 22:19:25 -- add_foreign_key("activation_keys",
"organizations",
{:name=>"activation_keys_organization_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0013s
11/15/13 22:19:25 -- add_foreign_key("activation_keys", "users",
{:name=>"activation_keys_user_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0013s
11/15/13 22:19:25 -- add_foreign_key("changeset_content_views",
"changesets", {:name=>"changeset_content_views_changeset_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0131s
11/15/13 22:19:25 -- add_foreign_key("changeset_content_views",
"content_views",
{:name=>"changeset_content_views_content_view_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0012s
11/15/13 22:19:25 -- add_foreign_key("changeset_dependencies",
"changesets", {:name=>"changeset_dependencies_changeset_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0239s
11/15/13 22:19:25 -- add_foreign_key("changeset_dependencies",
"products", {:name=>"changeset_dependencies_product_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0014s
11/15/13 22:19:25 -- add_foreign_key("changeset_distributions",
"changesets", {:name=>"changeset_distributions_changeset_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0015s
11/15/13 22:19:25 -- add_foreign_key("changeset_distributions",
"products", {:name=>"changeset_distributions_product_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0013s
11/15/13 22:19:25 -- add_foreign_key("changeset_errata",
"changesets",
{:name=>"changeset_errata_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0178s
11/15/13 22:19:25 -- add_foreign_key("changeset_errata", "products",
{:name=>"changeset_errata_product_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0012s
11/15/13 22:19:25 -- add_foreign_key("changeset_packages",
"changesets",
{:name=>"changeset_packages_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0014s
11/15/13 22:19:25 -- add_foreign_key("changeset_packages",
"products",
{:name=>"changeset_packages_product_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0013s
11/15/13 22:19:25 -- add_foreign_key("changeset_users", "changesets",
{:name=>"changeset_users_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
Partha
--
---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- Niven's Inverse of Clarke's Third Law
10:24 p.m.
Hey Jason,
Try updating your katello-all again. The latest version should fix this very issue.
Partha
On Nov 15, 2013, at 10:29 PM, Jason Frisvold
<xenophage(a)godshell.com> wrote:
Partha Aji wrote:
> Hey Jason,
> Apologize for the delay. I did try upgrading from a katello 1.3 installed via
katello-configure-foreman to katello 1.4. Unfortunately the foreman migration from 1.1 to
1.3 is non trivial and its a major change including changes in configuration files etc. At
this point I cannot help with this issue much other than say, try uninstalling foreman
packages from katello 1.3 and then try upgrading katello.
No problem. Tried your suggestion, same error. So I skipped the
foreman step. I get to step 12, the database migration and I get an
error about foreign key violations. Any suggestions?
11/15/13 22:19:15 Starting step Migrate Katello database
11/15/13 22:19:19 WARNING: Nokogiri was built against LibXML version
2.9.0, but has dynamically loaded 2.7.6
11/15/13 22:19:21 ** Invoke db:migrate (first_time)
11/15/13 22:19:21 ** Invoke environment (first_time)
11/15/13 22:19:21 ** Execute environment
11/15/13 22:19:25 ** Invoke db:load_config (first_time)
11/15/13 22:19:25 ** Execute db:load_config
11/15/13 22:19:25 ** Execute db:migrate
11/15/13 22:19:25 rake aborted!
11/15/13 22:19:25 An error has occurred, this and all later migrations
canceled:
11/15/13 22:19:25
11/15/13 22:19:25 PGError: ERROR: insert or update on table
"changeset_users" violates foreign key constraint
"changeset_users_changeset_id_fk"
11/15/13 22:19:25 DETAIL: Key (changeset_id)=(1) is not present in
table "changesets".
11/15/13 22:19:25 : ALTER TABLE "changeset_users" ADD CONSTRAINT
"changeset_users_changeset_id_fk" FOREIGN KEY ("changeset_id")
REFERENCES "changesets"(id) INITIALLY DEFERRED
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`async_exec'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`block in execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
`block in log'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in
`instrument'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
`log'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in
`execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:19:in
`add_foreign_key'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:466:in
`block in method_missing'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`block in say_with_time'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`say_with_time'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:458:in
`method_missing'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:334:in
`method_missing'
11/15/13 22:19:25
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:5:in
`add_foreign_key_deferred'
11/15/13 22:19:25
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:51:in `up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:370:in
`up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block (2 levels) in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:123:in
`with_connection'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:389:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:528:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:720:in
`block (2 levels) in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`call'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`block in ddl_transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in
`transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in
`transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`ddl_transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:719:in
`block in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:570:in
`up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:551:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:153:in
`block (2 levels) in <top (required)>'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `call'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `block in execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:158:in `block in
invoke_with_call_chain'
11/15/13 22:19:25 /opt/rh/ruby193/root/usr/share/ruby/monitor.rb:211:in
`mon_synchronize'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:151:in
`invoke_with_call_chain'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:144:in `invoke'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:116:in `invoke_task'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block (2
levels) in top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block in
top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:88:in `top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:66:in `block in run'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:63:in `run'
11/15/13 22:19:25 /opt/rh/ruby193/root/usr/bin/rake:32:in `<main>'
11/15/13 22:19:25 caused by: (PGError) ERROR: insert or update on table
"changeset_users" violates foreign key constraint
"changeset_users_changeset_id_fk"
11/15/13 22:19:25 DETAIL: Key (changeset_id)=(1) is not present in
table "changesets".
11/15/13 22:19:25
11/15/13 22:19:25 ... skipped 52 lines
11/15/13 22:19:25 caused by: (ActiveRecord::InvalidForeignKey) PGError:
ERROR: insert or update on table "changeset_users" violates foreign key
constraint "changeset_users_changeset_id_fk"
11/15/13 22:19:25 DETAIL: Key (changeset_id)=(1) is not present in
table "changesets".
11/15/13 22:19:25 : ALTER TABLE "changeset_users" ADD CONSTRAINT
"changeset_users_changeset_id_fk" FOREIGN KEY ("changeset_id")
REFERENCES "changesets"(id) INITIALLY DEFERRED
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`async_exec'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`block in execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
`block in log'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in
`instrument'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
`log'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in
`execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:19:in
`add_foreign_key'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:466:in
`block in method_missing'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`block in say_with_time'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`say_with_time'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:458:in
`method_missing'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:334:in
`method_missing'
11/15/13 22:19:25
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:5:in
`add_foreign_key_deferred'
11/15/13 22:19:25
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:51:in `up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:370:in
`up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block (2 levels) in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:123:in
`with_connection'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:389:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:528:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:720:in
`block (2 levels) in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`call'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`block in ddl_transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in
`transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in
`transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`ddl_transaction'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:719:in
`block in migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:570:in
`up'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:551:in
`migrate'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:153:in
`block (2 levels) in <top (required)>'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `call'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `block in execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `execute'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:158:in `block in
invoke_with_call_chain'
11/15/13 22:19:25 /opt/rh/ruby193/root/usr/share/ruby/monitor.rb:211:in
`mon_synchronize'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:151:in
`invoke_with_call_chain'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:144:in `invoke'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:116:in `invoke_task'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block (2
levels) in top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `each'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block in
top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:88:in `top_level'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:66:in `block in run'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
11/15/13 22:19:25
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:63:in `run'
11/15/13 22:19:25 /opt/rh/ruby193/root/usr/bin/rake:32:in `<main>'
11/15/13 22:19:25 ... skipped 0 lines
11/15/13 22:19:25 caused by: (PGError) ERROR: insert or update on table
"changeset_users" violates foreign key constraint
"changeset_users_changeset_id_fk"
11/15/13 22:19:25 DETAIL: Key (changeset_id)=(1) is not present in
table "changesets".
11/15/13 22:19:25
11/15/13 22:19:25 ... skipped 52 lines
11/15/13 22:19:25 Tasks: TOP => db:migrate
11/15/13 22:19:25 == AddForeignKeys: migrating
=================================================
11/15/13 22:19:25 -- execute("delete from providers where
organization_id not in (select id from organizations)")
11/15/13 22:19:25 -> 0.0008s
11/15/13 22:19:25 -- execute("delete from task_statuses where
organization_id not in (select id from organizations)")
11/15/13 22:19:25 -> 0.0008s
11/15/13 22:19:25 -- execute("delete from notices where organization_id
not in (select id from organizations)")
11/15/13 22:19:25 -> 0.0008s
11/15/13 22:19:25 -- execute("delete from user_notices where user_id not
in (select id from users)")
11/15/13 22:19:25 -> 0.0007s
11/15/13 22:19:25 -- execute("delete from user_notices where user_id is
null")
11/15/13 22:19:25 -> 0.0002s
11/15/13 22:19:25 -- execute("delete from user_notices where notice_id
not in (select id from notices)")
11/15/13 22:19:25 -> 0.0004s
11/15/13 22:19:25 -- execute("delete from pools where id in (select
pool_id from key_pools where activation_key_id not in (select id from
activation_keys))")
11/15/13 22:19:25 -> 0.0008s
11/15/13 22:19:25 -- execute("delete from key_pools where
activation_key_id not in (select id from activation_keys)")
11/15/13 22:19:25 -> 0.0002s
11/15/13 22:19:25 -- execute("delete from key_system_groups where
activation_key_id not in (select id from activation_keys)")
11/15/13 22:19:25 -> 0.0003s
11/15/13 22:19:25 -- execute("delete from marketing_engineering_products
where engineering_product_id not in (select id from products)")
11/15/13 22:19:25 -> 0.0005s
11/15/13 22:19:25 -- execute("delete from roles_users where role_id not
in (select id from roles)")
11/15/13 22:19:25 -> 0.0005s
11/15/13 22:19:25 -- execute("delete from roles_users where user_id not
in (select id from users)")
11/15/13 22:19:25 -> 0.0002s
11/15/13 22:19:25 -- add_foreign_key("activation_keys",
"content_views",
{:name=>"activation_keys_content_view_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0026s
11/15/13 22:19:25 -- add_foreign_key("activation_keys",
"environments",
{:name=>"activation_keys_environment_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0016s
11/15/13 22:19:25 -- add_foreign_key("activation_keys",
"organizations",
{:name=>"activation_keys_organization_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0013s
11/15/13 22:19:25 -- add_foreign_key("activation_keys", "users",
{:name=>"activation_keys_user_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0013s
11/15/13 22:19:25 -- add_foreign_key("changeset_content_views",
"changesets", {:name=>"changeset_content_views_changeset_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0131s
11/15/13 22:19:25 -- add_foreign_key("changeset_content_views",
"content_views",
{:name=>"changeset_content_views_content_view_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0012s
11/15/13 22:19:25 -- add_foreign_key("changeset_dependencies",
"changesets", {:name=>"changeset_dependencies_changeset_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0239s
11/15/13 22:19:25 -- add_foreign_key("changeset_dependencies",
"products", {:name=>"changeset_dependencies_product_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0014s
11/15/13 22:19:25 -- add_foreign_key("changeset_distributions",
"changesets", {:name=>"changeset_distributions_changeset_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0015s
11/15/13 22:19:25 -- add_foreign_key("changeset_distributions",
"products", {:name=>"changeset_distributions_product_id_fk",
:options=>"INITIALLY DEFERRED"})
11/15/13 22:19:25 -> 0.0013s
11/15/13 22:19:25 -- add_foreign_key("changeset_errata",
"changesets",
{:name=>"changeset_errata_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0178s
11/15/13 22:19:25 -- add_foreign_key("changeset_errata", "products",
{:name=>"changeset_errata_product_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0012s
11/15/13 22:19:25 -- add_foreign_key("changeset_packages",
"changesets",
{:name=>"changeset_packages_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0014s
11/15/13 22:19:25 -- add_foreign_key("changeset_packages",
"products",
{:name=>"changeset_packages_product_id_fk", :options=>"INITIALLY
DEFERRED"})
11/15/13 22:19:25 -> 0.0013s
11/15/13 22:19:25 -- add_foreign_key("changeset_users",
"changesets",
{:name=>"changeset_users_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
> Partha
--
---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- Niven's Inverse of Clarke's Third Law
_______________________________________________
katello mailing list
katello(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/katello
8:59 a.m.
Partha Aji wrote:
Hey Jason,
Try updating your katello-all again. The latest version should fix this very issue.
Sort of.. It fixed the issue with those specific tables. Now I'm
getting a similar error on other tables.
An error has occurred, this and all later migrations canceled:
PGError: ERROR: insert or update on table
"content_view_definition_bases" violates foreign key constraint
"content_view_definition_bases_source_id_fk"
DETAIL: Key (source_id)=(2) is not present in table
"content_view_definition_bases".
: ALTER TABLE "content_view_definition_bases" ADD CONSTRAINT
"content_view_definition_bases_source_id_fk" FOREIGN KEY
("source_id")
REFERENCES "content_view_definition_bases"(id) INITIALLY DEFERRED
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`async_exec'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`block in execute'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
`block in log'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in
`instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
`log'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in
`execute'
/opt/rh/ruby193/root/usr/share/gems/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:19:in
`add_foreign_key'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:466:in
`block in method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`block in say_with_time'
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`say_with_time'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:458:in
`method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:334:in
`method_missing'
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:5:in
`add_foreign_key_deferred'
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:77:in `up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:370:in
`up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block (2 levels) in migrate'
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:123:in
`with_connection'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:389:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:528:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:720:in
`block (2 levels) in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`block in ddl_transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in
`transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in
`transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`ddl_transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:719:in
`block in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`each'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:570:in
`up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:551:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:153:in
`block (2 levels) in <top (required)>'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `call'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `block in execute'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `each'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `execute'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:158:in `block in
invoke_with_call_chain'
/opt/rh/ruby193/root/usr/share/ruby/monitor.rb:211:in `mon_synchronize'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:151:in
`invoke_with_call_chain'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:144:in `invoke'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:116:in `invoke_task'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block (2
levels) in top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `each'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block in
top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:88:in `top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:66:in `block in run'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:63:in `run'
/opt/rh/ruby193/root/usr/bin/rake:32:in `<main>'
caused by: (PGError) ERROR: insert or update on table
"content_view_definition_bases" violates foreign key constraint
"content_view_definition_bases_source_id_fk"
DETAIL: Key (source_id)=(2) is not present in table
"content_view_definition_bases".
... skipped 52 lines
caused by: (ActiveRecord::InvalidForeignKey) PGError: ERROR: insert or
update on table "content_view_definition_bases" violates foreign key
constraint "content_view_definition_bases_source_id_fk"
DETAIL: Key (source_id)=(2) is not present in table
"content_view_definition_bases".
: ALTER TABLE "content_view_definition_bases" ADD CONSTRAINT
"content_view_definition_bases_source_id_fk" FOREIGN KEY
("source_id")
REFERENCES "content_view_definition_bases"(id) INITIALLY DEFERRED
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`async_exec'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`block in execute'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
`block in log'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in
`instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
`log'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in
`execute'
/opt/rh/ruby193/root/usr/share/gems/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:19:in
`add_foreign_key'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:466:in
`block in method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`block in say_with_time'
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`say_with_time'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:458:in
`method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:334:in
`method_missing'
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:5:in
`add_foreign_key_deferred'
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:77:in `up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:370:in
`up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block (2 levels) in migrate'
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:123:in
`with_connection'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:389:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:528:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:720:in
`block (2 levels) in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`block in ddl_transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in
`transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in
`transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`ddl_transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:719:in
`block in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`each'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:570:in
`up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:551:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:153:in
`block (2 levels) in <top (required)>'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `call'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `block in execute'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `each'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `execute'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:158:in `block in
invoke_with_call_chain'
/opt/rh/ruby193/root/usr/share/ruby/monitor.rb:211:in `mon_synchronize'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:151:in
`invoke_with_call_chain'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:144:in `invoke'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:116:in `invoke_task'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block (2
levels) in top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `each'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block in
top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:88:in `top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:66:in `block in run'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:63:in `run'
/opt/rh/ruby193/root/usr/bin/rake:32:in `<main>'
... skipped 0 lines
caused by: (PGError) ERROR: insert or update on table
"content_view_definition_bases" violates foreign key constraint
"content_view_definition_bases_source_id_fk"
DETAIL: Key (source_id)=(2) is not present in table
"content_view_definition_bases".
... skipped 52 lines
Tasks: TOP => db:migrate
== AddForeignKeys: migrating
=================================================
-- execute("delete from providers where organization_id not in (select
id from organizations)")
-> 0.0007s
-- execute("delete from task_statuses where organization_id not in
(select id from organizations)")
-> 0.0008s
-- execute("delete from notices where organization_id not in (select id
from organizations)")
-> 0.0006s
-- execute("delete from user_notices where user_id not in (select id
from users)")
-> 0.0006s
-- execute("delete from user_notices where user_id is null")
-> 0.0001s
-- execute("delete from user_notices where notice_id not in (select id
from notices)")
-> 0.0004s
-- execute("delete from pools where id in (select pool_id from key_pools
where activation_key_id not in (select id from activation_keys))")
-> 0.0009s
-- execute("delete from key_pools where activation_key_id not in (select
id from activation_keys)")
-> 0.0001s
-- execute("delete from key_system_groups where activation_key_id not in
(select id from activation_keys)")
-> 0.0003s
-- execute("delete from marketing_engineering_products where
engineering_product_id not in (select id from products)")
-> 0.0005s
-- execute("delete from roles_users where role_id not in (select id from
roles)")
-> 0.0004s
-- execute("delete from roles_users where user_id not in (select id from
users)")
-> 0.0002s
-- execute("delete from changeset_content_views where content_view_id
not in (select id from content_views)")
-> 0.0004s
-- execute("delete from changeset_users where user_id not in (select id
from users)")
-> 0.0003s
-- execute("delete from changeset_users where changeset_id not in
(select id from changesets)")
-> 0.0003s
-- add_foreign_key("activation_keys", "content_views",
{:name=>"activation_keys_content_view_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.2933s
-- add_foreign_key("activation_keys", "environments",
{:name=>"activation_keys_environment_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0016s
-- add_foreign_key("activation_keys", "organizations",
{:name=>"activation_keys_organization_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("activation_keys", "users",
{:name=>"activation_keys_user_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changeset_content_views", "changesets",
{:name=>"changeset_content_views_changeset_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changeset_content_views", "content_views",
{:name=>"changeset_content_views_content_view_id_fk",
:options=>"INITIALLY DEFERRED"})
-> 0.0300s
-- add_foreign_key("changeset_dependencies", "changesets",
{:name=>"changeset_dependencies_changeset_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0021s
-- add_foreign_key("changeset_dependencies", "products",
{:name=>"changeset_dependencies_product_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changeset_distributions", "changesets",
{:name=>"changeset_distributions_changeset_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0015s
-- add_foreign_key("changeset_distributions", "products",
{:name=>"changeset_distributions_product_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changeset_errata", "changesets",
{:name=>"changeset_errata_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changeset_errata", "products",
{:name=>"changeset_errata_product_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0012s
-- add_foreign_key("changeset_packages", "changesets",
{:name=>"changeset_packages_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0015s
-- add_foreign_key("changeset_packages", "products",
{:name=>"changeset_packages_product_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changeset_users", "changesets",
{:name=>"changeset_users_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changeset_users", "users",
{:name=>"changeset_users_user_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changesets", "environments",
{:name=>"changesets_environment_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0012s
-- add_foreign_key("changesets_products", "changesets",
{:name=>"changesets_products_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0114s
-- add_foreign_key("changesets_products", "products",
{:name=>"changesets_products_product_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changesets_repositories", "changesets",
{:name=>"changesets_repositories_changeset_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changesets_repositories", "repositories",
{:name=>"changesets_repositories_repository_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0251s
-- add_foreign_key("changesets", "task_statuses",
{:name=>"changesets_task_status_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("component_content_views",
"content_view_definition_bases",
{:name=>"component_content_views_content_view_definition_id_fk",
:column=>"content_view_definition_id", :options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("component_content_views", "content_views",
{:name=>"component_content_views_content_view_id_fk",
:options=>"INITIALLY DEFERRED"})
-> 0.0012s
-- add_foreign_key("content_view_definition_bases", "organizations",
{:name=>"content_view_definition_bases_organization_id_fk",
:options=>"INITIALLY DEFERRED"})
-> 0.0016s
-- add_foreign_key("content_view_definition_bases",
"content_view_definition_bases",
{:name=>"content_view_definition_bases_source_id_fk",
:column=>"source_id", :options=>"INITIALLY DEFERRED"})
Partha
--
---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- Niven's Inverse of Clarke's Third Law
5:36 p.m.
Hey Jason,
Will look into fixing this soon.
Thanks
Partha
----- Original Message -----
From: "Jason Frisvold" <xenophage(a)godshell.com>
To: katello(a)lists.fedorahosted.org
Sent: Sunday, November 17, 2013 9:59:45 AM
Subject: Re: Katello 1.4 Upgrade Failure
Partha Aji wrote:
> Hey Jason,
> Try updating your katello-all again. The latest version should fix this
> very issue.
Sort of.. It fixed the issue with those specific tables. Now I'm
getting a similar error on other tables.
An error has occurred, this and all later migrations canceled:
PGError: ERROR: insert or update on table
"content_view_definition_bases" violates foreign key constraint
"content_view_definition_bases_source_id_fk"
DETAIL: Key (source_id)=(2) is not present in table
"content_view_definition_bases".
: ALTER TABLE "content_view_definition_bases" ADD CONSTRAINT
"content_view_definition_bases_source_id_fk" FOREIGN KEY
("source_id")
REFERENCES "content_view_definition_bases"(id) INITIALLY DEFERRED
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`async_exec'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`block in execute'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
`block in log'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in
`instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
`log'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in
`execute'
/opt/rh/ruby193/root/usr/share/gems/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:19:in
`add_foreign_key'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:466:in
`block in method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`block in say_with_time'
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`say_with_time'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:458:in
`method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:334:in
`method_missing'
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:5:in
`add_foreign_key_deferred'
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:77:in `up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:370:in
`up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block (2 levels) in migrate'
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:123:in
`with_connection'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:389:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:528:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:720:in
`block (2 levels) in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`block in ddl_transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in
`transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in
`transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`ddl_transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:719:in
`block in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`each'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:570:in
`up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:551:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:153:in
`block (2 levels) in <top (required)>'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `call'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `block in execute'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `each'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `execute'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:158:in `block in
invoke_with_call_chain'
/opt/rh/ruby193/root/usr/share/ruby/monitor.rb:211:in `mon_synchronize'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:151:in
`invoke_with_call_chain'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:144:in `invoke'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:116:in `invoke_task'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block (2
levels) in top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `each'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block in
top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:88:in `top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:66:in `block in run'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:63:in `run'
/opt/rh/ruby193/root/usr/bin/rake:32:in `<main>'
caused by: (PGError) ERROR: insert or update on table
"content_view_definition_bases" violates foreign key constraint
"content_view_definition_bases_source_id_fk"
DETAIL: Key (source_id)=(2) is not present in table
"content_view_definition_bases".
... skipped 52 lines
caused by: (ActiveRecord::InvalidForeignKey) PGError: ERROR: insert or
update on table "content_view_definition_bases" violates foreign key
constraint "content_view_definition_bases_source_id_fk"
DETAIL: Key (source_id)=(2) is not present in table
"content_view_definition_bases".
: ALTER TABLE "content_view_definition_bases" ADD CONSTRAINT
"content_view_definition_bases_source_id_fk" FOREIGN KEY
("source_id")
REFERENCES "content_view_definition_bases"(id) INITIALLY DEFERRED
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`async_exec'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:654:in
`block in execute'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:280:in
`block in log'
/opt/rh/ruby193/root/usr/share/gems/gems/activesupport-3.2.8/lib/active_support/notifications/instrumenter.rb:20:in
`instrument'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:275:in
`log'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/postgresql_adapter.rb:653:in
`execute'
/opt/rh/ruby193/root/usr/share/gems/gems/foreigner-1.4.2/lib/foreigner/connection_adapters/sql2003.rb:19:in
`add_foreign_key'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:466:in
`block in method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`block in say_with_time'
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:438:in
`say_with_time'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:458:in
`method_missing'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:334:in
`method_missing'
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:5:in
`add_foreign_key_deferred'
/usr/share/katello/db/migrate/20130613090036_add_foreign_keys.rb:77:in `up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:370:in
`up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block (2 levels) in migrate'
/opt/rh/ruby193/root/usr/share/ruby/benchmark.rb:280:in `measure'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:410:in
`block in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:123:in
`with_connection'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:389:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:528:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:720:in
`block (2 levels) in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`call'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`block in ddl_transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in
`transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/transactions.rb:208:in
`transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:775:in
`ddl_transaction'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:719:in
`block in migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`each'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:700:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:570:in
`up'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/migration.rb:551:in
`migrate'
/opt/rh/ruby193/root/usr/share/gems/gems/activerecord-3.2.8/lib/active_record/railties/databases.rake:153:in
`block (2 levels) in <top (required)>'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `call'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:205:in `block in execute'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `each'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:200:in `execute'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:158:in `block in
invoke_with_call_chain'
/opt/rh/ruby193/root/usr/share/ruby/monitor.rb:211:in `mon_synchronize'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:151:in
`invoke_with_call_chain'
/opt/rh/ruby193/root/usr/share/ruby/rake/task.rb:144:in `invoke'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:116:in `invoke_task'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block (2
levels) in top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `each'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:94:in `block in
top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:88:in `top_level'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:66:in `block in run'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:133:in
`standard_exception_handling'
/opt/rh/ruby193/root/usr/share/ruby/rake/application.rb:63:in `run'
/opt/rh/ruby193/root/usr/bin/rake:32:in `<main>'
... skipped 0 lines
caused by: (PGError) ERROR: insert or update on table
"content_view_definition_bases" violates foreign key constraint
"content_view_definition_bases_source_id_fk"
DETAIL: Key (source_id)=(2) is not present in table
"content_view_definition_bases".
... skipped 52 lines
Tasks: TOP => db:migrate
== AddForeignKeys: migrating
=================================================
-- execute("delete from providers where organization_id not in (select
id from organizations)")
-> 0.0007s
-- execute("delete from task_statuses where organization_id not in
(select id from organizations)")
-> 0.0008s
-- execute("delete from notices where organization_id not in (select id
from organizations)")
-> 0.0006s
-- execute("delete from user_notices where user_id not in (select id
from users)")
-> 0.0006s
-- execute("delete from user_notices where user_id is null")
-> 0.0001s
-- execute("delete from user_notices where notice_id not in (select id
from notices)")
-> 0.0004s
-- execute("delete from pools where id in (select pool_id from key_pools
where activation_key_id not in (select id from activation_keys))")
-> 0.0009s
-- execute("delete from key_pools where activation_key_id not in (select
id from activation_keys)")
-> 0.0001s
-- execute("delete from key_system_groups where activation_key_id not in
(select id from activation_keys)")
-> 0.0003s
-- execute("delete from marketing_engineering_products where
engineering_product_id not in (select id from products)")
-> 0.0005s
-- execute("delete from roles_users where role_id not in (select id from
roles)")
-> 0.0004s
-- execute("delete from roles_users where user_id not in (select id from
users)")
-> 0.0002s
-- execute("delete from changeset_content_views where content_view_id
not in (select id from content_views)")
-> 0.0004s
-- execute("delete from changeset_users where user_id not in (select id
from users)")
-> 0.0003s
-- execute("delete from changeset_users where changeset_id not in
(select id from changesets)")
-> 0.0003s
-- add_foreign_key("activation_keys", "content_views",
{:name=>"activation_keys_content_view_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.2933s
-- add_foreign_key("activation_keys", "environments",
{:name=>"activation_keys_environment_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0016s
-- add_foreign_key("activation_keys", "organizations",
{:name=>"activation_keys_organization_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("activation_keys", "users",
{:name=>"activation_keys_user_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changeset_content_views", "changesets",
{:name=>"changeset_content_views_changeset_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changeset_content_views", "content_views",
{:name=>"changeset_content_views_content_view_id_fk",
:options=>"INITIALLY DEFERRED"})
-> 0.0300s
-- add_foreign_key("changeset_dependencies", "changesets",
{:name=>"changeset_dependencies_changeset_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0021s
-- add_foreign_key("changeset_dependencies", "products",
{:name=>"changeset_dependencies_product_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changeset_distributions", "changesets",
{:name=>"changeset_distributions_changeset_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0015s
-- add_foreign_key("changeset_distributions", "products",
{:name=>"changeset_distributions_product_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changeset_errata", "changesets",
{:name=>"changeset_errata_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changeset_errata", "products",
{:name=>"changeset_errata_product_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0012s
-- add_foreign_key("changeset_packages", "changesets",
{:name=>"changeset_packages_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0015s
-- add_foreign_key("changeset_packages", "products",
{:name=>"changeset_packages_product_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changeset_users", "changesets",
{:name=>"changeset_users_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changeset_users", "users",
{:name=>"changeset_users_user_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changesets", "environments",
{:name=>"changesets_environment_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0012s
-- add_foreign_key("changesets_products", "changesets",
{:name=>"changesets_products_changeset_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0114s
-- add_foreign_key("changesets_products", "products",
{:name=>"changesets_products_product_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("changesets_repositories", "changesets",
{:name=>"changesets_repositories_changeset_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("changesets_repositories", "repositories",
{:name=>"changesets_repositories_repository_id_fk",
:options=>"INITIALLY
DEFERRED"})
-> 0.0251s
-- add_foreign_key("changesets", "task_statuses",
{:name=>"changesets_task_status_id_fk", :options=>"INITIALLY
DEFERRED"})
-> 0.0014s
-- add_foreign_key("component_content_views",
"content_view_definition_bases",
{:name=>"component_content_views_content_view_definition_id_fk",
:column=>"content_view_definition_id", :options=>"INITIALLY
DEFERRED"})
-> 0.0013s
-- add_foreign_key("component_content_views", "content_views",
{:name=>"component_content_views_content_view_id_fk",
:options=>"INITIALLY DEFERRED"})
-> 0.0012s
-- add_foreign_key("content_view_definition_bases", "organizations",
{:name=>"content_view_definition_bases_organization_id_fk",
:options=>"INITIALLY DEFERRED"})
-> 0.0016s
-- add_foreign_key("content_view_definition_bases",
"content_view_definition_bases",
{:name=>"content_view_definition_bases_source_id_fk",
:column=>"source_id", :options=>"INITIALLY DEFERRED"})
> Partha
--
---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- Niven's Inverse of Clarke's Third Law
_______________________________________________
katello mailing list
katello(a)lists.fedorahosted.org
https://lists.fedorahosted.org/mailman/listinfo/katello
8:23 p.m.
Partha Aji wrote:
Curious about your setup. Did you have foreman setup with Katello 1.3
and are trying to migrate upwards to 1.4?
Or dd you are you trying to do something like a yum update katello-foreman-all and then
running the upgrade scripts.
Would it be possible for you to send me or mike your
/var/log/katello/katello-configure/main.log and the upgrade log so that we can trace this
better..
I had katello first and then installed katello-foreman, I believe. And
now I'm trying to do a yum upgrade to version 1.4.
Yes, I'll send my mail.log off to you both in a moment.
Partha
--
---------------------------
Jason 'XenoPhage' Frisvold
xenophage(a)godshell.com
---------------------------
"Any sufficiently advanced magic is indistinguishable from technology.\"
- Niven's Inverse of Clarke's Third Law
3820
days inactive
3844
days old
katello@lists.fedorahosted.org
22 comments
5 participants
participants (5)
-
David Davis -
Jason Frisvold -
Jorick Astrego -
Mike McCune -
Partha Aji