10:15 weird> Hello, im trying to upgrade database to 1.9.90 with $OPENNMS_HOME/bin/install -dis. But im getting the following error: 10:15 weird> SEVERE 8/12/11 4:06 PM:liquibase: Error executing SQL ALTER TABLE vlan ADD id INT NOT NULL UNIQUE 10:17 weird> org.postgresql.util.PSQLException: ERROR: column "id" contains null values 10:17 weird> anyone know what to do?
Acceptance / Success Criteria
None
Lucidchart Diagrams
Activity
Show:
Benjamin Reed August 12, 2011 at 1:52 PM
It appears to be a problem with the liquibase changelog to add "id" columns to the linkd tables. It would fail on upgrade if data already exists in the table, since it is "unique not null" and adding a column with no default would try to insert a null.
A user in IRC reported an issue this morning:
10:15 weird> Hello, im trying to upgrade database to 1.9.90 with $OPENNMS_HOME/bin/install -dis. But im getting the following error:
10:15 weird> SEVERE 8/12/11 4:06 PM:liquibase: Error executing SQL ALTER TABLE vlan ADD id INT NOT NULL UNIQUE
10:17 weird> org.postgresql.util.PSQLException: ERROR: column "id" contains null values
10:17 weird> anyone know what to do?