josephine:/opt/OpenNMS # /opt/OpenNMS/bin/install -disU
==============================================================================
OpenNMS Installer Version $Id: Installer.java 4194 2006-09-01 02:09:40Z brozow $
==============================================================================

Configures PostgreSQL tables, users, and other miscellaneous settings.

- checking database version... 8.1
  - Full version string: PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.0 (SUSE Linux)
* using 'opennms' as the PostgreSQL user for OpenNMS
* using 'opennms' as the PostgreSQL password for OpenNMS
* using 'opennms' as the PostgreSQL database name for OpenNMS
- using SQL directory... /opt/OpenNMS/etc
- using create.sql... /opt/OpenNMS/etc/create.sql
- using iplike module... /opt/OpenNMS/lib/iplike.so
- checking database for old backup tables... NONE
- checking for rows that violate constraints... NONE
- creating sequences... 
  - checking "opennmsNxtId" sequence... ALREADY EXISTS
  - checking "nodeNxtId" sequence... ALREADY EXISTS
  - checking "serviceNxtId" sequence... ALREADY EXISTS
  - checking "eventsNxtId" sequence... ALREADY EXISTS
  - checking "alarmsNxtId" sequence... ALREADY EXISTS
  - checking "outageNxtId" sequence... ALREADY EXISTS
  - checking "notifyNxtId" sequence... ALREADY EXISTS
  - checking "vulnNxtId" sequence... ALREADY EXISTS
  - checking "catNxtId" sequence... ALREADY EXISTS
  - checking "userNotifNxtId" sequence... ALREADY EXISTS
  - checking "demandPollNxtId" sequence... ALREADY EXISTS
  - checking "pollResultNxtId" sequence... ALREADY EXISTS
  - checking "mapNxtId" sequence... ALREADY EXISTS
  - checking "reportNxtId" sequence... ALREADY EXISTS
- creating sequences... DONE
- creating tables...
  - checking table "serverMap"... UPTODATE
  - checking table "serviceMap"... UPTODATE
  - checking table "distPoller"... UPTODATE
  - checking table "node"... UPTODATE
  - checking table "snmpInterface"... SCHEMA DOES NOT MATCH
    - differences:
new constraint: snmpinterface: constraint snmpinterface_pkey primary key (id)
new constraint: snmpinterface: constraint fk_nodeid2 foreign key (nodeid) references node (nodeid) on delete cascade
old constraint: snmpinterface: constraint fk_nodeid2 foreign key (nodeid) references node (nodeid) on delete cascade
      - column "id" is different
      - column "nodeid" is different
      - column "snmpifindex" is different
    - creating temporary table... done
    - creating new 'snmpinterface' table... done
    - transforming data into the new table... DONE           
    - optimizing table snmpinterface... DONE
    - completed updating table... 
  - checking table "ipInterface"... SCHEMA DOES NOT MATCH
    - differences:
new constraint: ipinterface: constraint ipinterface_pkey primary key (id)
new constraint: ipinterface: constraint snmpinterface_fkey1 foreign key (snmpinterfaceid) references snmpinterface (id) on delete cascade
new constraint: ipinterface: constraint fk_nodeid1 foreign key (nodeid) references node (nodeid) on delete cascade
old constraint: ipinterface: constraint fk_nodeid1 foreign key (nodeid) references node (nodeid) on delete cascade
      - column "id" is different
      - column "nodeid" is different
      - column "snmpinterfaceid" is different
    - creating temporary table... done
    - creating new 'ipinterface' table... done
    - transforming data into the new table... DONE           
    - optimizing table ipinterface... DONE
    - completed updating table... 
  - checking table "service"... UPTODATE
  - checking table "ifServices"... SCHEMA DOES NOT MATCH
    - differences:
new constraint: ifservices: constraint ifservices_pkey primary key (id)
new constraint: ifservices: constraint ipinterface_fkey foreign key (ipinterfaceid) references ipinterface (id) on delete cascade
new constraint: ifservices: constraint fk_nodeid3 foreign key (nodeid) references node (nodeid) on delete cascade
new constraint: ifservices: constraint fk_serviceid1 foreign key (serviceid) references service (serviceid) on delete cascade
old constraint: ifservices: constraint fk_nodeid3 foreign key (nodeid) references node (nodeid) on delete cascade
old constraint: ifservices: constraint fk_serviceid1 foreign key (serviceid) references service (serviceid) on delete cascade
      - column "id" is different
      - column "nodeid" is different
      - column "serviceid" is different
      - column "ipinterfaceid" is different
    - creating temporary table... done
    - creating new 'ifservices' 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 'ifservices'.  Nested exception: No entry in the map for 3, 10.11.0.18, (null)
        at org.opennms.install.Installer.createTables(Installer.java:1116)
        at org.opennms.install.Installer.install(Installer.java:322)
        at org.opennms.install.Installer.main(Installer.java:2558)
Caused by: java.lang.IllegalArgumentException: No entry in the map for 3, 10.11.0.18, (null)
        at org.opennms.install.Installer$AutoIntegerIdMapStore.getIntegerForColumns(Installer.java:2694)
        at org.opennms.install.Installer$MapStoreIdGetter.getColumnReplacement(Installer.java:2786)
        at org.opennms.install.Installer.transformData(Installer.java:2415)
        at org.opennms.install.Installer.changeTable(Installer.java:2257)
        at org.opennms.install.Installer.createTables(Installer.java:1114)
        ... 2 more