1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

CRITICAL: Backup Fails -> Kills IIS & MYSQL

Discussion in 'Plesk for Windows - 8.x and Older' started by davex2cms, May 29, 2006.

  1. davex2cms

    davex2cms Guest

    0
     
    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 -

    Code:
    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 -

    Code:
    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
     
  2. Pavluha

    Pavluha Guest

    0
     
  3. davex2cms

    davex2cms Guest

    0
     
    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.
     
Loading...