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

Fix PostgreSQL quartz cluster init

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.8
    • Fix Version/s: 6.0
    • Component/s: Clustering

      Description

      Since the Quartz upgrade in NXP-12667 the quartz cluster init scripts is failing on PostgreSQL due to schema changes.

      Using a BOOL instead of VARCHAR(1) fixes this.

      See http://answers.nuxeo.com/questions/10188/nuxeo-595-cluster-couldnt-store-job-error-value-too-long-for-type-character-varying1

        Attachments

          Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-13525 missing oracle delegate in quartz assembly

          • Major - Major loss of function.
          • Resolved
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. NXP-15462 templates/postgresql-quartz-cluster/bin/create-quartz-tables.sql should have varchar(5) instead of varchar(1)

          • Blocker - Blocks development and/or testing work, production could not run.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: