Menu
Feedback
Start here
Tutorials
Developer portal

Known Issues
Support Rules
Troubleshooting

Frequently Asked Questions
Announcements
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

  1. 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;
  2. Check that errors might happen, such is deadlocked.

Workaround

Try to make less requests per minute.

Contributors
2
Photo of the contributor
Photo of the contributor
+ 2 contributors
Contributors
2
Photo of the contributor
Photo of the contributor
+ 2 contributors
On this page
Still got questions?
Ask the community
Find solutions and share ideas in the VTEX community.
Join our community
Request support from VTEX
For personalized assistance, contact our experts.
Open a support ticket
GithubDeveloper portalCommunityFeedback