• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

error in watchdog / cron modules since 1st january

G

GuillaumeH

Basic Pleskian
Hi,

since the 1st january I get the following errors for some cron jobs:

Cron <root@server2> /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: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
Click to expand...


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

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) / 64800, 0) having count(v' 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) / 64800, 0) having count(value) > 1 limit 10000;')
1: pack-sysstats:63
pack_statistics(integer '64800', boolean false, boolean false)
2: pack-sysstats:44
Click to expand...

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

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: 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) / 7200, 0) having count(value) > 1 limit 10000;')
1: pack-sysstats:63
pack_statistics(integer '7200', boolean false, boolean false)
2: pack-sysstats:44
Click to expand...
 
same Problem on Debian 5.0.7, Plesk 9.5.3 :

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) / 64800, 0) having count(v' 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) / 64800, 0) having count(value) > 1 limit 10000;')
1: pack-sysstats:63
pack_statistics(integer '64800', boolean false, boolean false)
2: pack-sysstats:44
Click to expand...

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

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
Click to expand...
 
We solved the problem with these queries:

ALTER TABLE module_watchdog_report MODIFY time timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;

ALTER TABLE module_watchdog_sys_stat MODIFY time timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;
 
Hi Marco,

could you please elaborate on where to execute those queries?

Christian
 
Dear Marco,

I first made a backup of those 2 tables and successfully applied the queries (it said that a many rows were changed).

Unfortunately this didn't fix anything for me. When I manually execute "/opt/psa/libexec/modules/watchdog/cp/pack-sysstats year", I still get the error from post 1.

When I examined my backup tables, I found that the "time" field already had all the attributes that were set by the queries. I'm on Plesk 9.5.1 btw...

Christian
 
Last edited by a moderator:
Same problem here....

Plesk 10.0.1 CentOS 5.4.

Any news from Parallels about this issue?

PFM
 
Marco Cristofanilli said:
We solved the problem with these queries:

ALTER TABLE module_watchdog_report MODIFY time timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;

ALTER TABLE module_watchdog_sys_stat MODIFY time timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;
Click to expand...

does not work for Plesk 9.5.3 - tables already have these structures...
 
Response from SWSoft (via Reseller)

We contacted our hosting reseller (Peer1) to escalate the issue with SWSoft. Here is the response we received:

According to Parallels this is a known issue and they are planning on fixing the issue during the next Plesk update. Unfortunately they did not provide a time frame for the next update.

They did provide the following workaround:

---
As a workaround you can just comment out corresponding lines in cron jobs configuration, so no error notifications will be sent to you.

You should comment all pack-sysstats* lines, and in the end get this:

cat /var/spool/cron/root
1,16,31,46 * * * * /usr/local/psa/admin/sbin/backupmng >/dev/null 2>&1
0 1 * * 1 /usr/local/psa/libexec/modules/watchdog/cp/secur-check
0 1 * * 1 /usr/local/psa/libexec/modules/watchdog/cp/send-report weekly
10 1 * * * /usr/local/psa/libexec/modules/watchdog/cp/clean-sysstats
#15 1 * * * /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats day
#15 1 * * 1 /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats week
#15 1 1 * * /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats month
#15 1 1 * * /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats year
20 1 * * * /usr/local/psa/libexec/modules/watchdog/cp/clean-events
0 3 * * 7 /usr/local/psa/libexec/modules/watchdog/cp/clean-reports
 
You must log in or register to reply here.

Similar threads

Bart_NL
Watchdog cron failed
Replies
4
Views
1K
Bart_NL
Bart_NL
V
pack-sysstats failing after new year
Replies
1
Views
3K
MichielK
M
M
ERROR: WDExc error PLESK 10.0.1
2
Replies
28
Views
5K
IgorG
IgorG
M
ERROR: WDExc error PLESK 10.0.1
Replies
0
Views
1K
mrweb
M
I
ERROR: WDExc (PLESK 8.6)
3 4 5
Replies
88
Views
34K
Wardrox
W
Back
Top