XF\Db\Exception: Database Error: INSERT INTO `xf_vw_permission` : Deadlock
After Upgrade to 4.1.7 some Database Errors occur
XF\Db\Exception: Database Error: INSERT INTO `xf_vw_permission` (`applykey`, `nodeid`, `nodetypeid`, `applyid`, `applytypeid`, `bitvalue`) VALUES ('152:0',0,0,152,0,'a:14:{s:2:"BP";a:7:{i:23;i:1;i:24;i:1 ;i:25;i:1;i:26;i:1;i:27;i:1;i:28;i:1;i:29;i:1;}s:2:"EP";a :8:{i:9;a:2:{s:3:"bit";i:1;s:4:"size";i:4194304;}i:8;a:2: {s:3:"bit";i:1;s:4:"size";i:4194304;}i:7;a:2:{s:3:"bit";i :1;s:4:"size";i:4194304;}i:6;a:2:{s:3:"bit";i:1;s:4:"size ";i:4194304;}i:4;a:2:{s:3:"bit";i:1;s:4:"size";i:4194304; }i:5;a:2:{s:3:"bit";i:1;s:4:"size";i:4194304;}i:3;a:2:{s: 3:"bit";i:1;s:4:"size";i:4194304;}i:2;a:2:{s:3:"bit";i:1; s:4:"size";i:4194304;}}s:2:"IP";i:451589;s:2:"AP";i:77723 1;s:2:"PP";i:3126671;s:2:"FP";i:3127807;s:2:"NP";a:2:{i:1 4;i:523315;i:15;i:1535378;}s:2:"CP";i:463;s:2:"DP";i:25;s :2:"SP";i:167;s:2:"WP";i:78179;s:2:"MP";i:1;s:2:"RP";i:1; s:6:"groups";a:2:{i:0;i:2;i:1;i:18;}}'), ('152:0',2,3,152,0,'a:14:{s:2:"BP";a:7:{i:23;i:1;i:24;i:1 ;i:25;i:1;i:26;i:1;i:27;i:1;i:28;i:1;i:29;i:1;}s:2:"EP";a :8:{i:9;a:2:{s:3:"bit";i:1;s:4:"size";i:4194304;}i:8;a:2: {s:3:"bit";i:1;s:4:"size";i:4194304;}i:7;a:2:{s:3:"bit";i :1;s:4:"size";i:4194304;}i:6;a:2:{s:3:"bit";i:1;s:4:"size ";i:4194304;}i:4;a:2:{s:3:"bit";i:1;s:4:"size";i:4194304; }i:5;a:2:{s:3:"bit";i:1;s:4:"size";i:4194304;}i:3;a:2:{s: 3:"bit";i:1;s:4:"size";i:4194304;}i:2;a:2:{s:3:"bit";i:1; s:4:"size";i:4194304;}}s:2:"IP";i:451589;s:2:"AP";i:77723 1;s:2:"PP";i:3126671;s:2:"FP";i:3127807;s:2:"NP";a:2:{i:1 4;i:523315;i:15;i:1535378;}s:2:"CP";i:463;s:2:"DP";i:25;s :2:"SP";i:167;s:2:"WP";i:78179;s:2:"MP";i:1;s:2:"RP";i:1; s:6:"groups";a:2:{i:0;i:2;i:1;i:18;}}') ON DUPLICATE KEY UPDATE `applyid` = VALUES(`applyid`), `applytypeid` = VALUES(`applytypeid`), `bitvalue` = VALUES(`bitvalue`) MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction src/addons/vw/vw/_core/controller/db/xf2.php:396
Generiert von: Mika 11. Februar 2024 um 12:58
Stack-Trace
#0 src/addons/vw/vw/_core/model/db/mysql/vw.php(1316): vw_DB_Controller_XF2->halt('Database Error:...')
#1 src/addons/vw/vw/_core/model/shutdown/vw.php(135): vw_DB_MySQL_Model->replace(Array)
#2 src/addons/vw/vw/_core/model/shutdown/xf2.php(70): vw_Shutdown_Model->shutdown()
#3 src/addons/vw/vw/Listener.php(308): vw_Shutdown_Model_XF2->shutdown()
#4 src/XF/Extension.php(81): vw\vw\Listener::app_complete(Object(XF\Pub\App), Object(XF\Http\Response))
#5 src/XF/App.php(2994): XF\Extension->fire('app_complete', Array, NULL)
#6 src/XF/App.php(2253): XF\App->fire('app_complete', Array)
#7 src/XF/Pub/App.php(456): XF\App->complete(Object(XF\Http\Response))
#8 src/XF/App.php(2490): XF\Pub\App->complete(Object(XF\Http\Response))
#9 src/XF.php(524): XF\App->run()
#10 index.php(20): XF::runApp('XF\\Pub\\App')
#11 {main}
Status der Anfrage
array(4) {
["url"] => string(63) "/forum/threads/18-erlebnis-modellbahn-dresden-2024.66440/page-8"
["referrer"] => string(86) "https://xxxx/forum/threads/18-erlebnis-modellbahn-dresden-2024.66440/page-7"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}