Known issues
deadlocked error when using Catalog APIs
deadlocked error when using Catalog APIs
ID: 862626
Backlog
Published on 7/14/2023
•
Last update on 7/19/2023
Summary
The constant use of some catalog APIs like "Add SKU to Subcollection" or trying to link products through the suggestions module can cause deadlocked errors for the merchant.
Deadlocked erros can happen when there is a concurrence in saving the data on the database. So when requesting too much the API in a short period of time, this errors are more evident.
Simulation
- Use, for instance, the Add SKU to Subcollection API (https://developers.vtex.com/docs/api-reference/catalog-api#post-/api/catalog/pvt/subcollection/-subCollectionId-/stockkeepingunit) to add lots of skus into a collection in a short period of time;
- Check that errors might happen, such is deadlocked.
Workaround
Try to make less requests per minute.