Hi

I'm updating drupal to 8.8.9 and webform to 8.5.13

while running the drush command updatedb i'm facing an issue on execution of the webform update 8191

the error says 

>  [notice] Update started: webform_update_8191
>  [error]  SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: ALTER TABLE {webform_submission} ADD INDEX `webform_submission__token` (`token`(191)); Array
> (
> )
>
>  [error]  Update failed: webform_update_8191
 [error]  Update aborted by: webform_update_8191
 [error]  Finished performing updates.
 [warning] Error while sending QUERY packet. PID=12572 Statement.php:59

Do you think this is related to webform or a database error ?

Thank you

Comments

Deithso created an issue. See original summary.

jrockowitz’s picture

jrockowitz commented
Status: Active » Postponed (maintainer needs more info)

I think the issue could be best fixed by tweaking MySQL.
@see https://severalnines.com/database-blog/how-fix-lock-wait-timeout-exceede...
@see https://support.acquia.com/hc/en-us/articles/360005253954-Fixing-databas...

How many submissions do you have in the webform submission table?

Deithso’s picture

Deithso
Primary language French
Location Marrakesh, Morocco
commented

Hello @jrockowitz

i think it's related to my database the update was stuck at adding index to token

i comment the addIndex to add it later manually, however even manually i've got the same error message

How many submissions do you have in the webform submission table?

I had 2 webforms with 500 submissions in each, at some point users can't submit anymore i already posted an issue

https://www.drupal.org/project/webform/issues/3133913

finally i think it's my database

thank you for the links i'll check

jrockowitz’s picture

jrockowitz commented
Status: Postponed (maintainer needs more info) » Closed (outdated)