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

Update minimum required version of PostgreSQL for H25

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Resolved (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 25.0.0
    • Fix Version/s: 25.0.0
    • Component/s: Database
    • Security Level: Default (Default Security Scheme)
    • Labels:
      None
    • Sprint:
      Horizon 2019 - August 28th, Horizon 2019 - September 4th

      Description

      In 25.0.0 we now depend on the jsonb datatype to be available in PostgreSQL.

      If users are using an older version of PostgreSQL (say postgresql-server-9.2.24-1.el7_5.x86_64 which is available in the CentOS 7 repositories) then install -dis will fail with:

      Caused by: org.postgresql.util.PSQLException: ERROR: type "jsonb" does not exist
        Position: 175
              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
              at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
              at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
              at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
              at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
              at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
              at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
              at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
              ... 20 more
      

      We should present the user with an error describing the minimum supported version instead.

        Attachments

          Activity

            People

            • Assignee:
              ranger Benjamin Reed
              Reporter:
              j-white Jesse White
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: