Disk space not calculated "MySQL server has gone away:statistics::calculateDiskSpace"

[Jaswinder Gill]

Hi

Plesk 9.5.2 on windows is not calculating "Disk Space" and throwing below mentioned error, PSA db is on MYSQL and i can see 2 MYSQL on server, PSA is on MYSQL ver 4.1.22 and user db is on MYSQL ver is 5.X

what could be reason for the same.


Event Type: Error
Event Source: statistics.exe
Event Category: None
Event ID: 1
Date: 6/10/2010
Time: 6:40:40 AM
User: N/A
Computer: server
Description:
Can't query select name from data_bases where type='mssql' and dom_id=89: MySQLDatabaseProvider error 2006:MySQL server has gone away
at (MySQLDatabaseProvider::query line 284)
at Count MSSQL databases sizes(statistics::calculateDiskSpace line 3261)
Execute file name: C:\Program Files\Parallels\Plesk\admin\bin\statistics.exe


Note: Weird , word "MSSQL" mentioned in above error, there is no MS-SQL installed on server.



Thanks for help in advance

 

[IgorG]

Try to increase the wait_timeout up to 20000 at the MySQL configuration file (my.ini) to avoid the problem.

 

[Jaswinder Gill]

I have done that , can you tell how to test the same .

If i run statistics on command line at said location but get error

Thanks for help in advance

 

[Jaswinder Gill]

Hi

Still facing issue, has anyone found solution for the issue and is this going to cause serious issue?.

1. Mail is not enabled on server. Disabled mailenable

2. awstats is not used in domains only webalyzier is used.

3. sending email from IIS SMTP is having issue Port is set on 25, We have set permission as per Plesk KB but customer are still complaining sending errror.



---------------------------------------------------------------------------------------------------------------------------------------------------------
Event Type: Error
Event Source: statistics.exe
Event Category: None
Event ID: 1
Date: 6/16/2010
Time: 12:35:32 PM
User: N/A
Computer: Server Name
Description:
Can't query SELECT val FROM misc WHERE (param = 'not_count_mail_disk_usage'): MySQLDatabaseProvider error 2006:MySQL server has gone away
at (MySQLDatabaseProvider::query line 284)
at calculateDiskSpace domainName=domainname.com, domainId=92(statistics::calculateDiskSpace line 3298)
at Calculate domain domain.com disk space(statistics::start line 1263)
Execute file name: C:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

---------------------------------------------------------------------------------------------------------------------------------------------------------

Event Type: Error
Event Source: statistics.exe
Event Category: None
Event ID: 1
Date: 6/16/2010
Time: 12:35:32 PM
User: N/A
Computer: Server Name
Description:
Can't query SELECT domains.name FROM (domains LEFT JOIN hosting ON (domains.id = hosting.dom_id AND hosting.webstat = 'awstats')): MySQLDatabaseProvider error 2006:MySQL server has gone away
at (MySQLDatabaseProvider::query line 284)
at Remove unused awstats configs(statistics::cleanAWstats line 1026)
Execute file name: c:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

---------------------------------------------------------------------------------------------------------------------------------------------------------


Event Type: Error
Event Source: statistics.exe
Event Category: None
Event ID: 1
Date: 6/16/2010
Time: 12:35:32 PM
User: N/A
Computer: Server Name
Description:
Can't query select name from data_bases where type='mysql' and dom_id=92: MySQLDatabaseProvider error 2006:MySQL server has gone away
at (MySQLDatabaseProvider::query line 284)
at Count MySQL databases sizes(statistics::calculateDiskSpace line 3227)
Execute file name: c:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

 

[Jaswinder Gill]

Hi
Is this error related to Plesk 9.5.2 version only ?

 

[Jaswinder Gill]

Hi

Issue resolved by increasing wait_timeout up to 10hrs , We had to increase to 10 hrs from 20000 as there was another KB where it was mentioned you need to increase to get email notification which were not going through to domain owners after increasing that worked .

But now new issue we want to change from email ID , for notification email sent this to [email protected] and not [email protected]

Any one having solution.