Forums » Error:Mysqli statement execute error : Got error 28 from storage engine

RSS feed for this topic

Info

  1. ebellempire Posted 2 years ago

    I have no idea what's going on, but we are getting this error:

    Error:Mysqli statement execute error : Got error 28 from storage engine

    I have not changed any settings. Our server went down for a while yesterday and then this happened about 8 hours after the server came back up.

    If someone has an explanation or fix, I would really appreciate it. I am in the middle of a large workshop where attendees are using the site and need full access. ...yikes

    Thanks -- Erin

  2. ebellempire Posted 2 years ago

    A little more information. We are running on a LAMP JumpBox. The site is here: http://csudigitalhumanities.org/exhibits/

    I checked the database in PHPmyAdmin and am getting the same errors (on the items table).

    We have three other Omeka installation on our server that are all effectively broken now, so my guess is that our IT people reset the server and changed some settings.

  3. John Flatness (Omeka Dev Team) Posted 2 years ago

    Error code 28 means "no space left on device". MySQL can throw this error when there is no space remaining for it to store the database, temporary files, or its log.

    Frequently, when MySQL gives error 28, this means there is not enough disk space remaining in the server's temporary directory (/tmp). On many servers, even though there is more than enough space remaining on the disk, /tmp is limited to a certain size.

    You can ask your server administrators to free up some space in /tmp by deleting some files, or increasing the space allocated to /tmp. Either fix should clear the error.

  4. ebellempire Posted 2 years ago

    Thanks a lot. I passed this along to our IT guys.

    Should I expect any long-term impact on my database? It seems broken now, but maybe freeing up space will restore it? I would hate to have to restore to an outdated backup.

    Thanks again.

  5. John Flatness (Omeka Dev Team) Posted 2 years ago

    Generally, when the space or quota problem is relieved, the error 28 will go away and you should be able to access your data again.

    It would be prudent to avoid writing to the database, if possible, while this problem persists, though.

Reply

You must log in to post.