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

templates/postgresql-quartz-cluster/bin/create-quartz-tables.sql should have varchar(5) instead of varchar(1)

    XMLWordPrintable

    Details

      Description

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

      but in details:

      • when configuring nuxeo in cluster with a postgresql database, I ran the templates/postgresql-quartz-cluster/bin/create-quartz-tables.sql
      • when starting nuxeo I get "failed to schedule job with id 'softDeleteCleanup'"
      • too short fields are in the templates/postgresql-quartz-cluster/bin/create-quartz-tables.sql. In particular all VARCHAR(1) like is_durable, is_volatile, is_stateful, requests_recovery...
      • they should be 5 characters at least, because I see "false" stored inside, or they should be boolean and not varying char.

      Reporter: nicolas
      E-mail: nicolas.zin@gmail.com

        Attachments

        1. server (3).log
          530 kB
          Sebastien Guillaume

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: