"General error: 1205 Lock wait timeout exceeded" when using convert video on save

Created on 4 July 2017, almost 7 years ago
Updated 16 June 2023, about 1 year ago

When using "Convert video on save"

The following error occurs and no video content can be created.
I'm not sure if this is caused by the latest version of Video module or latest version of Drupal. I know it worked before.

PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: UPDATE {video_queue} SET entity_type=:db_update_placeholder_0, entity_id=:db_update_placeholder_1, status=:db_update_placeholder_2, dimensions=:db_update_placeholder_3, duration=:db_update_placeholder_4, started=:db_update_placeholder_5, completed=:db_update_placeholder_6, statusupdated=:db_update_placeholder_7, data=:db_update_placeholder_8 WHERE (fid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => node [:db_update_placeholder_1] => 36382 [:db_update_placeholder_2] => 5 [:db_update_placeholder_3] => 640x360 [:db_update_placeholder_4] => 0 [:db_update_placeholder_5] => 1499183238 [:db_update_placeholder_6] => 0 [:db_update_placeholder_7] => 1499183238 [:db_update_placeholder_8] => a:3:{s:10:"field_name";s:11:"field_video";s:8:"langcode";s:3:"und";s:5:"delta";i:0;} [:db_condition_placeholder_0] => 63952 ) in drupal_write_record() (Zeile 7383 von /xxx/includes/common.inc).

Using cron to convert the videos works so far (using zencoder for conversion)

πŸ› Bug report
Status

Needs review

Version

2.0

Component

General

Created by

πŸ‡©πŸ‡ͺGermany slowflyer

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

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

  • πŸ‡ΈπŸ‡°Slovakia poker10

    Adding related issue: #1915602: SQL Server has gone away uncaught exception β†’ . The db_close() call was added in that issue. So the options are either to rollback that change, or do a change as proposed by patch #10. I am curious if anyone else can confirm that the problem is only with external transcoders and the db_close() can still be used for FFmpeg? Or does anyone experienced the bug described in the IS on FFmpeg transcoder?

Production build 0.69.0 2024