Recently mysql query's fail on different type of errors.
Mysql processes are restarting every few minutes !
I found out that if I disable the quota on the disk the mysql
is install the problems are workaround.
mysql user and group got lot of free disk space :
>/sbin/quotaoff /dev/hda4
>quota -v mysql
Disk quotas for user mysql (uid 116):
Filesystem blocks quota limit grace files quota limit
grace
/dev/hda4 88415 1000000 2000000 87 1000 2000
>quota -g mysql
Disk quotas for group mysql (gid 116):
Filesystem blocks quota limit grace files quota limit
grace
/dev/hda4 4 512001 512000 6 1000 2000
here some of the errors:
query error:
Got error 122 from table handler
read_next_with_key: Got error 120 when reading table ./deldb/messages_store
from the error log file:
mysqld got signal 11;
...
0x8133c4a
0x80e3c00
0x80e4b1d
0x80edb4e
0x80edbd6
0x80edbd6
0x80edd4e
0x80edc7d
0x80c0759
0x80ba617
0x80ba308
0x80bb5a3
0x80b7607
0x809a31a
0x8098795
0x808168f
0x80853fc
0x8080aed
0x808000e
I'm using linux Kernel 2.2.14C11 and mysql 3.23.37-1
Any Idea how can I solve this problem. I must have quota back on.
Dib Urim
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
