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 7 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 7 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 7 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 6 days ago
1 pass
Comment 6 days 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 6 days ago11:06am 23 June 2024
Comment 6 days ago →
🇩🇪Germany hchonov 🇪🇺🇩🇪🇧🇬
Thank you. This will be part of the 1.6 release.

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