Got error 12 from storage engine query [#40198]

While common wisdom (google) tells us, that this error is related to the MySQL server running out of memory, or a potential database problem (repair tables), neither apply in my case. In fact the error seems to go away once I disable the cache.
On top of that I have several issues with the cache (race conditions). It appears to me, that the cache could see some improvements.
(Duplicate Entry warning).
While there is a patch on drupal.org to deal with the Duplicate Entry warning (simply suppressing it to be printed out), the Error 12 remains, so I have to turn off caching.
A second site, that does not see as much traffic, does not have this problem, possibly because race conditions are less likely with less traffic. Naturally the site with more traffic would benefit more from the cache.
I am more than happy to provide more detailed information if necessary.
Since the error 12 does not affect the way the page is rendered (except for being printed out), one could simply suppress it from being shown on the page, but this doesn't cure the sickness just the symptoms.

Comments

Comment #1

dopry CreditAttribution: dopry commented 2 February 2006 at 14:19

Status:

Active

» Closed (won't fix)

I haven't experienced this problem on any of my sites running using caching.

If disabling caching prevents the error, I would assume the cache table is getting corrupted on your site. Normally halting the DB server and a (if you are using ISAM tables) myisamcheck will fix the problem.

I don't see than anyone else is reporting the same error. I'm setting this to a won't fix for now. If someone can duplicate this, by all means reopen it.

Comment #2

pyrello CreditAttribution: pyrello commented 5 July 2006 at 16:21

I am now having the same problem with my site.

Comment #3

andre75 CreditAttribution: andre75 commented 6 July 2006 at 04:58

I haven't seen it after switching hosts.

Comment #4

cutesimaus CreditAttribution: cutesimaus commented 29 November 2006 at 00:25

I get this error too.
My cache is disabled. I am using Drupal 4.7

My hosting is complaining that my website have been crashing mysql. If I switch webhost provider, will the situation improve? Or is the problem with my drupal site?

Comment #5

sageroo CreditAttribution: sageroo commented 20 March 2007 at 00:13

Version:

4.6.3

» 5.1

I am having that same problem on my server hosted through MediaTemple.

check it out at:
http://www.tallentsmith.com/cms/

Here is the error
user warning: Got error 12 from storage engine query: SELECT data, created, headers, expire FROM cache_menu WHERE cid = '1:en' in /home/5261/domains/tallentsmith.com/html/cms/includes/database.mysql.inc on line 172.

I have drupal working fine on another domain on the same server.
I am running 5.1