PLESK Error - help please

[dany81]

Hello,

From same days i've problems with my plesk, on log viewer i've on plesk section many errors like this:

Can't query select name from data_bases where type='mssql' and dom_id=15: MySQLDatabaseProvider error 2006:MySQL server has gone away
at (MySQLDatabaseProvider::query line 284)
at Count MSSQL databases sizes(statistics::calculateDiskSpace line 3188)
Execute file name: E:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

Can't query select name from data_bases where type='mysql' and dom_id=15: MySQLDatabaseProvider error 2006:MySQL server has gone away
at (MySQLDatabaseProvider::query line 284)
at Count MySQL databases sizes(statistics::calculateDiskSpace line 3154)
Execute file name: E:\Program Files\Parallels\Plesk\admin\bin\statistics.exe


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=domain.net, domainId=10(statistics::calculateDiskSpace line 3225)
at Calculate domain dnlogin.net disk space(statistics::start line 1184)
Execute file name: E:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

Can't query SELECT val FROM misc WHERE (param = 'traffic_accounting'): MySQLDatabaseProvider error 2006:MySQL server has gone away
at (MySQLDatabaseProvider::query line 284)
at LaunchActionEvents(statistics::start line 1234)
Execute file name: E:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

etc.. etc..

Anybody can help me please?

Thanks in advance,
Dany

 

[Nataliya Zagr]

Hello Dany,

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

Thank you

 

[dany81]

Hello,
Thanks for the fast reply.

Here my my.ini:

[MySQLD]
port=3306
basedir=E:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL
datadir=E:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL\\Data
default-character-set=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=500
old_passwords=1
max_user_connections=1000
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

ActivityTimeout=180[/B]
[client]
port=3306[/QUOTE]

The only thing modified is...

[QUOTE][B][php]
ActivityTimeout=180[/B]
[client][/QUOTE]

... that i've wrote some time ago for the issue about fastcgi problem but i not sure if is correct for resolve it.

Where i must to change the timeout exactly for this issue?

Regards,
Daniele.

 

[dany81]

Hello,

On the Event Viewer i've also report this errors:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 5123
Date: 09.10.2009
Time: 15:59:57
User: N/A
Computer: /
Description:
CREATE FILE encountered operating system error 5(error not found) while attempting to open or create the physical file 'E:\Program Files\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\tempdb.mdf'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 03 14 00 00 10 00 00 00 ........
0008: 07 00 00 00 57 00 49 00 ....W.I.
0010: 4e 00 42 00 4f 00 58 00 N.B.O.X.
0018: 00 00 00 00 00 00 ......

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17207
Date: 09.10.2009
Time: 15:59:57
User: N/A
Computer: WINBOX
Description:
FCB::Open: Operating system error 5(error not found) occurred while creating or opening file 'E:\Program Files\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 37 43 00 00 10 00 00 00 7C......
0008: 07 00 00 00 57 00 49 00 ....W.I.
0010: 4e 00 42 00 4f 00 58 00 .....
0018: 00 00 06 00 00 00 6d 00 ......m.
0020: 6f 00 64 00 65 00 6c 00 o.d.e.l.
0028: 00 00 ..

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17204
Date: 09.10.2009
Time: 15:59:57
User: N/A
Computer: WINBOX
Description:
FCB::Open failed: Could not open file E:\Program Files\Parallels\Plesk\Databases\MSSQL\MSSQL.1\MSSQL\DATA\tempdb.mdf for file number 1. OS error: 5(error not found).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 34 43 00 00 10 00 00 00 4C......
0008: 07 00 00 00 57 00 49 00 ....W.I.
0010: 4e 00 42 00 4f 00 58 00 .........
0018: 00 00 06 00 00 00 6d 00 ......m.
0020: 6f 00 64 00 65 00 6c 00 o.d.e.l.
0028: 00 00 ..

Not always but only sometimes...

Please help :-\

Regards,
Daniele