Database lock wait timeout exceeded while creating a configurable product using REST API

While sending requests to the admin REST API to create products for example, the request takes a lot of time and then an error is returned with the message: “Database lock wait timeout exceeded”. I’m aware that this error is caused by the indexer running at the same time of the database save operation. I know I can somehow work around it by optimizing the indexer, re-indexing on schedule instead of on save and allocating more RAM to elasticsearch. However, my concern is that those requests are sent by another system used by consumers of our product and are not controlled by us, so just increasing the allocated RAM and optimizing the indexer might not be a solution rather a way to avoid the problem. How can I guarantee that the requests sent to the admin API would succeed in saving the data sent?

submitted by /u/majd-vatrin
[link] [comments]