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

Virtualmin
1

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

2

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

3

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
4

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

5

quota: user USERNAME does not exist.

quota: group GROUPNAME does not exist.

6

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

7

[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

8

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