error message mysql

[chriz]

Any idea why I get this message?
I tried mysqladmin -u xxx flush-logs -p xxx because I thought the logfile had become to big but to no avail.
I can access the database using phpmyadmin and everything checks out OK.

Exhibit Engine MySQL error!
ERROR FROM QUERY group_links in page 'index':

------------------------------
Got error 28 from table handler
------------------------------

If you encounter this error with unmodified EE source code please mail this error to EE developers with version number, detailed circumstances when it happened and preferably with a database backup dump. All reports helps improving EE to your satisfaction. Thank Y

[Pekka]

Error code 28: No space left on device

http://www.mysql.com/news-and-events/newsletter/2003-10/a0000000249.html

In shared servers they might set you a quota for mysql, ask your system admin to increase it or fix the situation by adding disks.

Try also purging Uncookied data and messages (this might help for a moment, but the main problem is lack of disk space).

PS. EE does not use any temporary tables by design.

[chriz]

I have 120 Gigabytes of space, that cannot be the problem (I think)

[Pekka]

Run perror on your machine, maybe it gives a different error message.

Check that you do not have quota set on user mysql.

[chriz]

perror 28 says : no space left on device
no quota set for user mysql
I had this problem a while ago and mysqladmin -u xxx flush-logs -p xxx solved the problem.
Not this time though

[chriz]

when checking variables from mysql:
ibdata1:10M:autoextend
and in the folder /var/lib/mysql I find a file called ibdata1 with size 18.874.368
and ib_logfile0 and ib_logfile1 each of size: 5.242.880

[Pekka]

ibdata is innodb table system data - EE uses myisam. You must have something else running on the system which hogs all innodb space. See http://www.mysql.com/search/?q=ibdata1

I have disabled innodb totally from my servers.

[chriz]

Thank you, I'll do some research.

Chriz

[chriz]

Nothing yet.
I can access the database from phpmyadmin
also from the input folder where I can perform all operations on the database
but when jumping to public folder, I get this 28 error
Should find a solution soon.

[Pekka]

Try running this in PhpMyAdmin, perhaps you get more info:

(NOTE get the query by replying to this post and copy it from there, forum software adds odd spaces to display)


SELECT DISTINCT
ee_exhibition_group_eng.ee_exhibition_group_name,
ee_exhibition_group_eng.ee_exhibition_group_descri ption,
ee_exhibition_to_group.ee_exhibition_group_id,
ee_exhibition_group_eng.ee_groupthumbs_style,
ee_exhibition_group_eng.ee_groupthumbs_amount,
ee_exhibition_group_eng.ee_groupthumbs_size,
ee_exhibition_group_eng.ee_exhibition_group_image,
ee_order_to_group.ee_order
FROM
ee_exhibition_to_group,
ee_order_to_group,
ee_exhibition_group_eng
WHERE
ee_exhibition_group_eng.ee_exhibition_group_id = ee_exhibition_to_group.ee_exhibition_group_id
AND ee_order_to_group.ee_exhibition_group_id = ee_exhibition_group_eng.ee_exhibition_group_id
ORDER BY
ee_order_to_group.ee_order ASC

[chriz]

This is the response:

MySQL said: Documentation
#1054 - Unknown column 'ee_exhibition_group_eng.ee_exhibition_group_descr i' in 'field list'

[Pekka]

Please note my note about how to copy that query. Click "Quote" reply button and copy it from there.

[chriz]

sorry

MySQL said: Documentation
#1030 - Got error 28 from table handler

[Pekka]

Ok, take

ORDER BY
ee_order_to_group.ee_order ASC

out from the query and try again.

[chriz]

same error

[Pekka]

Next I would try:

Go to EE Backup and backup only tables

ee_exhibition_to_group
ee_order_to_group
ee_exhibition_group_xxx

where xxx is any language code. Make a file backup.

Then restore that backup. This will drop the tables, recreate and fill them again. Hopefully this will fix the disk error (each mysql table is stored as a file).

[chriz]

Well, with my limited knowledge of linux it took longer than expected to solve above problem, but here is the solution:

The lack of free disc space in root "/" partition prevented mysqld service from working correctly:

Filesystem Size Used Avail Use% Mounted on
/dev/hda1 510M 491M 0 100% /
none 502M 0 502M 0% /dev/shm
/dev/hda7 100G 4.2G 96G 5% /home
/dev/hda5 4.9G 1020M 3.9G 21% /usr
/dev/hda6 4.9G 4.8G 97M 99% /var

After moving Plesk distributives to:

Filesystem Size Used Avail Use% Mounted on
/dev/hda1 510M 225M 259M 47% /
none 502M 0 502M 0% /dev/shm
/dev/hda7 100G 4.5G 96G 5% /home
/dev/hda5 4.9G 1020M 3.9G 21% /usr
/dev/hda6 4.9G 4.8G 97M 99% /var

I need to release the \var partition too.

Hope this helps others who might one day experience the same problem.

Chriz