The problem is however slightly complicated. I am getting this issue for the last couple of days and it lasts only for 10-15 minutes. And it does not happen during the period where my forum has the most traffic. In fact, I face zero issues when my forum is getting its peak traffic. Not even an issue when a cronjob is running in the background taking a sql dump, compressing it and uploading it to Amazon S3.
I have not installed any new plugin in the recent days. None of the other sites on the VPS has enough traffic to cause this issue. The baffling part is that the issue starts at around 3:10pm IST and lasts till 3:30pm and fixes on its own.
I have requested Dreamhost to look into the issue again. I am on a VPS so I have enough server resources available to me. Though I believe I am using a shared MySQL server so someone other user on the same MySQL server might be causing this issue at my end.
I am looking for ideas on what could be causing this issue if my own forum is the problem.
Mysqli statement execute error : Prepared statement needs to be re-prepared Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297 Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479 Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 632 Zend_Db_Adapter_Abstract->update() in XenForo/Session.php at line 805 XenForo_Session->saveSessionToSource() in XenForo/Session.php at line 541 XenForo_Session->save() in XenForo/Controller.php at line 412 XenForo_Controller->updateSession() in XenForo/Controller.php at line 356 XenForo_Controller->postDispatch() in XenForo/FrontController.php at line 354 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134 XenForo_FrontController->run() in /home/domain/domain.co/index.php at line 13