Details
-
Bug
-
Status: Closed (View Workflow)
-
P1
-
Resolution: Done
-
19.2.4
-
CP: sprint 92, CP: sprint 94, CP: sprint 95
-
0
-
Core: Platform
-
Q2 2020 Hot Fix #2
Description
While running the check-in-check-out performance test against the Goldenrod FOLIO, or a subset of it, check-in (POST /circulation/check-in-by-barcode) and retrieving loans (GET /circulation/loans), the following errors were logged:
ERROR: prepared statement "0001B01" already exists.
Steps to reproduce
We haven't been able replicate the sequence of steps that would trigger this error, but we are able to see this error frequently when running the aforementioned tests. When this happened, subsequent actions to check in, get loans, or view items are blown up. mod-inventory-storage had to be restarted for FOLIO to work again.
Expected Results
No errors
Actual Results
Errors such as: ERROR: prepared statement "0001B01" already exists.
When nagivate to Inventory page, clicking on an item in the results list will result in a pop-up with the same error message
Additional Information
It looks like this issue is triggered under load generated by a load test.
2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: duration: 38.110 ms 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: BEGIN 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:ERROR: prepared statement "0001B01" already exists 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:STATEMENT: SELECT jsonb,id FROM fs09000000_mod_inventory_storage.item WHERE lower(f_unaccent(item.jsonb->>'barcode')) LIKE lower(f_unaccent('56711401')) LIMIT 1 OFFSET 0 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: ROLLBACK 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: SELECT count_estimate('SELECT jsonb,id FROM fs09000000_mod_inventory_storage.item WHERE lower(f_unaccent(item.jsonb->>''barcode'')) LIKE lower(f_unaccent(''68325097''))') 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: duration: 42.969 ms 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: BEGIN 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:ERROR: prepared statement "0001B02" already exists 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:STATEMENT: SELECT jsonb,id FROM fs09000000_mod_inventory_storage.item WHERE lower(f_unaccent(item.jsonb->>'barcode')) LIKE lower(f_unaccent('68325097')) LIMIT 1 OFFSET 0 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: ROLLBACK 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: SELECT count_estimate('SELECT jsonb,id FROM fs09000000_mod_inventory_storage.item WHERE lower(f_unaccent(item.jsonb->>''barcode'')) LIKE lower(f_unaccent(''093046192''))') 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: duration: 57.072 ms 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: BEGIN 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:ERROR: prepared statement "0001B03" already exists 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:STATEMENT: SELECT jsonb,id FROM fs09000000_mod_inventory_storage.item WHERE lower(f_unaccent(item.jsonb->>'barcode')) LIKE lower(f_unaccent('093046192')) LIMIT 1 OFFSET 0 2020-07-16 21:45:55 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: ROLLBACK 2020-07-16 21:45:56 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: SELECT count_estimate('SELECT jsonb,id FROM fs09000000_mod_inventory_storage.item WHERE lower(f_unaccent(item.jsonb->>''barcode'')) LIKE lower(f_unaccent(''099799387''))') 2020-07-16 21:45:56 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: duration: 66.179 ms 2020-07-16 21:45:56 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: BEGIN 2020-07-16 21:45:56 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:ERROR: prepared statement "0001B04" already exists 2020-07-16 21:45:56 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:STATEMENT: SELECT jsonb,id FROM fs09000000_mod_inventory_storage.item WHERE lower(f_unaccent(item.jsonb->>'barcode')) LIKE lower(f_unaccent('099799387')) LIMIT 1 OFFSET 0 2020-07-16 21:45:56 UTC:10.23.10.240(33686):fs09000000_mod_inventory_storage@folio:[20641]:LOG: statement: ROLLBACK
TestRail: Results
Attachments
Issue Links
- blocks
-
MODINVSTOR-559 Release mod-inventory-storage 19.3.2
-
- Closed
-
- is blocked by
-
MODINVSTOR-556 RowStreamToBufferAdapter should close RowStream<Row> delegate
-
- Closed
-
-
MODINVSTOR-557 Upgrade to RMB 30.2.5
-
- Closed
-
-
RMB-693 Close prepared statements in PostgresClient stream get
-
- Closed
-
- relates to
-
MODINVSTOR-602 Upgrade to RMB 31.2.0-SNAPSHOT and Vert.x 3.8.4
-
- Closed
-
-
FOLIO-2840 Unsigned long HexSequence for name of PgPreparedStatement
-
- Closed
-