MySQLDatabaseProvider error 2006:MySQL

[JorgeLS]

Hello good morning,
I have a problem to perform backups from Plesk panel.
Always gives me the following error:

<message severity="error" id="a46266b4-8250-4b09-b822-4bf13a18dfd7"
code="InformationalException">
<description>Cannot dump domain hosting settings</description>
<message severity="error" code="PSADatabaseQueryException">
<description>Can't query SELECT * FROM `domains` WHERE `displayName`
= 'HERE_NAME_DOMAIN': MySQLDatabaseProvider error 2006:MySQL
server has gone away</description>
</message>


I tried to add the my.ini wait_timeout = 20000 as shown in this issue: http://forum.parallels.com/pda/index.php/t-94419.html, but did not solve my problem.

I have Windows Server 2008 and IIS 7.5 and MyEnable Professional.

Can anybody help?

many Thanks

 

[IgorG]

Perhaps this value should be increased more. Have you tried it?

 

[JorgeLS]

How much could increase this property?

Always stop the backup on the same domain. This domain has more than 900 mails with many gigabytes in MailEnable.

When I tried to backup only this domain and have excluded from the copy the emails, the backup successful, but with the emails always fails.

 

[JorgeLS]

hello,
This is the content of my.ini.
Can anybody help?

[MySQLD]
port=3306
basedir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\
datadir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data
character-set-server=latin1
default-storage-engine=INNODB
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=400
old_passwords=0
max_user_connections=30
thread_cache_size=4
thread_stack=196608
binlog_cache_size=32768
net_read_timeout=30
net_retry_count=10
net_write_timeout=30
thread_concurrency=10
open_files_limit=0
max_user_connections=300
max_allowed_packet=64M
wait_timeout=86400
[client]
port=3306

 

[IgorG]

http://kb.parallels.com/115598

 

[JorgeLS]

Continues to fail.
When I launch the backup, files are created in the backup folder but the task progress is always 0%.
Finally after many hours at 0% failure with MySQLDatabaseProvider error 2006:MySQL.

What I can do?

 

[JorgeLS]

I still have the same error.
If I do the backup without adding emails works fine.
But if I put the backup with emails (mailenable) the progress of task always is 0%, but in the Backup folder is exist many gb of this copy.

Anyone have any ideas?

Thanks

 

[JorgeLS]

Finally Work fine with this configuration:

[MySQLD]
port=3306
basedir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\
datadir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data
character-set-server=latin1
default-storage-engine=INNODB
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=400
old_passwords=0
max_user_connections=30
thread_cache_size=4
thread_stack=196608
binlog_cache_size=32768
net_read_timeout=30
net_retry_count=10
net_write_timeout=30
thread_concurrency=10
open_files_limit=0
max_user_connections=300
max_allowed_packet=64M
wait_timeout=2147483
[client]
port=3306


But took 27 hours to create a backup of 273 GB and said a warning:

<?xml version="1.0" encoding="utf-8"?>
<execution-result status="warnings">
<object name="NAME A DOMAIN" type="domain">
<message severity="error" id="a2b25b5e-80b4-47af-b8ab-046c0c7949ab" code="InformationalException">
<description>Could not find password for account id '0'. Return empty password</description>
</message>
</object>
<object name="OTHER NAME A DOMAIN" type="domain">
<message severity="error" id="4b775dfb-6299-4153-82b5-c4f022d1ac4d" code="InformationalException">
<description>Could not find password for account id '0'. Return empty password</description>
</message>
</object>
</execution-result>

Subscriptions of warning are without hosting.

no hosting, no password no??

How I can remove this error?

Thanks for your help ¡