Got error 28 from Storage Engine

Management and Administration
1

mike-h30 wrote on Monday, August 25, 2008:

After entering a new patient a user reported this error when attempting to log back in to OpenEMR-2.8.3.

ERROR: query failed: select distinct name from groups (ERROR: query failed: select distinct name from groups (Got error 28 from storage engine)

I googled this error message and it appears to be a partition size issue where the MySQL databases are located.  I am currently off site and cannot VNC into the server to check the partition sizes.  I am guessing the culprit might be our web based fax application that is storing all of our faxes (PDF Files) both incoming/outgoing on the web root.  We also store a lot of PDF’s in the patient charts ( documents directory in OpenEMR).  However faxes are the heavier daily pay load.  I will not know for sure until I reboot and log into the server.

I am running SUSE Linux Enterprise Server 10 - SP1.  I set  the server up with the default partition settings.

I am curious if anyone has experienced this error and how it was resolved.

Regards,

-Mike

2

openemrhq wrote on Thursday, August 28, 2008:

Hi Mike,

Yes, we’ve experienced this issue before and it’s always been that the partition that the db lived on was out of space. If I remember correctly, and I’d have to check with our admins about this, the only way to solve it is to increase the size of your partitions.

Linux has a number of tools that can help you do this. Let me know if you need some help!

Dave Kennerson
OpenEMR HQ, Inc.

3

mike-h30 wrote on Thursday, August 28, 2008:

Thanks Dave.  I have resolved the issue by freeing up some hard disk space.

I need to look into what added an additional 50GB to our hard drive.  I had some old cron back up jobs that are no longer running ( or at least I believe they are not running) that might be the issue.

-Mike