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 (PLESK 8.6)

Discussion in 'Plesk for Linux - 8.x and Older' started by INVY, Jan 1, 2011.

  1. INVY

    INVY New Pleskian

    19
    60%
    Joined:
    Dec 8, 2009
    Messages:
    8
    Likes Received:
    0
    Resources Usage Statistics:

    Internal error: failed to adjust system time in accordance with daylight saving time chance. Please report your prot



    -------- Messaggio originale --------
    Oggetto: Cron /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats month
    Data: 1 Jan 2011 01:15:02 +0100

    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) / 7200, 0) having count(va' at line 3'

    0: /usr/local/psa/admin/plib/modules/watchdog/wdlib.php:1050
    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) / 7200, 0) having count(value) > 1 limit 10000;')
    1: /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats:68
    pack_statistics(integer '7200', boolean false, boolean false)
    2: /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats:49


    -------- Messaggio originale --------
    Oggetto: Cron /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats day
    Data: 1 Jan 2011 01:15:02 +0100

    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: /usr/local/psa/admin/plib/modules/watchdog/wdlib.php:1050
    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: /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats:68
    pack_statistics(integer '200', boolean false, boolean false)
    2: /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats:49


    -------- Messaggio originale --------
    Oggetto: Cron /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats month
    Data: 1 Jan 2011 01:15:02 +0100

    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) / 7200, 0) having count(va' at line 3'

    0: /usr/local/psa/admin/plib/modules/watchdog/wdlib.php:1050
    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) / 7200, 0) having count(value) > 1 limit 10000;')
    1: /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats:68
    pack_statistics(integer '7200', boolean false, boolean false)
    2: /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats:49
     

    Attached Files:

  2. mr_exclusive

    mr_exclusive Basic Pleskian

    24
    73%
    Joined:
    Jul 15, 2006
    Messages:
    56
    Likes Received:
    0
    i have the same errors today on plesk 8.3 and 8.6.
    8.2.1. is fine
     
  3. ChK

    ChK Guest

    0
     
    i have also the same errors with plesk 9.5.4.
     
  4. SilviaP

    SilviaP Guest

    0
     
    Same error today on Plesk 8.4.0
     
  5. GOL

    GOL Guest

    0
     
    Same here on 9.5.4
     
  6. netme

    netme Guest

    0
     
    Same error - 9.3.0
     
  7. SachaF

    SachaF Guest

    0
     
    Same errors on 9.2.3 (watchdog stats and cron-Mails).
    Seems to have trouble with date / new year. Hotfix?
    Server hung up at noon...
    Other server with 9.5.3 is ok.
     
    Last edited by a moderator: Jan 1, 2011
  8. JimDunn

    JimDunn Guest

    0
     
    Same error for me, v8.6, got error emails at 1:15am this morning.
     
  9. GOL

    GOL Guest

    0
     
    Think it is something to do with time / date - The subject of my daily Watchdog email read as follows:

    "Watchdog daily report Jan 1, 1970 (Thursday) on xxxx"

    ..but the time on the server according to hwclock is fine!
     
  10. Searchlight

    Searchlight Guest

    0
     
    Same issue here on Plesk 10.0.1.
     
  11. srt10coupe

    srt10coupe New Pleskian

    15
    55%
    Joined:
    Jan 1, 2011
    Messages:
    2
    Likes Received:
    0
    Same issue here on Plesk 10.0.1.
     
  12. Capa

    Capa Guest

    0
     
    Nice, the same error for me.
    And allways the time is 01.15
    And the first day was the 01.01.2011
     
  13. Barely Awake

    Barely Awake Guest

    0
     
    Same error...server still running normally.

    Let's move it, Jelsoft! :D
     
  14. sshl

    sshl Guest

    0
     
    Same issue here. I use Plesk 9.3.0.

    My e-mails from WatchDog looks like...

    Subject: Watchdog daily report Jan 1, 1970 (Thursday) on *******.com

    Body:

    Watchdog is running since Jan 2, 2011 01:00 AM.
    Watchdog is monitoring services:
    Plesk Web Server
    SMTP Server(Qmail)
    IMAP/POP3 Server (Courier-IMAP)
    Plesk SpamAssassin
    Dr.Web antivirus
    Watchdog is monitoring:
    ............................................................................

    Security scans number: 0.

    No events registered for the period.


    When i want to see statistics from watchdog, i get an error:

    Internal error: failed to adjust system time in accordance with daylight savings time change. Please report your

    And yes... server still running normally.

    Sorry for my bad english...
     
  15. CHRIS_FR95

    CHRIS_FR95 Guest

    0
     
    Same error, Plesk 9.5.3 & 9.5.4 : servers are OK
    MySQL Query 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) / 200, 0) having count(value) > 1 limit 10000

    The where parameter is wrong.
    Any fix ?
     
  16. hgmichna

    hgmichna Basic Pleskian

    24
    23%
    Joined:
    Oct 3, 2008
    Messages:
    69
    Likes Received:
    0
    Location:
    Munich, Germany
    Same error on Plesk 9.5.4

    I don't see the cause. Perhaps needs specific logging or debugging.

    There is nothing special about the timestamp either. The timestamp, or the timestamp divided by 200, has not just crossed any recognizable boundary. It is a bit mysterious why this error suddenly cropped up.
     
  17. Gelak

    Gelak Guest

    0
     
    The same problem here.
    It started at NYE, so it must be in connection with the 2010 -> 2011 year change.
    Any idea how to fix it?
     
  18. ma-sc

    ma-sc Guest

    0
     
    I enabled the mysql logging and found the complete query in it:

    There a syntax error in the query: "where group by service..." makes no sense.

    I dont know why this came up first since starting of 2011.
     
  19. Superman857

    Superman857 Guest

    0
     
    Same error for me too in 9.5.2 on two different servers. Not sure if it's related or unrelated, but I've also just started having other issues - takes several refreshes to get plesk panel to load (first few say unable to connect error), and I tried to update one server, update failed, and now I cannot connect at all to the control panel via browser.
     
  20. Martijn Beulens

    Martijn Beulens Guest

    0
     
    Same **** here

    Does anyone know how to fix this yet.
    psa 9.2.3
     
Loading...