Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-379

Reindex of contributors fails with maximum 2712 'index row size exceeded' error

    XMLWordPrintable

Details

    • CP: sprint 79
    • 0
    • Core: Platform

    Description

      I recently reindexed our full inventory data set at Chicago, and found that the reindex failed on the instance_contributors_idx with this error: "index row size 3256 exceeds maximum 2712 for index". Turns out that we have around 6000 instances with contributors whose aggregate length exceeds 2712 characters. As a work around, I removed the index and completed the reindex with no other problems. And the application, including searches, seemed to work just fine without it, presumably because each of these jsonb collections also have gin and full text indexes defined for them as well. It seems that trying to create a btree index on contributors, converting the whole array of contributors to text and using the text as the index key, is too brittle to accommodate the wide range of contributors that research libraries typically have. The same may be true for btree indexes on other types of jsonb collection, as well. Also, I don't actually see any need for this type of index.

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Umbrella - FOLIO-2402 platform-related features and fixes for mod-inv-stor 18.2.1

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            duplicates

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODINVSTOR-139 Indices for sorting: Only index first part of JSON array properties

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            is blocked by

            Task - A task that needs to be done. MODINVSTOR-418 Update RAML Module Builder (RMB) to 29.1.5

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-498 Truncate b-tree string for 2712 index row size

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-390 Adding an Instance with a longer title throws "Values larger than 1/3 of a buffer page cannot be indexed"

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                julianladisch Julian Ladisch
                arnt@uchicago.edu Dale Arntson
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases