Random fatal errors, forum and dashboard become temporarely unreachable.

NickW

Hey there,

I've been spending the past two weeks setting up this vanilla forum for this game I'm working on. As we were conducting stress tests we noticed that the forum would randomly display fatal errors, which would remedy themselves after a few seconds. No matter what we did, we weren't able to reproduce these errors, and they didn't seem to be server-load related, as they could also appear randomly while I was browsing the forum on my own.

After some searching on your troubleshooting forum, I found a related topic concerning the flagging plugin. I disabled the plugin, and the issue appeared to have been remedied, or so I thought.

That was until only a few hours later, I deleted all my test topics, ready to launch the forum, and once again encountered the following error as I was attempting to the post the welcoming message:

I will add that I'm quite the noob when it comes to php and mysql. Anyone here who might be able to tell me what exactly I'm looking at?

Cheers,

Nick

vrijvlinder

General error: 1615 Prepared statement needs to be re-prepared.
This error occurs when mysqldump is in progress. It doesn't matter which DB dump is in progress. Wait for the dump to finish and this error will vanish.The issue is with the table definition being dumped which cause this error.

To trouble shoot this properly you need to disable all plugins you have enabled and use the default theme, delete the .ini files in the cache and enable the plugins one by one until you find the problem if it is a plugin's fault.

Look at your cgi error logs.

River

May not be related at all, but important. You are using an old php version 5.4. 5.4 that is no longer supported. Consider upgrading php version and mysql versions.

Consider php 5.6 as the version to move to, a stable vanilla is not quite php 7.0 ready.

http://php.net/supported-versions.php

You may need to re-configure some variables. Talk to your host.

Here are some other answers.

https://vanillaforums.org/discussion/27184/error-prepared-statement-needs-to-be-re-prepared

http://stackoverflow.com/questions/25873883/general-error-1615-prepared-statement-needs-to-be-re-prepared

http://stackoverflow.com/questions/4380813/how-to-get-rid-of-mysql-error-prepared-statement-needs-to-be-re-prepared

http://blog.corrlabs.com/2013/04/mysql-prepared-statement-needs-to-be-re.html

NickW

River, vijvlinder, thanks for the advice! I'll be looking into this today.