CRITICAL: Backup Fails -> Kills IIS & MYSQL

[davex2cms]

Hi,

Twice now plesk backup has failed and its taken down all the sites and MySQL service.

There are 590 sites on the server, it can easily handle this.

When it failed first time it was 443 sites into the backup and last time it was 466 into the backup.

Eventvwr shows 70 'admin' connections dropped -

d:\Program Files\SWsoft\Plesk\MySQL\bin\mysqld-nt.exe: Forcing close of thread 3  user: 'admin'

does plesk use a new database connection thread for each backup in websrvmng and if so do i need to change the mysql max_connections? The client wants over 1000 sites on this server...

Error on both occasions in plesk logs -

Exec 'd:\Program Files\SWsoft\Plesk\admin\bin\websrvmng' '--get-vhost-performance "--vhost-name=mydomain.com"'
Warning: System.Exception: Error in execute ''websrvmng' --get-vhost-performance "--vhost-name=mydomain.com"':

Can't query SELECT d.id, d.name, d.htype, d.status, d.displayName, d.cl_id, h.ssl FROM  { oj domains d LEFT OUTER JOIN hosting h ON h.dom_id = d.id } WHERE (d.name = 'mydomain.com'): MySQL error 2013:Can't connect to MySQL server on 'localhost' (10061)
   at psabackup.CommonEnv.execUtil(String utilName, String Arguments, String inputString, Hashtable envs)
   at psabackup.hosting.onPreDumpOperation(XMLRow row, DumpEnv env, DumpOperation operation)
Warning: System.Exception: The system cannot find the file specified. (Error code 2) at Connect to pipe
   at psaobsolete.psa.get_Item(String name)
   at psabackup.CommonEnv.execUtil(String utilName, String Arguments, String inputString, Hashtable envs)
   at psabackup.hosting.onPreDumpOperation(XMLRow row, DumpEnv env, DumpOperation operation)

Dave,

Dave

 

[Pavluha]

First please check version of Plesk mysql in
%plesk_dir%mysql\bin
and update it to 4.1.18
You can read How can I update MySQL at Plesk 7.5.x server? on page
http://faq.swsoft.com/article_147_1077_en.html

 

[davex2cms]

Thanks for reply.

Its currently running 4.1.12 ill update it when i get chance tommorow.

Do you think the MYSQL version will make a difference? It seems to be an issue with backing up too many sites.

We have other servers with 100-300 sites on the same setup and it works fine but this server with 600 it fails once every 10 days.