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

ERROR: WDExc error PLESK 10.0.1

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by mrweb, Jan 10, 2011.

  1. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    Hi

    i found the fix posted by Parallels team about the error and placed it on the server
    it seems its not ok for PLESK 10

    i still get the error
    /usr/local/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:1089
    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


    someone can help me ?
    thanks !
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
  3. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    Hi Higor

    yes i did exactly this but it didnt fix the problem
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Strange. I have received a lot of notifications that this KB article has helped very many people. Maybe you have some other reason of this error. Try to contact support team for detailed investigation directly on your server.
     
  5. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    ok thanks a lot for your very fast answers

    i rent a server to a company so im not sure they will help a lot and im almost sure Parallels support will not investigate my server for free :(

    next time, i wait 6 months befor to update
    the 9.x version was good
     
  6. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Are you sure that patches have been correctly applied according to KB article?
     
  7. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    im sure

    i did exactly this, (by ssh with winscp)

    Unzip attached for your Parallels Plesk Panel version pack-sysstats and replace the file located in /usr/local/psa/libexec/modules/watchdog/cp/
    Unzip attached for your Parallels Plesk Panel version stats-graph and replace the file located in /usr/local/psa/admin/htdocs/modules/watchdog/

    pack-sysstats-for-9.5-10.zip and stats-graph-for-9.5-10.zip

    do i have to restart server after that ?
    i didnt

    can i check somewhere in the control panel if the version is updated ?
     
  8. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Yes. All looks like correct. Try to restart psa service at least.

     
  9. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    im not so familiar with ssh functions

    can i do that with control panel ?

    thanks
     
  10. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    No, you cant do it via panel. You can just reboot server if it is suitable for you :)
     
  11. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    ok thanks a lot for your help !

    i made on ssh
    # /etc/init.d/psa stopall
    # /etc/init.d/psa start

    i wait for tomorrow if all is ok :)
     
  12. Nicodemus

    Nicodemus Guest

    0
     
    Have the same issue, I've installed the fix, restarted the complete server, the error appears still but now twice , also a new error is reported in addition now after using Parallel's Fix :

    PHP Fatal error: Class 'OptionalServices_ServicesConfiguration' not found in /opt/psa/admin/plib/common_func.php3 on line 2948
     
  13. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    not fixed

    the fix is not ok, i get more errors :(

    i still have 3 errors :

    1.
    /usr/local/psa/libexec/modules/watchdog/cp/send-report weekly
    /bin/sh: /usr/local/psa/libexec/modules/watchdog/cp/send-report: /opt/psa/bin/sw-engine-pleskrun: bad interpreter: No such file or directory

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

    2.
    /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats week
    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) / 1800, 0) having count(va' at line 3'

    0: wdlib.php:1089
    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) / 1800, 0) having count(value) > 1 limit 10000;')
    1: pack-sysstats:63
    pack_statistics(integer '1800', boolean false, boolean false)
    2: pack-sysstats:44

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

    3.
    /usr/local/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:1089
    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
     
  14. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Last edited: Jan 17, 2011
  15. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    Thanks for the new fix :)
    i wait tomorrow morning to see if all is ok
     
  16. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    Hi Igor

    the fix is not ok, i still get error this morning

    very strange !
     
  17. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    What sort of errors you have after applying fix from KB?
     
  18. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
    the same error :

    /usr/local/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:1089
    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
     
  19. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Well. Could you please confirm that you have applied latest micro-updates or manual solutions from provided KB articles?
     
  20. mrweb

    mrweb Basic Pleskian

    17
    35%
    Joined:
    Nov 12, 2010
    Messages:
    38
    Likes Received:
    0
Loading...