Error 12

[ShadowRaven]

I just got this out of the blue for the first time, and don't know what could have caused it..:

SELECT count(petitionid) AS c,status FROM petitions GROUP BY status
Got error 12 from storage engine
Call Stack:
1: db_query("SELECT count(petitionid) ...") called from /www/r/ravenslotgdc/htdocs/lib/dbwrapper.php on line 64
2: db_query_cached("SELECT count(petitionid) ...", "petition_counts") called from /www/r/ravenslotgdc/htdocs/lib/pageparts.php on line 290
3: page_footer() called from /www/r/ravenslotgdc/htdocs/village.php on line 304

I was refreching the village when I got this.
any ideas ?
(I clicked back on the browser and refreshed the village again, and its fine now, so only got it that once so far)

[Sichae]

Error 12 means there is not enough memory (Free RAM) to allocate, meaning that you probably have a memory leak somewhere or simply, something overloaded your RAM at that point.

[Dannic]

This is a MySql error.  It is well documented and I don't know that there is a "fix" for it yet.  As Sichae says, it is a memory leak of some sort.  The more modules you run the more likely you are to encounter this problem.

You will need to get with your host to see if they can figure out how to fix it.  I know I had it for nearly 2 months off and on before it finally went away.  

Of course I moved to a new server as well so that might have been it.

Either way, MySql is the culprit.

I solved my problems temporarily by disabling modules until it went away.

[ShadowRaven]

Alright, thanks for the info, Sichae and Dannic. I guess I won't worry too much about right now then, since I'll be moving to a new server in the next couple of days or so.

thanks,
~SR