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

Fix index name length issue on PostgreSQL

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 9.10-HF02, 10.1-SNAPSHOT
    • Fix Version/s: 9.10-HF04, 10.2
    • Component/s: Core VCS
    • Release Notes Summary:
      Indexes are created on PostgreSQL when a table name is longer then 63 characters.
    • Tags:
    • Backlog priority:
      800
    • Sprint:
      nxFG 10.2.1
    • Story Points:
      2

      Description

      On PostgreSQL, table names are limited to 63 characters. If a complex property happens to have a name with 63 characters, its associated index will then be truncated to the same name and the index creation will fail.

      Example :

      2018-02-27 14:58:15.814 CET [25332] nuxeo@nuxeo LOG:  execute <unnamed>: CREATE TABLE "ksupplierrawmaterialswidget_cv_system_currentlifecyclestate_agg" ("id" varchar(36) NOT NULL, "pos" int4, "item" varchar)
      2018-02-27 14:58:15.822 CET [25332] nuxeo@nuxeo LOG:  execute <unnamed>: CREATE UNIQUE INDEX "ksupplierrawmaterialswidget_cv_system_currentlifecyclestate_agg_unique_pos" ON "ksupplierrawmaterialswidget_cv_system_currentlifecyclestate_agg" ("id", "pos")
      2018-02-27 14:58:15.822 CET [25332] nuxeo@nuxeo ERROR:  relation "ksupplierrawmaterialswidget_cv_system_currentlifecyclestate_agg" already exists
      

        Attachments

          Issue Links

            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 - 20 minutes
                  20m

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.