Help: Got error 28 from storage engine query..... database.mysql.inc on line 172

By faqing on 28 Feb 2008 at 22:16 UTC

My websites (Drupal 5.6) often has the following message. This is only appear occasionally and only display to some pages with taxmony terms. Anyone got the same problem? Actually, it also appears on my D6 sites. Is it the problem of my server?

-----------------------
user warning: Got error 28 from storage engine query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (1) in /home/ibcacth/public_html/en/includes/database.mysql.inc on line 172.
user warning: Got error 28 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid IN ('1','2','3','5','6','8','9','10','11','14','15','16','17')) AND ( r.nid = 92 ) ORDER BY v.weight, t.weight, t.name in /home/ibcacth/public_html/en/includes/database.mysql.inc on line 172.
user warning: Got error 28 from storage engine query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'ibc_faqing' AND b.status = 1 AND (r.rid IN (1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/ibcacth/public_html/en/includes/database.mysql.inc on line 172.

Comments

After I logged in, the

faqing commented 29 February 2008 at 21:28

After I logged in, the message disappears. I just don't understand this problem.

I'm also getting a similar

nmridul commented 27 September 2008 at 15:01

I'm also getting a similar error...

"user warning: Got error 28 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 8 ORDER BY v.weight, t.weight, t.name in /home/mridulna/domains/mridul.co.in/public_html/modules/taxonomy/taxonomy.module on line 618".

I solved my problem by

faqing commented 4 October 2008 at 02:04

I solved my problem by increasing the PHP memory, see here how: http://thanhsiang.org/faqing/node/95

I just ran into these errors! This fixed it for me.

bomarmonk commented 8 January 2009 at 02:21

The php memory increase above worked for the time being! Excellent!

Increasing PHP memory worked for me too.

ttripp commented 11 March 2012 at 16:33

Just woke up to this error on one of my smaller sites. First tried emptying the /tmp folder to no avail. Noticed that while I was getting the error I couldn't even optimize tables having overhead or empty tables like cache...
Finally tried the .htaccess mod to increase PHP memory and it worked. Thanks for the tip!!!!

my /tmp is NOT filled up

betawavetom commented 27 November 2008 at 01:19

I am receiving the same issue.
Hostgator is being helpful in trying to resolve this, but we are not finding where the true culprit lies.

Anonymous visitors get the error and consequently an "access denied" page, whilst when I log on everything is fine.
Website in question is http://www.breastfeedingconferences.com

-
I do not see things the way they are - I see them the way I am

Hostgattor

MGParisi commented 2 June 2009 at 14:30

Host Gattor limits PHP Memory to 64Mbits. This will greatly limit your success in Drupal and maybe why no changes to php memory in php.ini fixes the issue.

my /tmp is NOT filled up

betawavetom commented 30 November 2008 at 04:41

I am receiving the same issue.
Hostgator is being helpful in trying to resolve this, but we are not finding where the true culprit lies.

Anonymous visitors get the error and consequently an "access denied" page, whilst when I log on everything is fine.
Website in question is http://www.breastfeedingconferences.com

--
Actually, it is ALL Drupal websites [version 5.x + 6.x] that are affected.

-
I do not see things the way they are - I see them the way I am

So what was the cause of this

Fixdit commented 4 April 2009 at 22:31

So what was the cause of this issue and the fix, I'm experiencing the same problem!?!?

There seems to be too Posibilities

MGParisi commented 2 June 2009 at 14:42

It could be that you are running out of Memory.

You can delete all files under /tmp (this is not under publc_html) but in the same directory this folder is.

I indiscriminately deleted everything under the /tmp directory and it fixed the issue. I do not know why this would be a problem, I have plenty of space according to Cpanel. I have a feeling the tmp directory has its own limits on how much space it can consume.

The tmp file directory for

faqing commented 2 June 2009 at 15:33

The tmp file directory for mysql caused the problem. You can check your cpanel server status.

Have the same problem

Cyberespia commented 15 June 2009 at 04:26

I am receiving the same issue, my site www.adictoshp.org with drupal 6.12
helpp

Disk size

keesje commented 3 August 2009 at 11:46

Disk size (lack off, to be specific) is the culprit indeed. In my case this message was logged mostly during nightly hours.
The cause was temporary diskspace usage by the nightly backup script, archiving all user data on the server daily consuming all diskspace available. So, cleaning up your /tmp folder might help, but does not solve the issue itself in most cases. A webserver admin has to make sure there is plenty of extra room (>25%?) on the harddisk for temporary files and backups. This issue is not Drupal specific.

Luck,

Kees