[katello-devel] Failure updating nightly build
Og Maciel
omaciel at redhat.com
Mon Apr 15 22:31:34 UTC 2013
Tried to update katello nightly (Saturday build to Sunday build) and it fails with:
Command output: INFO 4/15/13 6:28 PM:liquibase: Successfully acquired change log lock
INFO 4/15/13 6:28 PM:liquibase: Reading from databasechangelog
INFO 4/15/13 6:28 PM:liquibase: Reading from databasechangelog
SEVERE 4/15/13 6:28 PM:liquibase: Change Set db/changelog/20130315171104-migrate-upstream-uuid.xml::20130315171104-1::jesusr failed. Error: Error executing SQL INSERT INTO cp_upstream_consumer (id, uuid, name, owner_id,
type_id, prefix_url_web)
SELECT ir.id,
ir.upstream_id,
ir.upstream_name,
ir.owner_id,
ct.id,
ir.webapp_prefix
FROM cp_import_record ir,
cp_consumer_type ct
WHERE ct.label = ir.upstream_type
AND ir.status = 0: ERROR: column ir.upstream_name does not exist
Position: 169
liquibase.exception.DatabaseException: Error executing SQL INSERT INTO cp_upstream_consumer (id, uuid, name, owner_id,
type_id, prefix_url_web)
SELECT ir.id,
ir.upstream_id,
ir.upstream_name,
ir.owner_id,
ct.id,
ir.webapp_prefix
FROM cp_import_record ir,
cp_consumer_type ct
WHERE ct.label = ir.upstream_type
AND ir.status = 0: ERROR: column ir.upstream_name does not exist
Position: 169
at liquibase.executor.jvm.JdbcExecutor.execute(Unknown Source)
at liquibase.executor.jvm.JdbcExecutor.execute(Unknown Source)
at liquibase.database.AbstractDatabase.execute(Unknown Source)
at liquibase.database.AbstractDatabase.executeStatements(Unknown Source)
at liquibase.changelog.ChangeSet.execute(Unknown Source)
at liquibase.changelog.visitor.UpdateVisitor.visit(Unknown Source)
at liquibase.changelog.ChangeLogIterator.run(Unknown Source)
at liquibase.Liquibase.update(Unknown Source)
at liquibase.integration.commandline.Main.doMigration(Unknown Source)
at liquibase.integration.commandline.Main.main(Unknown Source)
Caused by: org.postgresql.util.PSQLException: ERROR: column ir.upstream_name does not exist
Position: 169
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(Unknown Source)
... 10 more
INFO 4/15/13 6:28 PM:liquibase: Successfully released change log lock
Liquibase Update Failed: Error executing SQL INSERT INTO cp_upstream_consumer (id, uuid, name, owner_id,
type_id, prefix_url_web)
SELECT ir.id,
ir.upstream_id,
ir.upstream_name,
ir.owner_id,
ct.id,
ir.webapp_prefix
FROM cp_import_record ir,
cp_consumer_type ct
WHERE ct.label = ir.upstream_type
AND ir.status = 0: ERROR: column ir.upstream_name does not exist
Position: 169
SEVERE 4/15/13 6:28 PM:liquibase: Error executing SQL INSERT INTO cp_upstream_consumer (id, uuid, name, owner_id,
type_id, prefix_url_web)
SELECT ir.id,
ir.upstream_id,
ir.upstream_name,
ir.owner_id,
ct.id,
ir.webapp_prefix
FROM cp_import_record ir,
cp_consumer_type ct
WHERE ct.label = ir.upstream_type
AND ir.status = 0: ERROR: column ir.upstream_name does not exist
Position: 169
liquibase.exception.MigrationFailedException: Migration failed for change set db/changelog/20130315171104-migrate-upstream-uuid.xml::20130315171104-1::jesusr:
Reason: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO cp_upstream_consumer (id, uuid, name, owner_id,
type_id, prefix_url_web)
SELECT ir.id,
ir.upstream_id,
ir.upstream_name,
ir.owner_id,
ct.id,
ir.webapp_prefix
FROM cp_import_record ir,
cp_consumer_type ct
WHERE ct.label = ir.upstream_type
AND ir.status = 0: ERROR: column ir.upstream_name does not exist
Position: 169:
Caused By: Error executing SQL INSERT INTO cp_upstream_consumer (id, uuid, name, owner_id,
type_id, prefix_url_web)
SELECT ir.id,
ir.upstream_id,
ir.upstream_name,
ir.owner_id,
ct.id,
ir.webapp_prefix
FROM cp_import_record ir,
cp_consumer_type ct
WHERE ct.label = ir.upstream_type
AND ir.status = 0: ERROR: column ir.upstream_name does not exist
Position: 169:
Caused By: ERROR: column ir.upstream_name does not exist
Position: 169
at liquibase.changelog.ChangeSet.execute(Unknown Source)
at liquibase.changelog.visitor.UpdateVisitor.visit(Unknown Source)
at liquibase.changelog.ChangeLogIterator.run(Unknown Source)
at liquibase.Liquibase.update(Unknown Source)
at liquibase.integration.commandline.Main.doMigration(Unknown Source)
at liquibase.integration.commandline.Main.main(Unknown Source)
Caused by: liquibase.exception.DatabaseException: Error executing SQL INSERT INTO cp_upstream_consumer (id, uuid, name, owner_id,
type_id, prefix_url_web)
SELECT ir.id,
ir.upstream_id,
ir.upstream_name,
ir.owner_id,
ct.id,
ir.webapp_prefix
FROM cp_import_record ir,
cp_consumer_type ct
WHERE ct.label = ir.upstream_type
AND ir.status = 0: ERROR: column ir.upstream_name does not exist
Position: 169
at liquibase.executor.jvm.JdbcExecutor.execute(Unknown Source)
at liquibase.executor.jvm.JdbcExecutor.execute(Unknown Source)
at liquibase.database.AbstractDatabase.execute(Unknown Source)
at liquibase.database.AbstractDatabase.executeStatements(Unknown Source)
... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: column ir.upstream_name does not exist
Position: 169
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:345)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(Unknown Source)
... 10 more
For more information, use the --logLevel flag)
Migrating candlepin database
Traceback (most recent call last):
File "./cpdb", line 146, in <module>
dbsetup.update()
File "./cpdb", line 80, in update
self._run_liquibase("db/changelog/changelog-update.xml")
File "./cpdb", line 103, in _run_liquibase
self.community))
File "./cpdb", line 32, in run_command
error_out(command, status, output)
File "./cpdb", line 40, in error_out
raise Exception("Error running command")
Exception: Error running command
Upgrade script did not return zero, investigate, stop services and re-run upgrade.
More info in /var/log/katello/katello_upgrade.log
katello.upgrade.log shows:
04/15/13 18:21:29 Starting step Migrate candlepin database
04/15/13 18:21:31
04/15/13 18:21:31 ########## ERROR ############
04/15/13 18:21:31 Error running command: liquibase --driver=org.postgresql.Driver --classpath=/usr/share/java/postgresql-jdbc.jar:/var/lib/tomcat6/webapps/candlepin/WEB-INF/classes/ --changeLogFile=db/changelog/changelog-update.xml --url=jdbc:postgresql:candlepin --username=candlepin --password=candlepin migrate -Dcommunity=False
04/15/13 18:21:31 Status code: 65280
--
Og Maciel
Supervisor, Quality Engineering
Red Hat, Inc.
+1.646.707.7723
irc: omaciel
More information about the katello-devel
mailing list