Uploaded image for project: 'Nuxeo ECM Build/Test Environment'
  1. Nuxeo ECM Build/Test Environment
  2. NXBT-2747

Install PostgreSQL 11 on Windows slaves

    XMLWordPrintable

    Details

    • Type: Broken build
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Continuous Integration
    • Environment:
      Windows
    • Tags:
    • Upgrade notes:
      Hide

      The "master" windows slaves are now using pgsql 11.1 instead of formerly 9.3 (port 5433 instead of 5432). You can always override NX_PGSQL_DB_PORT if you need to test the master branch on an older pgsql version.
      Maintenance slaves are still hitting 9.3 at this time.

      Show
      The "master" windows slaves are now using pgsql 11.1 instead of formerly 9.3 (port 5433 instead of 5432). You can always override NX_PGSQL_DB_PORT if you need to test the master branch on an older pgsql version. Maintenance slaves are still hitting 9.3 at this time.
    • Sprint:
      DevTools-06
    • Story Points:
      2

      Description

      In Drive tests, we are having those errors that are blockers for us:

      org.postgresql.util.PSQLException: ERROR: syntax error at or near "ON"

      Quoting Florent Guillaume:

      It's a syntax error on a statement like INSERT INTO sometable (...) VALUES (...) ON CONFLICT ... where ON CONFLICT is not understood. Which means that the PostgreSQL version is < 9.5, so too old.

      Installing the lastest or 9.6+ version would solve our issues.

        Attachments

          Issue Links

          is related to

          New Feature - A new feature of the product, which has yet to be developed. NXBT-2707 Test against PostgreSQL 11 by default on 10.10+ (drop 9.6)

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours
                  3h