Fresh install of 1.10 branch throws exception when updating schema
Description
INFO: Changeset 1.7.8/changelog.xml::1.7.8-remove-old-primary-key-if-necessary::rangerrick::(MD5Sum: 13aca6d37fc83f562e345d8c8f2db498) Jul 29, 2011 3:03:37 PM liquibase.ChangeSet execute INFO: Change set 1.7.8/changelog.xml::1.7.8-remove-old-primary-key-if-necessary::rangerrick failed, but failOnError was false liquibase.exception.JDBCException: Error executing SQL ALTER TABLE datalinkinterface DROP CONSTRAINT pk_datalinkinterface at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:56) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:87) at liquibase.change.AbstractChange.execute(AbstractChange.java:251) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:97) at liquibase.ChangeSet.execute(ChangeSet.java:212) at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26) at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41) at liquibase.Liquibase.update(Liquibase.java:112) at org.opennms.core.schema.Migrator.migrate(Migrator.java:412) at org.opennms.install.Installer.install(Installer.java:258) at org.opennms.install.Installer.main(Installer.java:931) Caused by: org.postgresql.util.PSQLException: ERROR: constraint "pk_datalinkinterface" of relation "datalinkinterface" does not exist at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366) at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:79) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:49) ... 10 more
Acceptance / Success Criteria
None
Lucidchart Diagrams
Activity
Show:
Benjamin Reed July 29, 2011 at 9:23 AM
This is normal, it's resolving an issue that could occur if you were upgrading from a particular release in the 1.7.x series.
INFO: Changeset 1.7.8/changelog.xml::1.7.8-remove-old-primary-key-if-necessary::rangerrick::(MD5Sum: 13aca6d37fc83f562e345d8c8f2db498)
Jul 29, 2011 3:03:37 PM liquibase.ChangeSet execute
INFO: Change set 1.7.8/changelog.xml::1.7.8-remove-old-primary-key-if-necessary::rangerrick failed, but failOnError was false
liquibase.exception.JDBCException: Error executing SQL ALTER TABLE datalinkinterface DROP CONSTRAINT pk_datalinkinterface
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:56)
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:87)
at liquibase.change.AbstractChange.execute(AbstractChange.java:251)
at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:97)
at liquibase.ChangeSet.execute(ChangeSet.java:212)
at liquibase.parser.visitor.UpdateVisitor.visit(UpdateVisitor.java:26)
at liquibase.parser.ChangeLogIterator.run(ChangeLogIterator.java:41)
at liquibase.Liquibase.update(Liquibase.java:112)
at org.opennms.core.schema.Migrator.migrate(Migrator.java:412)
at org.opennms.install.Installer.install(Installer.java:258)
at org.opennms.install.Installer.main(Installer.java:931)
Caused by: org.postgresql.util.PSQLException: ERROR: constraint "pk_datalinkinterface" of relation "datalinkinterface" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
at liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:79)
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:49)
... 10 more