Concurrent users: 1 GET GET 200 - item-storage by itemId from POST above PostgreSQL log: ----------------------------------------------------------------------------------------------------------------------------------------------------------------- 16 Jul 2018 15:54:41:387 INFO LogUtil reqId=576378/item-storage 172.31.79.214:32990 DELETE /item-storage/items/b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e null HTTP_1_1 204 0 9 tid=supertenant No Content null 16 Jul 2018 15:54:41:387 DEBUG PostgresClient reqId=576378/item-storage timer: get DELETE FROM supertenant_mod_inventory_storage.item WHERE (jsonb->>'id') = 'b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e' (ns) 8353229 16 Jul 2018 15:54:41:407 DEBUG InterfaceToImpl reqId=013863/item-storage returned 1 class/es from cache 16 Jul 2018 15:54:41:408 DEBUG RestValidator reqId=013863/item-storage Valid call: with args public void org.folio.rest.impl.ItemStorageAPI.getItemStorageItemsByItemId(java.lang.String,java.lang.String,java.util.Map,io.vertx.core.Handler,io.vertx.core.Context) throws java.lang.Exception[b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e, en, {x-okapi-user-id=c0f37345-4f9a-46e0-af59-efbc146be879, x-okapi-request-id=013863/item-storage, x-okapi-permissions=["inventory-storage.items.item.get"], x-okapi-token=eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbiIsInVzZXJfaWQiOiJjMGYzNzM0NS00ZjlhLTQ2ZTAtYWY1OS1lZmJjMTQ2YmU4NzkiLCJ0ZW5hbnQiOiJzdXBlcnRlbmFudCJ9.wz51fzXnKlCWl6cMc8-UfyRkST-oeGtcAM6uVjCkmn1paABu976aL03_mleo6257CD8m9Ptdn1ITlnof4jzhCg, x-okapi-url=http://172.31.79.214:9130, x-okapi-tenant=supertenant}, org.folio.rest.RestVerticle$$Lambda$95/1854859716@2fa658f8, io.vertx.core.impl.EventLoopContext@3a57786d] 16 Jul 2018 15:54:41:408 INFO ItemStorageAPI reqId=013863/item-storage SQL generated from CQL: WHERE lower(f_unaccent(items_mt_view.jsonb->>'id')) LIKE lower(f_unaccent('b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e')) LIMIT 1 OFFSET 0 16 Jul 2018 15:54:41:408 DEBUG PostgresClient reqId=013863/item-storage parseQuery SELECT * FROM supertenant_mod_inventory_storage.items_mt_view WHERE lower(f_unaccent(items_mt_view.jsonb->>'id')) LIKE lower(f_unaccent('b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e')) LIMIT 1 OFFSET 0 16 Jul 2018 15:54:41:409 DEBUG PostgresClient reqId=013863/item-storage Parse query for count_estimate function (ns) 643341 16 Jul 2018 15:54:41:409 DEBUG PostgresClient reqId=013863/item-storage query = SELECT supertenant_mod_inventory_storage.count_estimate_smart('SELECT * FROM supertenant_mod_inventory_storage.items_mt_view WHERE lower(f_unaccent(items_mt_view.jsonb->>''id'')) LIKE lower(f_unaccent(''b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e'')) ') AS count, * FROM supertenant_mod_inventory_storage.items_mt_view WHERE lower(f_unaccent(items_mt_view.jsonb->>'id')) LIKE lower(f_unaccent('b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e')) LIMIT 1 OFFSET 0 16 Jul 2018 15:54:41:409 DEBUG QueryMessageEncoder reqId=123962/item-storage Executing direct query (SELECT supertenant_mod_inventory_storage.count_estimate_smart('SELECT * FROM supertenant_mod_inventory_storage.items_mt_view WHERE lower(f_unaccent(items_mt_view.jsonb->>''id'')) LIKE lower(f_unaccent(''b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e'')) ') AS count, * FROM supertenant_mod_inventory_storage.items_mt_view WHERE lower(f_unaccent(items_mt_view.jsonb->>'id')) LIKE lower(f_unaccent('b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e')) LIMIT 1 OFFSET 0) 16 Jul 2018 15:54:48:997 DEBUG PostgresClient reqId=013863/item-storage non audit table, no jsonb found in json 16 Jul 2018 15:54:48:997 DEBUG PostgresClient reqId=013863/item-storage timer: process results (ns) 367834 16 Jul 2018 15:54:48:997 INFO LogUtil reqId=013863/item-storage org.folio.rest.RestVerticle start invoking getItemStorageItemsByItemId 16 Jul 2018 15:54:48:998 INFO LogUtil reqId=013863/item-storage 172.31.79.214:32990 GET /item-storage/items/b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e null HTTP_1_1 404 9 7591 tid=supertenant Not Found "Not Found" 16 Jul 2018 15:54:48:998 DEBUG PostgresClient reqId=013863/item-storage timer: get SELECT supertenant_mod_inventory_storage.count_estimate_smart('SELECT * FROM supertenant_mod_inventory_storage.items_mt_view WHERE lower(f_unaccent(items_mt_view.jsonb->>''id'')) LIKE lower(f_unaccent(''b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e'')) ') AS count, * FROM supertenant_mod_inventory_storage.items_mt_view WHERE lower(f_unaccent(items_mt_view.jsonb->>'id')) LIKE lower(f_unaccent('b2a8aaa5-47e1-4d88-8ef1-a35c0cb6025e')) LIMIT 1 OFFSET 0 (ns) 7590061845