• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Watchdog cron failed

Bart_NL

Basic Pleskian
TITLE:
Watchdog cron failed
PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE:
OS: CentOS Linux 7.4.1708 (Core)‬
Plesk: 17.8.6
Watchdog: 2.0-11
PROBLEM DESCRIPTION:
After update from 17.8.5 to 17.8.6, Cron Deamon send's error after running the 'pack-sysstats day' cron. The 'pack-sysstats week' cron gives the same error.​
STEPS TO REPRODUCE:
Login to plesk
Go to: Tools & Settings
Go to: Scheduled Tasks
Click 'Run Now' for the '/usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats day' or '/usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats week' task​
ACTUAL RESULT:
Code:
PHP Warning:  mktime() expects at most 6 parameters, 7 given in /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats on line 23 PHP Warning:  mktime() expects at most 6 parameters, 7 given in /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats on line 24
[2017-10-17 01:15:01] ERR [panel] Error occurred while processing database query: 'DB query failed: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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, query was: 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;':
0: /usr/local/psa/admin/plib/modules/watchdog/wdlib.php:1042
    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:67
    pack_statistics(integer '200', boolean false, boolean false)
2: /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats:48
ERROR: WDExc: Error occurred while processing database query: 'DB query failed: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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, query was: 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;' (wdlib.php:1042)
EXPECTED RESULT:
Cron succesfull​
ANY ADDITIONAL INFORMATION:
Thanks!
YOUR EXPECTATIONS FROM PLESK SERVICE TEAM:
Confirm bug
 
Can't reproduce it in my Plesk Onyx Version 17.8.7
Seems fixed in the update 7.
Have you tried to fix it with

# plesk repair db

?
 
Code:
#plesk repair db

Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database ...................... [OK]

Error messages: 0; Warnings: 0; Errors resolved: 0

No fix, I dont see a changelog voor update 7, not available yet?
 
Note, that 17.8 is Preview version, not stable. Just wait for update 7 and update this report if problem not fixed.
 
Back
Top