**RAN:install -disU GET ERROR
- checking for rows that violate constraint 'ifservices_fkey1'... Exception in thread "main" java.lang.Exception: Table outages contains 516 rows (out of 50633) that violate new constraint ifservices_fkey1. See the install guide for details on how to correct this problem. You can execute this SQL query to see a list of the rows that violate the constraint:
SELECT * FROM outages LEFT JOIN ifservices ON (outages.nodeid = ifservices.nodeid AND outages.ipaddr = ifservices.ipaddr AND outages.serviceid = ifservices.serviceid) WHERE ifservices.nodeid is NULL AND outages.nodeid IS NOT NULL AND outages.ipaddr IS NOT NULL AND outages.serviceid IS NOT NULL
at org.opennms.netmgt.dao.db.InstallerDb.checkConstraint(InstallerDb.java:1500)
at org.opennms.netmgt.dao.db.InstallerDb.checkConstraints(InstallerDb.java:1442)
at org.opennms.install.Installer.install(Installer.java:196)
at org.opennms.install.Installer.main(Installer.java:729)
**RAN: install -C ifservices_fkey1 GET ERROR
- fixing rows that violate constraint ifservices_fkey1... Exception in thread "main" org.postgresql.util.PSQLException: ERROR: null value in column "ipaddr" violates not-null constraint
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.executeUpdate(AbstractJdbc2Statement.java:286)
at org.opennms.netmgt.dao.db.InstallerDb.fixConstraint(InstallerDb.java:1662)
at org.opennms.netmgt.dao.db.InstallerDb.fixConstraint(InstallerDb.java:1595)
at org.opennms.install.Installer.install(Installer.java:189)
at org.opennms.install.Installer.main(Installer.java:729)
**RAN: install -C ifservices_fkey1 -X CLEANED UP ERROR
- fixing rows that violate constraint ifservices_fkey1... DELETED 516 ROWS
Installer completed successfully!
**RAN: install -disU ERROR
- checking trigger 'setSnmpInterfaceKeysOnUpdateTrigger' on this table... DONE
FAILED! Old data restored, however indexes and constraints on this table were not re-added
Exception in thread "main" java.lang.Exception: Error changing table 'ipinterface'. Nested exception: Statement.execute() threw an SQLException while inserting a row: "INSERT INTO ipinterface (ifindex, ipaddr, iphostname, iplastcapsdpoll, ipstatus, ismanaged, issnmpprimary, nodeid) values (-100, xxx.xxx.252.9, xxx.xxx.xxx, 2006-06-14 22:52:25.583000 -0400, NULL, M, C, 305)". Original exception: org.postgresql.util.PSQLException: ERROR: IpInterface Trigger Notice, Condition 1: No SnmpInterface found for... nodeid: 305 ifindex: -100
at org.opennms.netmgt.dao.db.InstallerDb.createTables(InstallerDb.java:607)
at org.opennms.install.Installer.install(Installer.java:208)
at org.opennms.install.Installer.main(Installer.java:729)
Caused by: java.sql.SQLException: Statement.execute() threw an SQLException while inserting a row: "INSERT INTO ipinterface (ifindex, ipaddr, iphostname, iplastcapsdpoll, ipstatus, ismanaged, issnmpprimary, nodeid) values (-100, xxx.xxx.252.9, xxx.xxx.xxx, 2006-06-14 22:52:25.583000 -0400, NULL, M, C, 305)". Original exception: org.postgresql.util.PSQLException: ERROR: IpInterface Trigger Notice, Condition 1: No SnmpInterface found for... nodeid: 305 ifindex: -100
at org.opennms.netmgt.dao.db.InstallerDb.transformData(InstallerDb.java:1255)
at org.opennms.netmgt.dao.db.InstallerDb.changeTable(InstallerDb.java:1051)
at org.opennms.netmgt.dao.db.InstallerDb.createTables(InstallerDb.java:605)
... 2 more