Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
By batigolix on
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.73
Pardon the Dutch.
Anybody knows what it can be?
All suggestions are welcome.
Comments
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
-------
http://www.funnymonkey.com
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
-------
http://www.funnymonkey.com
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
-------
http://www.funnymonkey.com
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
Just a note to say thanks,
Just a note to say thanks, popped this up from a google search from the error and yout got it in one.
adam
Thanks!
@robertDouglass - We also ran into this issue and it was due to MySQL running out of space. Thanks for helping us debug this.
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.
error 28
Hi ,
I am getting this warning and page is not displayed ,this was the last view i have made in this site.For all other views it works fine.Is it becoz of any problem in that view.I am using the same server for a database used by the development server also.Can u pls help me.where shall find this tmp folder.
user warning: Got error 28 from storage engine query: SELECT node.nid AS nid, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node.type AS node_type, node.vid AS node_vid, node_data_field_date.field_item_value AS node_data_field_date_field_item_value, node_data_field_date.field_seaonalimage_fid AS node_data_field_date_field_seaonalimage_fid, node_data_field_date.field_seaonalimage_list AS node_data_field_date_field_seaonalimage_list, node_data_field_date.field_seaonalimage_data AS node_data_field_date_field_seaonalimage_data, node_data_field_date.field_content_value AS node_data_field_date_field_content_value, node_data_field_date.field_content_format AS node_data_field_date_field_content_format, node_data_field_date.field_culinaryuses_value AS node_data_field_date_field_culinaryuses_value, node_data_field_date.field_culinaryuses_format AS node_data_field_date_field_culinaryuses_format, node.created AS node_created FROM node node LEFT JOIN content_type_seasonalspecial node_data_field_date ON node.vid = node_data_field_date.vid WHERE (node.status <> 0) AND (node.type in ('seasonalspecial')) ORDER BY node_data_field_date_field_date_value DESC, node_created ASC LIMIT 0, 4 in /home/domain/public_html/sites/all/modules/views/includes/view.inc on line 771.
Thanks
Helpful Thread
Saved me lots of troubleshooting. Thanks!
full /tmp filesystem
have seen this error on a small site on shared hosting.
here is another confirmation for the cause - full /tmp filesystem
Cheers !
Had similiar issue. My
Had similiar issue. My watchdog logs were empty and my views would show up as empty. Since the tmp files were full, the views couldnt create a cache of the view hence it showed up empty.
Server issue.