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

Adding an Instance with a longer title throws "Values larger than 1/3 of a buffer page cannot be indexed"

    XMLWordPrintable

Details

    • CP: sprint 79
    • 1
    • Core: Platform

    Description

      This behaviour has been observed both in Five Colleges tenant and in Snapshot-stable

      Steps to reproduce:
      1. Post the attached Instance record to /inventory/instances

      What should happen:
      Instance is created successfully

      What actually happens:
      An exception is thrown. Message from API:

      ErrorMessage(fields=[(Severity, ERROR), (V, ERROR), (SQLSTATE, 54000), (Message, index row size 2792 exceeds maximum 2712 for index "instance_title_idx"), (Hint, Values larger than 1/3 of a buffer page cannot be indexed.
      Consider a function index of an MD5 hash of the value, or use full text indexing.), (s, diku_mod_inventory_storage), (t, instance), (n, instance_title_idx), (File, nbtinsert.c), (Line, 584), (Routine, _bt_findinsertloc)])

      TestRail: Results

        Attachments

          1. 1-1.xml
            71 kB
          2. looong_title.json
            12 kB
          3. looong_title2.json
            62 kB
          4. screenshot-1.png
            screenshot-1.png
            270 kB
          5. Skärmavbild 2020-01-05 kl. 18.42.55.png
            Skärmavbild 2020-01-05 kl. 18.42.55.png
            767 kB
          6. Skärmavbild 2020-01-05 kl. 18.43.15.png
            Skärmavbild 2020-01-05 kl. 18.43.15.png
            906 kB
          7. Skärmavbild 2020-01-07 kl. 17.52.15.png
            Skärmavbild 2020-01-07 kl. 17.52.15.png
            850 kB

          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
            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

            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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-379 Reindex of contributors fails with maximum 2712 'index row size exceeded' error

            • 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. MODINVSTOR-395 Adding a Instance record with a few more contributors than normal throws "Values larger than 1/3 of a buffer page cannot be indexed" exception

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

            Activity

              People

                julianladisch Julian Ladisch
                ttolstoy Theodor Tolstoy (One-Group.se)
                Charlotte Whitt Charlotte Whitt
                Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases