Database Error:
PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /www/wwwroot/fs2.bdebooks.com/app/core/Database.class.php:151
Stack trace:
#0 /www/wwwroot/fs2.bdebooks.com/app/core/Database.class.php(151): PDOStatement->execute()
#1 /www/wwwroot/fs2.bdebooks.com/app/helpers/DownloadTrackerHelper.class.php(75): App\Core\Database->query()
#2 /www/wwwroot/fs2.bdebooks.com/app/models/File.class.php(156): App\Helpers\DownloadTrackerHelper::clearTimedOutDownloads()
#3 /www/wwwroot/fs2.bdebooks.com/app/controllers/FileController.class.php(137): App\Models\File->download()
#4 [internal function]: App\Controllers\FileController->downloadHandler()
#5 /www/wwwroot/fs2.bdebooks.com/app/helpers/RouteHelper.class.php(388): call_user_func_array()
#6 /www/wwwroot/fs2.bdebooks.com/app/core/Framework.class.php(247): App\Helpers\RouteHelper::processRoutes()
#7 /www/wwwroot/fs2.bdebooks.com/app/core/Framework.class.php(24): App\Core\Framework::dispatch()
#8 /www/wwwroot/fs2.bdebooks.com/index.php(20): App\Core\Framework::run()
#9 {main}
Last Rendered Query:
UPDATE download_tracker SET date_finished=NOW(), status='cancelled' WHERE status='downloading' AND date_updated < DATE_SUB(NOW(), INTERVAL 15 second)
#0 App\Core\Database->notify(PDOException Object ([ * message] => SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction,[ Exception string] => PDOException: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction in /www/wwwroot/fs2.bdebooks.com/app/core/Database.class.php:151 Stack trace: #0 /www/wwwroot/fs2.bdebooks.com/app/core/Database.class.php(151): PDOStatement->execute() #1 /www/wwwroot/fs2.bdebooks.com/app/helpers/DownloadTrackerHelper.class.php(75): App\Core\Database->query() #2 /www/wwwroot/fs2.bdebooks.com/app/models/File.class.php(156): App\Helpers\DownloadTrackerHelper::clearTimedOutDownloads() #3 /www/wwwroot/fs2.bdebooks.com/app/controllers/FileController.class.php(137): App\Models\File->download() #4 [internal function]: App\Controllers\FileController->downloadHandler() #5 /www/wwwroot/fs2.bdebooks.com/app/helpers/RouteHelper.class.php(388): call_user_func_array() #6 /www/wwwroot/fs2.bdebooks.com/app/core/Framework.class.php(247): App\Helpers\RouteHelper::processRoutes() #7 /www/wwwroot/fs2.bdebooks.com/app/core/Framework.class.php(24): App\Core\Framework::dispatch() #8 /www/wwwroot/fs2.bdebooks.com/index.php(20): App\Core\Framework::run() #9 {main},[ * code] => 40001,[ * file] => /www/wwwroot/fs2.bdebooks.com/app/core/Database.class.php,[ * line] => 151,[ Exception trace] => Array ([0] => Array ([file] => /www/wwwroot/fs2.bdebooks.com/app/core/Database.class.php,[line] => 151,[function] => execute,[class] => PDOStatement,[type] => ->),[1] => Array ([file] => /www/wwwroot/fs2.bdebooks.com/app/helpers/DownloadTrackerHelper.class.php,[line] => 75,[function] => query,[class] => App\Core\Database,[type] => ->),[2] => Array ([file] => /www/wwwroot/fs2.bdebooks.com/app/models/File.class.php,[line] => 156,[function] => clearTimedOutDownloads,[class] => App\Helpers\DownloadTrackerHelper,[type] => ::),[3] => Array ([file] => /www/wwwroot/fs2.bdebooks.com/app/controllers/FileController.class.php,[line] => 137,[function] => download,[class] => App\Models\File,[type] => ->),[4] => Array ([function] => downloadHandler,[class] => App\Controllers\FileController,[type] => ->),[5] => Array ([file] => /www/wwwroot/fs2.bdebooks.com/app/helpers/RouteHelper.class.php,[line] => 388,[function] => call_user_func_array),[6] => Array ([file] => /www/wwwroot/fs2.bdebooks.com/app/core/Framework.class.php,[line] => 247,[function] => processRoutes,[class] => App\Helpers\RouteHelper,[type] => ::),[7] => Array ([file] => /www/wwwroot/fs2.bdebooks.com/app/core/Framework.class.php,[line] => 24,[function] => dispatch,[class] => App\Core\Framework,[type] => ::),[8] => Array ([file] => /www/wwwroot/fs2.bdebooks.com/index.php,[line] => 20,[function] => run,[class] => App\Core\Framework,[type] => ::)),[ Exception previous] => ,[errorInfo] => Array ([0] => 40001,[1] => 1213,[2] => Deadlock found when trying to get lock; try restarting transaction))) called at [/www/wwwroot/fs2.bdebooks.com/app/core/Database.class.php:155] #1 App\Core\Database->query(UPDATE download_tracker SET date_finished=NOW(), status='cancelled' WHERE status='downloading' AND date_updated < DATE_SUB(NOW(), INTERVAL 15 second)) called at [/www/wwwroot/fs2.bdebooks.com/app/helpers/DownloadTrackerHelper.class.php:75] #2 App\Helpers\DownloadTrackerHelper::clearTimedOutDownloads() called at [/www/wwwroot/fs2.bdebooks.com/app/models/File.class.php:156] #3 App\Models\File->download(1, 1, 086cdbe3590b1e6aa270256d33fab2c85230da25b32f03ec4a8182677eaba42d) called at [/www/wwwroot/fs2.bdebooks.com/app/controllers/FileController.class.php:137] #4 App\Controllers\FileController->downloadHandler(29bde2a646ec06d5/Class_9_Chemistry_Book.pdf) #5 call_user_func_array(Array ([0] => Themes\Spirit\Controllers\FileController Object (),[1] => downloadHandler), Array ([path] => 29bde2a646ec06d5/Class_9_Chemistry_Book.pdf)) called at [/www/wwwroot/fs2.bdebooks.com/app/helpers/RouteHelper.class.php:388] #6 App\Helpers\RouteHelper::processRoutes() called at [/www/wwwroot/fs2.bdebooks.com/app/core/Framework.class.php:247] #7 App\Core\Framework::dispatch() called at [/www/wwwroot/fs2.bdebooks.com/app/core/Framework.class.php:24] #8 App\Core\Framework::run() called at [/www/wwwroot/fs2.bdebooks.com/index.php:20]