Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-20971

Support PostgreSQL 9.6

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.10
    • Component/s: Distribution / Installers

      Description

      If the JDBC driver currently in the platform (postgresql-9.4.1208.jar for 8.10, postgresql-9.2-1002.jdbc4.jar for 7.10) is used with PostgreSQL 9.6, hibernate initialization fails with:

      org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:321)
        at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:284)
        at org.postgresql.jdbc.PgDatabaseMetaData.getIndexInfo(PgDatabaseMetaData.java:2948)

      The fix is included in JDBC driver 9.4.1209:

      -> Upgrade to latest version (postgresql-9.4.1212.jar at this time).

        Attachments

          Issue Links

          depends on

          Task - A task that needs to be done. NXBT-1822 Upgrade slaves for postgresql 9.6 support

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXP-19428 Support PostgreSQL 9.5

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. NXP-22362 PostgreSQL JDBC driver upgrade required for running PostgreSQL version 9.6

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved
          is required by

          Task - A task that needs to be done. NXBT-1631 Upgrade PostgreSQL version to 9.6 on master slaves

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. NXBT-1604 Check test database versions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXDOC-1177 Update postgres version support for 8.10 and beyond

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: