Backup "Failed to execute backup of mysql database" 11.09#57 CentOS 6.4

[Sellighsphire]

Hi!

we got some error:

<object name="domainname" type="client">
	<object name="domainname.de" type="domain">
		<object name="domainname" type="mysql">
			<message id="9dfd7c3a-744f-47e3-8a40-b2e362c7faf7" severity="error" code="msgtext">
				<description>Failed to execute backup of mysql database 'domainname'</description>
			</message>
			<message id="9254f30e-f6dc-4a0d-8adf-dd9c4d7b5bbe" severity="error" code="msgtext">
				<description>Failed to pack files ns30__domainname_1_1308210337 in /var/lib/psa/dumps/clients/domainname/domains/domainname.de/databases/domainname_1 [ 37199259648 bytes free of 51267520512 bytes total on mount point 0]</description>
			</message>
		</object>
	</object>
</object>

we tried many different things to solve the problem. We also commented out the lines in which plesk determines the size
of the disk. This helps to avoid this message, though the packed size of the included database is almost 0 bytes.

So what is the problem? The size of the disk can't be the problem.
BTW. There are almost 30 domains located on the server with almost 10 databases. Only 3 databases failed to pack.
Theses databases have the following size: 12MB, 1.6MB and 1.2MB
Another database is packed sucessfully. This database has a size of 2.7MB

Maybe it is a problem that we migrates some of theses domains/databases, though one was created by hand.

So, any advice is helpful.

Thanks
Jens

P.S. Some additional information

Filesystem            Size  Used Avail Use% Mounted on
/dev/vzfs              96G   19G   78G  20% /
none                  2.0G  4.0K  2.0G   1% /dev

 

[IgorG]

http://kb.parallels.com/116619

 

[Sellighsphire]

Thanks a lot for your short help, but this article doesn't help.
I don't have a permission problem. Maybe I have, but I don't know where (which path).
The errormessage doesn't provide any information about that. The message in your KB does.

Are there any other hints?

Jens

 

[horst rupp]

something's wrong with the latest #MUs:

http://forum.parallels.com/showthread.php?290283-Problems-with-Parallels-Plesk-Panel-9-5-4-MU-30
http://forum.parallels.com/showthre...t_failure_redirect_url()-after-applying-MU-30
http://forum.parallels.com/showthre...up-of-mysql-database-quot-11-09-57-CentOS-6-4
http://forum.parallels.com/showthread.php?290341-Cannot-add-new-domain-after-upgrade-to-10-4-4-55

looks like they hurried out a patch because of some big security issue. plesk 9 is at end of life, there shouldn't be any patch anyway unless it's something big.

 

[Sellighsphire]

Hello!

been away for some days
Found the problem in psadump.log:
mysqldump: Got error: 145: Table './domain1/con_phplib_active_sessions' is marked as crashed and should be repaired when using LOCK TABLES
mysqldump: Got error: 145: Table './domain2/con_phplib_active_sessions' is marked as crashed and should be repaired when using LOCK TABLES
mysqldump: Got error: 144: Table './domain3/con_stat' is marked as crashed and last (automatic?) repair failed when using LOCK TABLES

After some "REPAIR TABLE `XXXXXXXXX`" everything was fine

Thanks for any help.

Jens