install errors
Jeff Stettenbenz <[email protected]>
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <6DD31B66918F704CB0E70D6025BE4E23A22BD0481A@MAILBOX-01.qcommcorp.ad> |
On a new installation of OpenNMS I get the following errors:
Exception in thread "main" org.opennms.core.schema.MigrationException: unable to update the database
at org.opennms.core.schema.Migrator.migrate(Migrator.java:415)
at org.opennms.install.Installer.install(Installer.java:294)
at org.opennms.install.Installer.main(Installer.java:964)
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set 1.7.1/datalinkinterface.xml::1.7.1-datalinkinterface-index::mattraykow:
Reason: liquibase.exception.JDBCException: Error executing SQL ALTER TABLE datalinkinterface DROP CONSTRAINT pk_datalinkinterface:
Caused By: Error executing SQL ALTER TABLE datalinkinterface DROP CONSTRAINT pk_datalinkinterface:
Caused By: ERROR: constraint "pk_datalinkinterface" does not exist
at liquibase.ChangeSet.execute(ChangeSet.java:236)
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)
... 2 more
Caused by: 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)
... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: constraint "pk_datalinkinterface" does not exist
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.database.template.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:79)
at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:49)
... 10 more
===================================================
I am using the following software:
CentOS release 4.7 (Final)
-------------
Name : opennms
Arch : noarch
Version: 1.8.3
Release: 1
----
Name : postgresql
Arch : i386
Version: 7.4.29
Release: 1.el4_8.1
--- -
I have searched all morning, and found that I could manually modify the tables, but no step by step instructions were given. Could anyone help?
I did a standard install, followed each direction in order.
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-install mailing list
To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install