I get this error while converting videos. Video gets converted (I can see files). But db is not updated:
==================================================================
Original
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: UPDATE {video_queue} SET completed=:db_update_placeholder_0 WHERE (vid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => 1338446790 [:db_condition_placeholder_0] => 7 ) in Transcoder->executeConversion() (line 148 of /home/user/public_html/sites/all/modules/video/includes/Transcoder.inc).
Additional
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:270:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: UPDATE {video_queue} SET completed=:db_update_placeholder_0 WHERE (vid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => 1338446790 [:db_condition_placeholder_0] => 7 ) ";s:9:"%function";s:31:"Transcoder->executeConversion()";s:5:"%file";s:71:"/home/user/public_html/sites/all/modules/video/includes/Transcoder.inc";s:5:"%line";i:148;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://www.mydomain.com/admin/reports/status/run-cron [:db_insert_placeholder_7] => http://www.mydomain.com/admin/reports/status [:db_insert_placeholder_8] => 117.192.248.48 [:db_insert_placeholder_9] => 1338446715 ) in dblog_watchdog() (line 154 of /home/smvod/public_html/modules/dblog/dblog.module).
Uncaught exception thrown in shutdown function.
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 13705307054fc7137c1ba848.98151035 ) in lock_release_all() (line 269 of /home/user/public_html/includes/lock.inc).
Fatal error: Exception thrown without a stack frame in Unknown on line 0
==================================================================
Here is my PHP.ini
max_input_time = 600
memory_limit = 1024M
max_execution_time = 600
mysql.connect_timeout = 600
mysql.allow_persistent = 1
mysql.connect_timeout = 600
mysqli.reconnect = On
extension=pdo.so
extension=pdo_sqlite.so
extension=sqlite.so
extension=pdo_mysql.so
Comments
Comment #1
Jorrit commentedIt seems that the MySQL connection was aborted during transcoding. Are you using FFmpeg? What is the value of the
wait_timeoutMySQL variable?Comment #2
prabhakarsun commentedwait_timeout was set to 30. I increased it to 3600, and it is working now.
Thank you.