Spawned processes don't seem to clean themselves up

I don't know if it's related, but the process fails randomly, ranging from 99% success (498/500) down to 58% (58/100).

There are one of these in the log, for each missed indexing:

search_api_db Warning

SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction: INSERT INTO "search_api_db_default_index_node_grants" ("item_id", "value") VALUES
(:db_insert_placeholder_0, :db_insert_placeholder_1); Array
(
  [:db_insert_placeholder_0] => entity:node/96:en
  [:db_insert_placeholder_1] => node_access_all:0
)

I found a issue 🐛 Use READ COMMITTED by default for MySQL transactions Fixed , which seems to solve it ...

So I assume there is a workaround?

I close this ticket then

Automatically closed - issue fixed for 2 weeks with no activity.