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 |
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:
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: 676The 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