Serialization failure

[ptrykulich]

What happened?

Description

I programmatically store about 3 thousand entries, each of which contains a Neo matrix and other fields. I divide the queue into queues of 250 records and they are processed 3-5 at a time.

Steps to reproduce

Restore the entries of the same section in different queues, using 3-5 runners at the same time.

Expected behavior

Performing a resave without errors.

Actual behavior

Errors occur during the resave process:

• Something went wrong: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction The SQL being executed was: INSERT INTO searchindex (elementId, attribute, fieldId, siteId, keywords) VALUES (6570286, 'slug', 0, 1, '') | File: vendor/yiisoft/yii2/db/Schema.php | Line: 676
• Tried to roll back a savepoint, but it does not exist: SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT LEVEL1 does not exist The SQL being executed was: ROLLBACK TO SAVEPOINT LEVEL1

Craft CMS version

Craft Pro 4.7.0

PHP version

8.1.28

Operating system and version

Linux 6.5.0-1018-aws

Database type and version

MySQL 8.0.35

Image driver and version

Imagick 3.7.0 (ImageMagick 6.9.11-60)

Installed plugins and versions

Plugin/Component	Version
Amazon S3	2.0.3
Cloudflare	2.0.2
CP Field Inspect	1.4.4
Embedded Assets	3.2.0
FastCGI Cache Bust	4.0.1
Feed Me	5.3.0
Formie	2.1.18
Navigation	2.0.24
Neo	4.0.2
Redactor	3.0.4
Redactor Custom Styles	4.0.3
Redirect Manager	2.0.0
Section + Product Type	2.0.3
Sentry Logger	4.1.4
SEOmatic	4.0.38
Typed link field	2.1.5
User Activity	2.3.16
Yii version	2.0.48.1
Twig version	v3.4.3
Guzzle version	7.8.1