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

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

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

7
  • 07 Jan 2020, 04:54 PM
  • 05 Jan 2020, 05:47 PM
  • 05 Jan 2020, 05:47 PM
  • 02 Jan 2020, 10:59 AM
  • 07 Nov 2019, 04:31 PM
  • 06 Nov 2019, 12:52 PM
  • 06 Nov 2019, 07:50 AM

Checklist

hide

TestRail: Results

Activity

Show:

Charlotte Whitt January 7, 2020 at 4:54 PM

Added instance with the looong_title (see json attached). Todays test in Q4 2019 bugfest passed successfully, and all is fine. I have removed retest label.

Cate Boerema January 6, 2020 at 4:29 PM

Charlotte Whitt January 6, 2020 at 11:38 AM

Hi @cate:

Cate Boerema January 6, 2020 at 10:10 AM

Thanks . It does look like created a bugfix release for this (18.2.1 https://github.com/folio-org/mod-inventory-storage/releases) and it is not yet on the BugFest environment but I am going to hold off on requesting that it be deployed there because there are other fixes included in that release which aren't yet closed. Namely:

Charlotte Whitt January 5, 2020 at 6:25 PM

- please release it to BugFest.

CC:

Done

Details

Assignee

Reporter

Tester Assignee

Priority

Story Points

Sprint

Development Team

Core: Platform

Fix versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 6, 2019 at 7:49 AM
Updated September 15, 2020 at 9:04 AM
Resolved January 5, 2020 at 5:47 PM
TestRail: Cases
TestRail: Runs

Flag notifications