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

pack-sysstats failing after new year

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

  1. Vincent.H

    Vincent.H Guest

    0
     
    Happy new year to everyone,


    My Panel has started 2011 with a bug... on pack-syststats.

    Received theses alerts via mail :

    Cron <root@**> /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats month

    And the same thing for year, day, week...

    It seems that the mysql query is incorrect (syntax error) :

    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) / 7200, 0) having count(value) > 1 limit 10000


    "where " is unnecessary here...

    Is any update expected ?


    Regards,
    Vincent
     
  2. MichielK

    MichielK Guest

    0
     
Loading...