database error "Got error 28 from storage engine query: SELECT DISTINCT(p.perm)"
batigolix - January 10, 2006 - 20:18
When i check the messages on the watchdog page on /admin, i see an awful lot of
Got error 28 from storage engine query: SELECT DISTINCT(p.perm)
errors.
When I check the details I see that this error happens on several pages, not 1 in particular
The additional information on the details page is:
Type php
Datum Dinsdag, januari 10, 2006 - 14:38
Gebruiker Anonieme bezoeker
Locatie /node/9
Bericht 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 /usr/local/www/doesb.org/www/drupalx/includes/database.mysql.inc on line 66.
Severity error
Hostnaam 68.142.249.73Pardon the Dutch.
Anybody knows what it can be?
All suggestions are welcome.
Your filesystem is full
This happened to me this morning =)
The error come when MySQL doesn't have any free hard disk space to write to. Check your /tmp directory, that's where I had run into problems. I had forgot to make my backup script delete older backups and it kept writing backups until the disk was full.
- Robert Douglass
-----
My Drupal book: Building Online Communities with Drupal, phpBB and WordPress
I'm hosting a site on a shared hosting account
and I received this error --
My tmp dir was empty, and I had plenty of disk space left in my server account. The size of my database file was relatively small (2.1 MB), but I emptied the cache to save some space.
Basically, I didn't see anything that looked out of the ordinary.
While the error went away, I'm wondering of this error is caused by something on my site, or could this be caused by another site on the shared server using the same MySQL install?
Thanks,
Bill
-------
http://www.funnymonkey.com
Tools for Teachers
This problem reappeared today --
I'm currently trying to sort this out with my hosting company --
I've truncated the caches of my db'es in an effort to save space, yet the error persists.
Can this be caused by other customers on the shared server using the same MySQL install?
Thanks,
Bill
-------
http://www.funnymonkey.com
Tools for Teachers
I figured this one out
and the answer is, yes, on shared hosting, you share a MySQL install (and the space allotted for the MySQL install) with all the other users on a server.
So, if you have a shared hosting account and your db address is "localhost", you are sharing that MySQL install with other users on your server. Consequently, you can receive the ""Got error 28 from storage engine query" through no fault of your own -- it just means that their is no storage space left in the install.
Hope this helps someone down the road.
Cheers,
Bill
-------
http://www.funnymonkey.com
Tools for Teachers
so anything we can do if our darabase is full
anything we can do if our db is full
and if i buy a server will i not face this problem i mean dedicated server
Reason confirmed one more time
I've got the same errors, checked with my provider (www.hostingit365.com) and the reason is the same - tmp directory was full. They cleaned it up and now things are back to normal.
Same here,, Cleaning up
Same here,, Cleaning up /var/log/mysql helped a lot :)
Same way to success
Likewise, I requested that my host provider clean up the tmp (temp) directory, and the problems disappeared.