Got an error today (everything is verbatim except the bolded part):
Invalid SQL:
/** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_10_lvl1data' AND event = 'nodeChg_10') OR
(cacheid = 'node_11_lvl1data' AND event = 'nodeChg_11') OR
(cacheid = 'node_12_lvl1data' AND event = 'nodeChg_12') OR
(cacheid = 'node_14_lvl1data' AND event = 'nodeChg_14') OR
(cacheid = 'node_18150_lvl1data' AND event = 'nodeChg_18150') OR
(cacheid = 'node_193_lvl1data' AND event = 'nodeChg_193') OR
(cacheid = 'node_1_lvl1data' AND event = 'nodeChg_1') OR
(cacheid = 'node_36665_lvl1data' AND event = 'nodeChg_36665') OR
(cacheid = 'node_42201_lvl1data' AND event = 'nodeChg_42201') OR
(cacheid = 'node_4302_lvl1data' AND event = 'nodeChg_4302') OR
(cacheid = 'node_44840_lvl1data' AND event = 'nodeChg_44840') OR
(cacheid = 'node_45443_lvl1data' AND event = 'nodeChg_45443') OR
(cacheid = 'node_47561_lvl1data' AND event = 'nodeChg_47561') OR
(cacheid = 'node_48969_lvl1data' AND event = 'nodeChg_48969') OR
(cacheid = 'node_5_lvl1data' AND event = 'nodeChg_5') OR
(cacheid = 'node_6_lvl1data' AND event = 'nodeChg_6') OR
(cacheid = 'node_7_lvl1data' AND event = 'nodeChg_7') OR
(cacheid = 'node_8_lvl1data' AND event = 'nodeChg_8') OR
(cacheid = 'vB_ChTreeWithLast' AND event = 'vB_ChannelStructure_chg') OR
(cacheid = 'vB_ChannelTreeRaw_56' AND event = 'perms_changed') OR
(cacheid = 'vB_ChannelTreeRaw_56' AND event = 'userPerms_56') OR
(cacheid = 'vB_ChannelTreeRaw_56' AND event = 'vB_ChannelStructure_chg');
MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Tuesday, April 22nd 2014 @ 08:13:49 PM
Error Date : Tuesday, April 22nd 2014 @ 08:13:50 PM
Script : http:///forum/main-category/talk-networking/ideas
Referrer :
IP Address : userip
Username : username
Classname : vB_Database_MySQLi
MySQL Version :
------------------------------------------------------------------------------------------------------
A few days ago we got a similar error:
[Showing truncated query, original length: 20233]
[First 500 chars]
Invalid SQL:
/** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
('node_1_lvl1data','nodeChg_1'),
('getSearchResults_678c0384ffcf2c0e224be53858005a17','perms_changed'),
('getSearchResults_678c0384ffcf2c0e224be53858005a17','vB_ChannelStructure_chg'),
('getSearchResults_678c0384ffcf2c0e224be53858005a17','vB_SearchResults_chg_0'),
('SrchResults0872991455','nodeChg_47102'),
('SrchResults01561326027','nodeChg_47228'),
('SrchResults02627501302','nodeChg_47265'),
('SrchResults0378131356
[Last 500 chars]
'vbnodetext47761_1_0:787cefe106de1b3cdbce612ac3456f0d','nodeChg_2207'),
('vbnodetext47761_1_0:787cefe106de1b3cdbce612ac3456f0d','vB_Language_languageCache'),
('vbnodetext_pre_47761_1_0:787cefe106de1b3cdbce612ac3456f0d','nodeChg_47761'),
('vbnodetext_pre_47761_1_0:787cefe106de1b3cdbce612ac3456f0d','nodeChg_2207'),
('vbnodetext_pre_47761_1_0:787cefe106de1b3cdbce612ac3456f0d','vB_Language_languageCache'),
('vBPage_70929362c8cc980c5fab4b03da2cfc5f_1',''),
('vbPre_conversation292.279.2207.47101','');
MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Sunday, April 20th 2014 @ 08:48:12 AM
Error Date : Sunday, April 20th 2014 @ 08:48:14 AM
Script : http:///forum/main-category/talk-networking/ideas
Referrer :
IP Address : userip
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
------------------------------------------------------------------------------------------------------
Please advise what can be done about this. We looked up this problem and I believe one of the older threads said to do a repair on the "cacheevent" table. We did that twice (since the first similar error), and once more just now. Anything else to be done to fix or minimize this error?
Thanks.
Invalid SQL:
/** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_10_lvl1data' AND event = 'nodeChg_10') OR
(cacheid = 'node_11_lvl1data' AND event = 'nodeChg_11') OR
(cacheid = 'node_12_lvl1data' AND event = 'nodeChg_12') OR
(cacheid = 'node_14_lvl1data' AND event = 'nodeChg_14') OR
(cacheid = 'node_18150_lvl1data' AND event = 'nodeChg_18150') OR
(cacheid = 'node_193_lvl1data' AND event = 'nodeChg_193') OR
(cacheid = 'node_1_lvl1data' AND event = 'nodeChg_1') OR
(cacheid = 'node_36665_lvl1data' AND event = 'nodeChg_36665') OR
(cacheid = 'node_42201_lvl1data' AND event = 'nodeChg_42201') OR
(cacheid = 'node_4302_lvl1data' AND event = 'nodeChg_4302') OR
(cacheid = 'node_44840_lvl1data' AND event = 'nodeChg_44840') OR
(cacheid = 'node_45443_lvl1data' AND event = 'nodeChg_45443') OR
(cacheid = 'node_47561_lvl1data' AND event = 'nodeChg_47561') OR
(cacheid = 'node_48969_lvl1data' AND event = 'nodeChg_48969') OR
(cacheid = 'node_5_lvl1data' AND event = 'nodeChg_5') OR
(cacheid = 'node_6_lvl1data' AND event = 'nodeChg_6') OR
(cacheid = 'node_7_lvl1data' AND event = 'nodeChg_7') OR
(cacheid = 'node_8_lvl1data' AND event = 'nodeChg_8') OR
(cacheid = 'vB_ChTreeWithLast' AND event = 'vB_ChannelStructure_chg') OR
(cacheid = 'vB_ChannelTreeRaw_56' AND event = 'perms_changed') OR
(cacheid = 'vB_ChannelTreeRaw_56' AND event = 'userPerms_56') OR
(cacheid = 'vB_ChannelTreeRaw_56' AND event = 'vB_ChannelStructure_chg');
MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Tuesday, April 22nd 2014 @ 08:13:49 PM
Error Date : Tuesday, April 22nd 2014 @ 08:13:50 PM
Script : http:///forum/main-category/talk-networking/ideas
Referrer :
IP Address : userip
Username : username
Classname : vB_Database_MySQLi
MySQL Version :
------------------------------------------------------------------------------------------------------
A few days ago we got a similar error:
[Showing truncated query, original length: 20233]
[First 500 chars]
Invalid SQL:
/** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
('node_1_lvl1data','nodeChg_1'),
('getSearchResults_678c0384ffcf2c0e224be53858005a17','perms_changed'),
('getSearchResults_678c0384ffcf2c0e224be53858005a17','vB_ChannelStructure_chg'),
('getSearchResults_678c0384ffcf2c0e224be53858005a17','vB_SearchResults_chg_0'),
('SrchResults0872991455','nodeChg_47102'),
('SrchResults01561326027','nodeChg_47228'),
('SrchResults02627501302','nodeChg_47265'),
('SrchResults0378131356
[Last 500 chars]
'vbnodetext47761_1_0:787cefe106de1b3cdbce612ac3456f0d','nodeChg_2207'),
('vbnodetext47761_1_0:787cefe106de1b3cdbce612ac3456f0d','vB_Language_languageCache'),
('vbnodetext_pre_47761_1_0:787cefe106de1b3cdbce612ac3456f0d','nodeChg_47761'),
('vbnodetext_pre_47761_1_0:787cefe106de1b3cdbce612ac3456f0d','nodeChg_2207'),
('vbnodetext_pre_47761_1_0:787cefe106de1b3cdbce612ac3456f0d','vB_Language_languageCache'),
('vBPage_70929362c8cc980c5fab4b03da2cfc5f_1',''),
('vbPre_conversation292.279.2207.47101','');
MySQL Error : Deadlock found when trying to get lock; try restarting transaction
Error Number : 1213
Request Date : Sunday, April 20th 2014 @ 08:48:12 AM
Error Date : Sunday, April 20th 2014 @ 08:48:14 AM
Script : http:///forum/main-category/talk-networking/ideas
Referrer :
IP Address : userip
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :
------------------------------------------------------------------------------------------------------
- vBulletin Version: vBulletin 5.1.0
- PHP Version: 5.4.17
- MySQL Version: 5.5.31-log
- Any Addons installed: no
- Does the issue occur in a default style? n/a
- Error message on the screen: unsure (error came up in an email)
- Browser and Browser version used: n/a
- A list of steps that can be used to recreate the issue: unsure
Please advise what can be done about this. We looked up this problem and I believe one of the older threads said to do a repair on the "cacheevent" table. We did that twice (since the first similar error), and once more just now. Anything else to be done to fix or minimize this error?
Thanks.
Comment