hi since last week, almost everyday i received database error email like below. i need to restart my sql service or even reboot my server everytime i encounter this issue. anyone has this issue before? may i know how to slove? thanks

Database error in vBulletin 5.6.3:

Invalid SQL:
/** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'getSearchResults_79a3e86e5a89d1022bbb6e95a8ea8d51 ' AND event = 'nodeChg_2931616') OR
(cacheid = 'getSearchResults_79a3e86e5a89d1022bbb6e95a8ea8d51 ' AND event = 'perms_changed') OR
(cacheid = 'getSearchResults_79a3e86e5a89d1022bbb6e95a8ea8d51 ' AND event = 'vB_ChannelStructure_chg') OR
(cacheid = 'getSearchResults_79a3e86e5a89d1022bbb6e95a8ea8d51 ' AND event = 'vB_SearchResults_chg_15062') OR
(cacheid = 'vbPre_conversation397.380.179.2931616' AND event = '');

MySQL Error : Lock wait timeout exceeded; try restarting transaction
Error Number : 1205