Details
-
Bug
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
-
Core: Platform
Description
mod-inventory-storage/items Postgresql DEBUG log:
Attached below.
Workflow to reproduce:
I'm running a pretty straightforward workflow:
1. GET all mod-inventory items
GET /inventory/items
2. GET 200 - Get Material-types
GET /material-types?query=(name=book)
3. GET 200 - Get Loan-types
GET /loan-types?query=(name=can circulate)
4. GET 200 - Get Holdings-storage records
GET /holdings-storage/holdings?LIMIT=1
5. POST new inventory/items
POST /inventory/items
6. GET 200 - /inventory/items using barcode
GET /inventory/items?query=(barcode=${barcode}).
7. PUT 204 - Update mod-inventory/item by doing PUT by ${modInventoryItemId}
PUT /inventory/items/${modInventoryItemId}
8. GET 200 - Get updated mod-inventory/item by using ${modInventoryItemId}
GET /inventory/items/${modInventoryItemId}
9. DELETE 204 - mod-inventory item by modInventoryItemId
DELETE /inventory/items/${modInventoryItemId}
10. Verify mod-inventory item is deleted by doing GET - 404
GET /inventory/items/${modInventoryItemId}
Observation:
POST HTTP request takes ~10 seconds and PUT HTTP request takes ~15 seconds to execute. I have attached logs/screenshots from Postgre SQL, JMeter and Postman.
TestRail: Results
Attachments
Issue Links
- is blocked by
-
MODINVSTOR-118 Use identity column for GET, PUT and DELETE implementations
-
- Open
-
- is cloned by
-
MODINV-65 Performance - DELETE for /inventory/instances/${modInventoryInstanceId} endpoint takes ~1.1 to ~2.4 seconds
-
- Closed
-
- relates to
-
RMB-206 add PostgresClient.getById
-
- Closed
-
-
RMB-288 StorageHelper post put deleteById getById
-
- Closed
-
-
CQLPG-58 ID searches way too slow
-
- Closed
-
-
MODINVSTOR-134 item-storage API - GET after doing POST from item-storage(4 concurrent users) by itemId takes ~7 seconds
-
- Closed
-
-
MODINVSTOR-214 mod-inventory-storage-13.1.0-SNAPSHOT.186 hangs in CI environment build
-
- Closed
-
-
MODUSERS-70 Use database identity column for GET, PUT and DELETE of user
-
- Closed
-