"dump failed! mysqldump: Got errno 122 on write" Back

8 posts / 0 new
Last post
#1 Sun, 03/08/2015 - 05:14
paul.kelly

"dump failed! mysqldump: Got errno 122 on write" Back

I have started getting 'dump failed! mysqldump: Got errno 122 on write'!

Running V4.15, I assumed that this had been sorted!

The server has 2gb quota and uses 1.1gb

Sun, 03/08/2015 - 09:25
andreychek

Howdy,

That sounds like you're seeing some sort of out of space error... what is the output of this command:

df -h

Also, when is that occurring -- when creating a backup, or restoring one?

-Eric

Sun, 03/08/2015 - 10:11
paul.kelly

It happens when backing up all sites, but errors on one.

I am sure I have lots of space!!

Filesystem                                             Size  Used Avail Use%  Mounted on
/dev/mapper/VolGroup00-root              225G   13G  201G   6% /
tmpfs                                                    3.9G     0  3.9G   0%       /dev/shm
/dev/md0                                             485M  122M  338M  27% /boot
Sun, 03/08/2015 - 11:09
andreychek

Okay, let's check what the Linux filesystem thinks both the user and group quota are.

That can be done with these two commands:

quota -v USERNAME
quota -g GROUPNAME

What is the output of those two commands?

-Eric

Sun, 03/08/2015 - 16:07 (Reply to #4)
paul.kelly

quota: user USERNAME does not exist.

quota: group GROUPNAME does not exist.

Mon, 03/09/2015 - 09:39
andreychek

Sorry you'd need to type the actual username and group name for this particular user. So if their user was "example", and group was "example2", those commands would look like:

quota -v example

quota -g example2

Wed, 03/11/2015 - 03:14
paul.kelly

[root@beta ~]# quota -v xxx Disk quotas for user xxx uid 625): Filesystem blocks quota limit grace files quota limit grace /dev/mapper/VolGroup00-root 1048616 2097152 2097152 117054 0 0 [root@beta ~]# quota -g xxx Disk quotas for group xxx (gid 563): Filesystem blocks quota limit grace files quota limit grace /dev/mapper/VolGroup00-root 1437544 2097152 2097152 118256 0 0

Wed, 03/11/2015 - 11:13
andreychek

Howdy,

Okay, that group quota is a bit more full than the regular user quota... just as a troubleshooting step, could you try bumping up the user and group quota for that domain?

-Eric