Problem with statistics and a new domain without hosting

[xLnT]

Hi.
I don't know if this is a bug or not but here it goes.

When someone adds a domain and choose no hosting at the moment, then the statistics script fails.
Complaining that there is no files to process in /var/www/domain.tld/statistics/logs/

Is this known?
If so, how should i do to prevent this behavior?

Kind Regards
/M

 

[Yulia Kostina]

Hi

I could not reproduce this error on testing station. I have added domain without hosting, then executed statistics script:
/usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/DailyMaintainance/script.php

I got no errors. Which one you have? Could you copy and paste here?

 

[xLnT]

Problem

Hi Yulia.
Thanks for taking the time to help me with my problems.

I run www/dns/mail on one server (where PPCP is installed) and mySQL on another server (both servers have same OS, and mySQL version)

This is what i get when running the statistics script.

# /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/DailyMaintainance/script.php
[new_unode] Warning: String exceeds storage size (287)
[new_unode] Warning: String exceeds storage size (286)
[new_unode] Warning: String exceeds storage size (285)
[new_unode] Warning: String exceeds storage size (284)
[new_unode] Warning: String exceeds storage size (283)
[new_unode] Warning: String exceeds storage size (282)
[new_unode] Warning: String exceeds storage size (281)
[new_unode] Warning: String exceeds storage size (280)
[new_unode] Warning: String exceeds storage size (279)
[new_unode] Warning: String exceeds storage size (278)
[new_unode] Warning: String exceeds storage size (277)
[new_unode] Warning: String exceeds storage size (276)
[new_unode] Warning: String exceeds storage size (275)
[new_unode] Warning: String exceeds storage size (274)
[new_unode] Warning: String exceeds storage size (273)
[new_unode] Warning: String exceeds storage size (272)
[new_unode] Warning: String exceeds storage size (271)
[new_unode] Warning: String exceeds storage size (270)
[new_unode] Warning: String exceeds storage size (269)
[new_unode] Warning: String exceeds storage size (268)
[new_unode] Warning: String exceeds storage size (267)
[new_unode] Warning: String exceeds storage size (266)
[new_unode] Warning: String exceeds storage size (265)
[new_unode] Warning: String exceeds storage size (264)
[new_unode] Warning: String exceeds storage size (263)
[new_unode] Warning: String exceeds storage size (262)
[new_unode] Warning: String exceeds storage size (261)
[new_unode] Warning: String exceeds storage size (260)
[new_unode] Warning: String exceeds storage size (259)
[new_unode] Warning: String exceeds storage size (258)
[new_unode] Warning: String exceeds storage size (257)
[new_unode] Warning: String exceeds storage size (256)
error: error accessing /var/www/vhosts/domain.tld/statistics/logs: No such file or directory
error: jerkin.eu:1 glob failed for /var/www/vhosts/domain.tld/statistics/logs/*.processed
error: error accessing /var/www/vhosts/domain2.tld/statistics/logs: No such file or directory
error: playstar.se:1 glob failed for /var/www/vhosts/domain2.tld/statistics/logs/*.processed
[Mon, 27 Jul 2009 17:41:23 +0200] ! 2006 Error: MySQL query failed: MySQL server has gone away
[Mon, 27 Jul 2009 17:41:23 +0200] ! 2006 Error: MySQL query failed: MySQL server has gone away
[Mon, 27 Jul 2009 17:41:23 +0200] ! 2006 Error: MySQL query failed: MySQL server has gone away
PHP Fatal error: Exception thrown without a stack frame in Unknown on line 0

domain.tld and domain2.tld does not have any hosting setup.

Kind Regards
/M

 

[Yulia Kostina]

Hello

It looks like MySQL configuration causes issues. Please review /etc/my.cnf file, if there is value wait_timeout - increase it and restart the service. Check the issue after. The problem is that script connects to MySQL, if there are too restrictive timout values - the script fails with the error like yours.

 

[xLnT]

Hello

It looks like MySQL configuration causes issues. Please review /etc/my.cnf file, if there is value wait_timeout - increase it and restart the service. Check the issue after. The problem is that script connects to MySQL, if there are too restrictive timout values - the script fails with the error like yours.

Hi.
What values do you recommend?
I have tried setting wait_timeout from 90 to 300. Same results.

I noticed this thread aswell: http://forum.parallels.com/showthread.php?t=91647&highlight=wait_timeout

Any ideas?

Kind Regards
/M

 

[Yulia Kostina]

Hello

We do not recommend exact settings as all this closely related to server load, try to increase it more, do not forget to restart Mysql service after.

 

[MathiasD]

I had the following errors.

error: error accessing /var/www/vhosts/domain.tld/statistics/logs: No such file or directory
error: domain.tld:1 glob failed for /var/www/vhosts/domain.tld/statistics/logs/*.processed

error: error accessing /usr/share/tomcat5/logs: No such file or directory
error: tomcat:2 glob failed for /usr/share/tomcat5/logs/*.log

Solved it by removing domain.tld and tomcat from /usr/local/psa/etc/logrotate.d

I created the domain and later i removed it, but Plesk did not clean up properly. I've installed 9.5.2 a few days ago so maybe the removal problem is solved in this version.