Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. 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

    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 2984 exceeds maximum 2712 for index "instance_contributors_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_contributors_idx), (File, nbtinsert.c), (Line, 584), (Routine, _bt_findinsertloc)])

      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
            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
                ttolstoy Theodor Tolstoy (One-Group.se)
                Charlotte Whitt Charlotte Whitt
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases