General error: 1205 Lock wait timeout exceeded; try restarting transaction

[error] Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: DELETE FROM {autosave_form_entity_form} WHERE (entity_type_id = :db_condition_placeholder_0) AND (entity_id = :db_condition_placeholder_1); Array ( [:db_condition_placeholder_0] => media [:db_condition_placeholder_1] => 716136 ) in autosave_form_entity_update() (line 112 of /..../modules/contrib/autosave_form/autosave_form.module).

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Merge request !7Issue #3029155: General error: 1205 Lock wait timeout exceeded; try restarting transaction → (Merged) created by mediabounds
Comment 12 months ago →
🇬🇧United Kingdom alexj12
Confirming that we ran into this issue recently and during an incident applied the same indexes which resolved the issue. The fact that the current PRIMARY index is composite means it isn't used in the troublesome query.

Reviewed and tested by the community!
Comment 12 months ago →
🇬🇧United Kingdom alexj12
Link to the documentation outlining that the order of the columns in the index is important and the current PRIMARY index does not optimise the query.
Open in Jenkins → Open on Drupal.org →
Core: 9.5.x + Environment: PHP 8.1 & MariaDB 10.3.22
last update 12 months ago
1 pass
Open in Jenkins → Open on Drupal.org →
Core: 9.5.x + Environment: PHP 8.1 & MariaDB 10.3.22
last update 5 months ago
1 pass
Comment 5 months ago →
System Message

hchonov → committed ba123ddb on 8.x-1.x authored by mediabounds →
Issue #3029155: General error: 1205 Lock wait timeout exceeded; try...
Status changed to Fixed 5 months ago11:06am 23 June 2024
Comment 5 months ago →
🇩🇪Germany hchonov 🇪🇺🇩🇪🇧🇬
Thank you. This will be part of the 1.6 release.
Comment 4 months ago →
System Message
Automatically closed - issue fixed for 2 weeks with no activity.

General error: 1205 Lock wait timeout exceeded; try restarting transaction

Merge Requests

!7General error: 1205 Lock wait timeout exceeded; try restarting transaction
Merged

Comments & Activities

General error: 1205 Lock wait timeout exceeded; try restarting transaction

Merge Requests

!7General error: 1205 Lock wait timeout exceeded; try restarting transactionMerged

Comments & Activities

!7General error: 1205 Lock wait timeout exceeded; try restarting transaction
Merged