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

NEW since update /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by 105547111, Jan 13, 2011.

  1. 105547111

    105547111 Silver Pleskian

    32
    30%
    Joined:
    Jul 13, 2006
    Messages:
    643
    Likes Received:
    2
    After yesterday's panel update another watchdog bug! I am assuming the update was to fix but ended up breaking it again. Will the last patch still work?

    Meantime this is the new cron email:

    /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats: line 1: ?php: No such file or directory
    /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats: line 2: syntax error near unexpected token `"The file {$_SERVER['SCRIPT_FILENAME']} is part of Plesk 9 distribution. It cannot be run outside of Plesk 9 environment.\n"'
    /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats: line 2: ` ***die("The file {$_SERVER['SCRIPT_FILENAME']} is part of Plesk 9 distribution. It cannot be run outside of Plesk 9 environment.\n");'
     
    Last edited: Jan 13, 2011
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
  3. igraf

    igraf Regular Pleskian

    25
    57%
    Joined:
    Jan 26, 2006
    Messages:
    103
    Likes Received:
    0
    @Igor
    Delivered a fix via micro update in the next days?
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    Could you please provide me more details if possible:

    - OS exact version,
    - Autoinstaller exact version (which was used for the upgrade).
     
  5. dash

    dash Regular Pleskian Staff Member

    28
    40%
    Joined:
    Sep 26, 2007
    Messages:
    204
    Likes Received:
    47
    Gentlemen,

    Could you post here output from the following commands (run it as user root from console):

    uname -a

    cat /usr/local/psa/version

    cat /root/.autoinstaller/microupdates.xml

    This info will help us to solve the issue.
     
  6. igraf

    igraf Regular Pleskian

    25
    57%
    Joined:
    Jan 26, 2006
    Messages:
    103
    Likes Received:
    0
    openSUSE 11.1
    Plesk 9.5.4
    latest plesk updater (can say tonight)
     
    Last edited: Jan 13, 2011
  7. GuillaumeH

    GuillaumeH Basic Pleskian

    20
    90%
    Joined:
    Mar 24, 2010
    Messages:
    40
    Likes Received:
    0
    I'm having the exact same error.


    Before the micro-update, the manual fix (http://kb.odin.com/en/9554) worked well.

    But since the micro-update (don't understand why it is different from the manual fix), this error happen all night.


    version: Plesk 9.5.4 (latest plesk update)
    CentOs 5.5
     
  8. igraf

    igraf Regular Pleskian

    25
    57%
    Joined:
    Jan 26, 2006
    Messages:
    103
    Likes Received:
    0
    @GuillaumeH
    yes, i can confirm that

    Manual update worked well ...
     
  9. fogelf

    fogelf Regular Pleskian

    23
    37%
    Joined:
    Feb 10, 2010
    Messages:
    103
    Likes Received:
    0
    during upgrade psa-watchdog was upgraded also?
     
  10. mr_coko

    mr_coko Guest

    0
     
    Solution

    Hi all,

    Parallels missed in some files of the Microupdate the shebang line, which holds the interpreter to run the script with.

    In the meantime they fixed the microupdates (at least for Plesk 9.5.3 and 9.5.4 on CentOS I tested it) and running the autoinstaller patches the patch.


    Run the autoinstaller from shell like (for plesk 9.5.3):

    /usr/local/psa/admin/bin/autoinstaller --select-product-id plesk --select-release-id PLESK_9_5_3 --upgrade-installed-components
     
    Last edited by a moderator: Jan 14, 2011
  11. mr_coko

    mr_coko Guest

    0
     
    Ha. Just got a reply from Parallels Support. They tell me:

    We have not yet received any issues with corruption in patch for watchdog issues.
    It seems that the patch got tampered during download or applying the patch.


    What do they think, that we are idiots?
     
  12. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,240
    Location:
    Novosibirsk, Russia
    No. It can be junior supporter.
     
  13. mr_coko

    mr_coko Guest

    0
     
    Igor, I wish I could believe this. The support ticket to this issue was opened 27 hours before I received this as the one and only answer. Following our support level and the severity, we SHOULD have had an aswer after 4 hours.

    I have seriously no idea what is going on at Parallels, but the support seems to go down the drain.

    From our last set of support request we never got a solution, only a vague "well known problem, will be solved in future version". All of them are not solved until now? No idea, because we don't get any real feedback.

    Sorry about my mood and I appreciate your fast response. I hope you can understand me.
     
  14. igraf

    igraf Regular Pleskian

    25
    57%
    Joined:
    Jan 26, 2006
    Messages:
    103
    Likes Received:
    0
    i see the next micro-update!
    hope, it works better ...
     
  15. ChK

    ChK Guest

    0
     
    i get the same error, since the previous update... and i have the same os/plesk versions.

    CPU AuthenticAMD, Quad-Core AMD Opteron(tm) Processor 2347 HE
    Version Parallels Plesk Panel v9.5.4_build95101209.05 os_SuSE 11.1
    OS Linux 2.6.18-028stab070.5

    but, what i cant understand is the release-column in the update-view, its ever 9.12.2010.. is that a new or the old version?
     
    Last edited by a moderator: Jan 14, 2011
  16. BernardOF

    BernardOF Guest

    0
     
    @Igor I've been having the same problem, my output from the commands is below:

    Linux 2.6.18-164.11.1.el5 #1 SMP Wed Jan 20 07:32:21 EST 2010 x86_64 x86_64 x86_64 GNU/Linux

    10.0.1 CentOS 5 109101029.18

    <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
    <patches>
    <product id="plesk" version="10.0.1">
    <patch version="3" timestamp="" />
    </product>
    </patches>
     
  17. 105547111

    105547111 Silver Pleskian

    32
    30%
    Joined:
    Jul 13, 2006
    Messages:
    643
    Likes Received:
    2
    I just installed the latest (2nd) hotfix, lets see what tomorrows cron run says....
     
  18. EnricoS

    EnricoS Guest

    0
     
    still errors!!!

    after running:
    /usr/local/psa/admin/bin/autoinstaller --select-product-id plesk --select-release-id PLESK_9_5_4 --upgrade-installed-components
    at 01:30 AM / 15. jan 2010 (Plesk 9.5.4, Debian 5) following error came back:

    /opt/psa/libexec/modules/watchdog/cp/pack-sysstats day
    ERROR: WDExc
    Error occurred while processing database query: 'MySQL query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by service_id, type, round(unix_timestamp(time) / 200, 0) having count(val' at line 3'

    0: wdlib.php:1088
    wd__db_query(string 'select service_id, type, unix_timestamp(min(time)) as min_time, unix_timestamp(max(time)) as max_time, avg(value) as avg
    from module_watchdog_sys_stat where
    group by service_id, type, round(unix_timestamp(time) / 200, 0) having count(value) > 1 limit 10000;')
    1: pack-sysstats:63
    pack_statistics(integer '200', boolean false, boolean false)
    2: pack-sysstats:44


    :( :( :(

    Linux ******* 2.6.26-2-686 #1 SMP Thu Nov 25 01:53:57 UTC 2010 i686 GNU/Linux
    9.5.4 Debian 5.0 95101209.08
    <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
    <patches>
    <product id="plesk" version="9.5.4">
    <patch version="2" timestamp="" />
    </product>
    </patches>
     
    Last edited by a moderator: Jan 14, 2011
  19. GuillaumeH

    GuillaumeH Basic Pleskian

    20
    90%
    Joined:
    Mar 24, 2010
    Messages:
    40
    Likes Received:
    0
    same here!! It's getting annoying....
     
  20. 105547111

    105547111 Silver Pleskian

    32
    30%
    Joined:
    Jul 13, 2006
    Messages:
    643
    Likes Received:
    2
    Yes agree!

    Second update to fix this and now this new error:

    ERROR: WDExc
    Error occurred while processing database query: 'MySQL query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by service_id, type, round(unix_timestamp(time) / 200, 0) having count(val' at line 3'

    0: wdlib.php:1088
    wd__db_query(string 'select service_id, type, unix_timestamp(min(time)) as min_time, unix_timestamp(max(time)) as max_time, avg(value) as avg
    from module_watchdog_sys_stat where
    group by service_id, type, round(unix_timestamp(time) / 200, 0) having count(value) > 1 limit 10000;')
    1: pack-sysstats:63
    pack_statistics(integer '200', boolean false, boolean false)
    2: pack-sysstats:44
     
Loading...