Server crash

[Mark.B]

Thanks for your reply, Wayne.

Date and Index Lengths:

cache: 16384 & 16384
cacheevent: 6602752 & 4653056
searchlog: 170934272 & 11599872

After a truncate of these tables the memory usage returns to normal.

I suspect that for the time being the temporary fix is to regularly clear out those tables.
The full fix for sites affected by this will (as Wayne says) be n 5.3.4.

[Fleiding]

Thanks Mark, I will wait for 5.3.4. In the mean time, can I create a scheduled task like this? Advised to run this hourly?

<?php if (!defined('VB_ENTRY')) die('Access denied.');

$sql = new mysqli;
mysqli_query($sql, "truncate cache");
mysqli_query($sql, "truncate cacheevent");
mysqli_query($sql, "truncate searchlog");
$sql->close();

?>

[Mark.B]

No reason why not, I'm not enough of a coder to know if that's the best code to use, but yes that ought to work.

[Fleiding]

I think I know what causes the issue. I use the link below to show the new posts on my forum. I just pressed the link and immediately hit return on my browser which caused the page to load again. At that moment, the server crashed.

search?searchJSON=%7B%22view%22%3A%22topic%22%2C%22unread_only%22%3A1%2C%22sort%22%3A%7B%22lastcontent%22%3A%22desc%22%7D%2C%22exclude_type%22%3A%5B%22vBForum_PrivateMessage%22%5D%7D

Is this linked to the issue that will be fixed in 5.3.4.?

[Wayne Luke]

That is a standard search based URL using JSON. It is no different than any other search on the system, including those used by every search module. The fix for the searchlog table would cover this as well. However, we would need more detailed information from your server logs (httpd, php, and mysql) including the time of the query and all error messages to determine if this actual query is the culprit.