Hi,
I am having more and more SQL lock timeout issues with cacheevent table :
Invalid SQL:
/** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
('getSearchResults_024492b51d195c19b349bea96ca6674d','perms_changed'),
('getSearchResults_024492b51d195c19b349bea96ca6674d','vB_ChannelStructure_chg'),
('getSearchResults_024492b51d195c19b349bea96ca6674d','vB_SearchResults_chg_0');
MySQL Error : Lock wait timeout exceeded; try restarting transaction
Error Number : 1205
Request Date : Sunday, September 24th 2017 @ 04:07:00 AM
Error Date : Sunday, September 24th 2017 @ 04:07:51 AM
When i try to truncate the table the server crashes and i end up rebooting it (but it works in the end).
The tabe grew to something like 700Mb which seems a lot.
Is there any way to just disable cacheevent or at least make it rotate somehow ?
Thanks.
I am having more and more SQL lock timeout issues with cacheevent table :
Invalid SQL:
/** saveDbCache */REPLACE INTO cacheevent (cacheid, event) values
('getSearchResults_024492b51d195c19b349bea96ca6674d','perms_changed'),
('getSearchResults_024492b51d195c19b349bea96ca6674d','vB_ChannelStructure_chg'),
('getSearchResults_024492b51d195c19b349bea96ca6674d','vB_SearchResults_chg_0');
MySQL Error : Lock wait timeout exceeded; try restarting transaction
Error Number : 1205
Request Date : Sunday, September 24th 2017 @ 04:07:00 AM
Error Date : Sunday, September 24th 2017 @ 04:07:51 AM
When i try to truncate the table the server crashes and i end up rebooting it (but it works in the end).
The tabe grew to something like 700Mb which seems a lot.
Is there any way to just disable cacheevent or at least make it rotate somehow ?
Thanks.
Comment