By jazzylee77 on

A site has gone dysfunctional on me!

I'm getting this error

user error: Got error 28 from storage engine
query: SELECT t.* FROM term_hierarchy h, term_data t WHERE h.parent = t.tid AND h.tid = 24 ORDER BY weight, name in /home/holidays/public_html/includes/database.mysql.inc on line 66.

I was adding an article before this came up. Now I have access denied to remove the article.

I thought I'd see if this rings a bell with anyone before I roll back to the last saved database.

⋅ Categories: Drupal 4.6.x

Comments

jazzylee77’s picture

jazzylee77 commented

Now I see that I'm getting this error from every drupal site I have on a particular server.

edit...ooops some are working on that server.

a different variety error from another site

user error: Got error 28 from storage engine
query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 0 in/includes/database.mysql.inc on line 66.

nevets’s picture

nevets commented

I am wondering if the server has run out storage space (hard disk) given it impacts more than one site. I would send an email to the sort for you hosting company.

jazzylee77’s picture

jazzylee77 commented

I'm messaging with tech support. They tried restarting mysql. didn't help. There should be plenty of storage available.

jazzylee77’s picture

jazzylee77 commented

I've checked all folders for unusal files, comparing to original drupal files. See nothing new. Tried upgrading 4.6.6 on one site. 3 sites are down.

jazzylee77’s picture

jazzylee77 commented

The host got it straightened out, but not before I wasted a Sunday afternoon looking for nonexistent problems with my sites!

I was all prepared to sit down and crank out a few articles. Maybe I'll stretch my legs a bit and have another go at it.

TheFazz’s picture

TheFazz commented

this has become quite a problem for me. is there any drupal workaround for this?

my error logs today runs at 130 pages (and counting) between 2:44pm to 4:26pm on the same day (today)!

i need help.

fazz

http://www.my-kart.org/

BioALIEN’s picture

BioALIEN commented

We just experienced a similar problem. Exactly the same error but not the same query returned.
user warning: Got error 130 from storage engine query: SELECT data, created, headers, expire FROM cache_views WHERE cid = 'views_urls' in /usr/home/site/public_html/includes/database.mysql.inc on line 172.

There are about 100 of these per page across the entire site.

Can anybody point us in the right direction before proceeding to clear the cache table? The thread wasn't very specific on what the solution was.

UPDATE:
OK anybody facing the same problem, it's related to the DB locking issue which hopefully will be resolved in Drupal 6. Clear cache should provide some help for those facing the same problem. But you may have to get dirty with phpMyAdmin and remove some offending tables and roll in the backups.
---
Dee
iScene Interactive :: iScene.eu

kvarnelis’s picture

kvarnelis commented

I had the same problem on varnelis.net this morning, but I optimized the tables in phpmyadmin, bringing them down from around 100mb to 50mb and it fixed the problem.

anantagati’s picture

anantagati commented

I had this error on Drupal 4.7.6:
user error: Got error 28 from storage engine query: SELECT t.* ....

It was because my disk quote on hosting server was fully used. So when I deleted backup files error disappeared.

cburn’s picture

cburn commented

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 = 'diver' AND b.status = 1 AND (r.rid IN
(1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in
/home/homefan4/public_html/modules/block/block.module on line 433.

Web host support said it was a server prob. They supposedly have it fixed now. Our calendar's & Top Stories dynamic display block's content went missing http://homewoodpubliclibrary.org/. I had no other recourse but to restore the website back to 2 weeks ago b/c my daily backups for last 2 weeks were destroyed. Grrrrr! So we lost 2 weeks of fresh content. Lesson learned: Keep a copy of all updated content on MY computer!