Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-10402

int overflow in InstallerDb causes bamboo failures

    XMLWordPrintable

Details

    • Horizon - October 10th 2018

    Description

      PostgreSQL's OID type is a 32-bit unsigned integer, but by default Java's int type is 31-bit signed.  For long-running databases, these OID columns overflow and cause failures in InstallerDb.

       

      org.postgresql.util.PSQLException: Bad value for type int : 2148271220
	at org.postgresql.jdbc.PgResultSet.toInt(PgResultSet.java:2829)
	at org.postgresql.jdbc.PgResultSet.getInt(PgResultSet.java:2050)
	at org.opennms.core.db.install.InstallerDb.getConstraintsFromDB(InstallerDb.java:1172)
	at org.opennms.core.db.install.InstallerDb.getTableFromDB(InstallerDb.java:1029)
	at org.opennms.core.db.install.InstallerDb.createTables(InstallerDb.java:831)
	at org.opennms.core.test.db.InstallerDbIT.testCreateTablesTwice(InstallerDbIT.java:147)

      Attachments

        Activity

          People

            ranger Benjamin Reed
            ranger Benjamin Reed
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: