Hi,
Can someone please provide some insight as to what I can do to properly fix the cacheevent table? Since upgrading to vBulletin 5 connect, we've had nothing but issues and this table keeps crashing repeatedly. I've seen someone suggest truncating the table could potentially fix this issue, but was wondering specifically how I would do that without affecting anything seriously.
At this point I'm having to repair the table every couple of days, and it's causing a lot of issues for users of our forum. Below is some example output from mysql:
mysql> check table cacheevent;
+----------------------+-------+----------+----------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+-------+----------+----------------------------------------------------------------------+
| myvbulletinforum.cacheevent | check | warning | Table is marked as crashed |
| myvbulletinforum.cacheevent | check | warning | 1 client is using or hasn't closed the table properly |
| myvbulletinforum.cacheevent | check | warning | Found 2282340 deleted space in delete link chain. Should be 2286136 |
| myvbulletinforum.cacheevent | check | error | Found more than the expected 40432 deleted rows in delete link chain |
| myvbulletinforum.cacheevent | check | error | record delete-link-chain corrupted |
| myvbulletinforum.cacheevent | check | error | Corrupt |
+----------------------+-------+----------+----------------------------------------------------------------------+
6 rows in set (12.86 sec)
Thanks in advance to anyone that can assist!
Can someone please provide some insight as to what I can do to properly fix the cacheevent table? Since upgrading to vBulletin 5 connect, we've had nothing but issues and this table keeps crashing repeatedly. I've seen someone suggest truncating the table could potentially fix this issue, but was wondering specifically how I would do that without affecting anything seriously.
At this point I'm having to repair the table every couple of days, and it's causing a lot of issues for users of our forum. Below is some example output from mysql:
mysql> check table cacheevent;
+----------------------+-------+----------+----------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+-------+----------+----------------------------------------------------------------------+
| myvbulletinforum.cacheevent | check | warning | Table is marked as crashed |
| myvbulletinforum.cacheevent | check | warning | 1 client is using or hasn't closed the table properly |
| myvbulletinforum.cacheevent | check | warning | Found 2282340 deleted space in delete link chain. Should be 2286136 |
| myvbulletinforum.cacheevent | check | error | Found more than the expected 40432 deleted rows in delete link chain |
| myvbulletinforum.cacheevent | check | error | record delete-link-chain corrupted |
| myvbulletinforum.cacheevent | check | error | Corrupt |
+----------------------+-------+----------+----------------------------------------------------------------------+
6 rows in set (12.86 sec)
Thanks in advance to anyone that can assist!
Comment