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

Problem with statistics and a new domain without hosting

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by xLnT, Jul 23, 2009.

  1. xLnT

    xLnT Basic Pleskian

    23
    57%
    Joined:
    Aug 10, 2008
    Messages:
    35
    Likes Received:
    0
    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
     
  2. Yulia Kostina

    Yulia Kostina Guest

    0
     
    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?
     
  3. xLnT

    xLnT Basic Pleskian

    23
    57%
    Joined:
    Aug 10, 2008
    Messages:
    35
    Likes Received:
    0
    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
     
  4. Yulia Kostina

    Yulia Kostina Guest

    0
     
    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.
     
  5. xLnT

    xLnT Basic Pleskian

    23
    57%
    Joined:
    Aug 10, 2008
    Messages:
    35
    Likes Received:
    0


    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
     
  6. Yulia Kostina

    Yulia Kostina Guest

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

    MathiasD Guest

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