[4.x]: [web.ERROR] [yii\db\Exception] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

[DTesch-Level-R]

What happened?

Description

When updating an Entry, with lots of Neo fields (with children), via a mutation I get this error:
[web.ERROR] [yii\db\Exception] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

It happens mainly when making the request twice, before the initial request is finished.

Edit: It happens only when the session component is set to redis-Driver.
Edit: It also happens when I call the GraphQL Endpoint from my Nuxt-App.

Steps to reproduce

1. GraphiQL Playground
2. Set session component to redis-Driver.
3. Mutate/Update an entry with lots of Neo fields (with children)
4. Hit the play button 2-3 times fast
5. Error: [web.ERROR] [yii\db\Exception] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
6. The process/lockfile seems to only get released when I restart the server

Expected behavior

Saving the entry after lock file releases.

Actual behavior

[web.ERROR] [yii\db\Exception] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

Craft CMS version

4.5.14

PHP version

8.0.11

Operating system and version

Unix

Database type and version

mysql 8

Image driver and version

No response

Installed plugins and versions

• Neo 4.0.2

[brandonkelly]

Can you post the full stack trace for the error? (It should be in storage/logs/web-XXXX-XX-XX.log.)

[DTesch-Level-R]

Can you post the full stack trace for the error? (It should be in storage/logs/web-XXXX-XX-XX.log.)

Is this enough?
stacktrace.log

[DTesch-Level-R]

That was fast.

Thank you! 😃

[brandonkelly]

Craft 4.5.15 and 4.6.0 are out with a fix for that: now we ensure the entire element save process is protected by a mutex lock, like we do for non-GraphQL save requests already.

Thanks for reporting!