I got this error
INFO: Successfully released change log lock
Exception in thread "main" org.opennms.core.schema.MigrationException: unable
to update the database
at org.opennms.core.schema.Migrator.migrate(Migrator.java:72)
at org.opennms.install.Installer.install(Installer.java:284)
at org.opennms.install.Installer.main(Installer.java:860)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for
change set sequences.xml::opennmsnxtid::rangerrick:
Reason: liquibase.exception.JDBCException: Error executing SQL CREATE
SEQUENCE opennmsnxtid:
Caused By: Error executing SQL CREATE SEQUENCE opennmsnxtid:
Caused By: ERROR: relation "opennmsnxtid" already exists
at liquibase.ChangeSet.execute(ChangeSet.java:238)
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:69)
... 2 more
Caused by: liquibase.exception.JDBCException: Error executing SQL CREATE
SEQUENCE opennmsnxtid
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:214)
... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "opennmsnxtid"
already exists
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:332)
at
liquibase.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:79)
at
liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:49)
... 10 more
-----Original Message-----
From: Benjamin Reed [mailto:ran...@opennms.org]
Sent: Friday, May 29, 2009 1:39 PM
To: General OpenNMS Discussion; OpenNMS Code Development and Bugs
Subject: [opennms-devel] WARNING: database volatility in 1.7.x snapshots
starting tomorrow -- please help test!!
So I've finished the work on transitioning to liquibase for revisions to the
database.
I believe I've found all of the bugs (both on upgrading, and fresh
install) but it's a rather large change to the way we create our database
schema. Be forewarned, if you're playing with OpenNMS 1.7.x snapshots, be
prepared to back up your database first before upgrading to a snapshot of
revision 13498 or higher.
That said, I would really appreciate feedback from testers, letting me know if
they ran into any issues after the update.
Thanks!
--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/
Confidentiality Notice: This page and any accompanying documents contain
information that is confidential, privileged, or exempt from disclosure under
applicable law and is intended for the exclusive use of the addressee. This
information is private and protected by law. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or use of the contents of this information in any manner is strictly prohibited.
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-devel mailing list
To *unsubscribe* or change your subscription options, see the bottom of this
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
