MYSQL Too many connections Disk is full writing (Errcode: 122).

Submitted by masp on Sat, 02/05/2011 - 12:40

Hello,
Why mysql cant write ?
****************
MYSQL******Too many connections*
*****************
110205 6:39:04 [ERROR] /usr/sbin/mysqld: Table './qazxswedc/fm_comments' is marked as crashed and last (automatic?) repair failed
110205 6:39:04 [ERROR] /usr/sbin/mysqld: Table './qazxswedc/fm_comments' is marked as crashed and last (automatic?) repair failed
110205 6:39:04 [ERROR] /usr/sbin/mysqld: Table './qazxswedc/izzzzz_comments' is marked as crashed and should be repaired
110205 6:39:04 [Warning] Checking table: './qazxswedc/izzzzz_comments'
110205 6:39:04 [Warning] Recovering table: './qazxswedc/izzzzz_comments'
110205 6:39:04 [ERROR] /usr/sbin/mysqld: Disk is full writing './qazxswedc/izzzzz_comments.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 $
110205 6:49:04 [ERROR] /usr/sbin/mysqld: Disk is full writing './qazxswedc/izzzzz_comments.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 $
110205 6:59:04 [ERROR] /usr/sbin/mysqld: Disk is full writing './qazxswedc/izzzzz_comments.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 $
110205 7:09:04 [ERROR] /usr/sbin/mysqld: Disk is full writing './qazxswedc/izzzzz_comments.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 $
110205 7:19:04 [ERROR] /usr/sbin/mysqld: Disk is full writing './qazxswedc/izzzzz_comments.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 $
110205 7:29:04 [ERROR] /usr/sbin/mysqld: Disk is full writing './qazxswedc/izzzzz_comments.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 $
110205 7:33:37 [ERROR] /usr/sbin/mysqld: Table './qazxswedc/fm_comments' is marked as crashed and last (automatic?) repair failed
110205 7:33:37 [ERROR] /usr/sbin/mysqld: Table './qazxswedc/fm_comments' is marked as crashed and last (automatic?) repair failed
110205 7:33:37 [ERROR] /usr/sbin/mysqld: Table './qazxswedc/fm_comments' is marked as crashed and last (automatic?) repair failed
110205 7:33:37 [ERROR] /usr/sbin/mysqld: Table './qazxswedc/fm_comments' is marked as crashed and last (automatic?) repair failed
110205 7:33:37 [ERROR] /usr/sbin/mysqld: Table './qazxswedc/fm_comments' is marked as crashed and last (automatic?) repair failed
110205 7:33:37 [ERROR] /usr/sbin/mysqld: Table './qazxswedc/fm_comments' is marked as crashed and last (automatic?) repair failed
110205 7:39:04 [ERROR] /usr/sbin/mysqld: Disk is full writing './qazxswedc/izzzzz_comments.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 $
110205 7:49:04 [ERROR] /usr/sbin/mysqld: Disk is full writing './qazxswedc/izzzzz_comments.TMD' (Errcode: 122). Waiting for someone to free space... Retry in 60 $

cat /etc/fstab
proc /proc proc defaults 0 0
none /dev/pts devpts gid=5,mode=620 0 0
/dev/md0 none swap sw 0 0
/dev/md1 /boot ext3 defaults 0 0
/dev/md2 / ext3 grpquota,usrquota,rw 0 0

#quota -u mysql
Disk quotas for user mysql (uid 104): none
#quota -g mysql
Disk quotas for group mysql (gid 108): none

Status: 
Active

Comments

Submitted by JamieCameron on Sat, 02/05/2011 - 13:15

Is the domain that owns these databases perhaps at or over quota?

Submitted by JamieCameron on Sat, 02/05/2011 - 13:44

If you go to Webmin -> System -> Disk Quotas -> Group quotas on / , does it show any groups over quota?

Also, is the disk full? The df -h command will tell you ..

Submitted by JamieCameron on Sat, 02/05/2011 - 14:37

Yeah, it is a MySQL bug that happens with InnoDB tables - the only solution is to increase the quota.

Submitted by JamieCameron on Sat, 02/05/2011 - 14:38

Or switch to a different table type.

Submitted by masp on Sun, 02/06/2011 - 13:50

ON front page Only top 20 servers shown

What means

red purple blue

Lines on graph ?

(I am more interesting like blue color.... )

Submitted by JamieCameron on Sun, 02/06/2011 - 16:50

Red = usage, blue = limit, purple = usage by databases