Guest User!

You are not Sophos Staff.

[9.070][BUG] Sytem error messages on database maintenance

Hi I have these messages in my system logs when the database maintenance cron job is executed 
/usr/local/bin/adbs-maintenance.plx
....SNIP......

##################
2013-02-23 13:23:21.137 INFORMATIVE MESSAGE adbs-maintenance[18901]: main::clean_webcategories:116()
| cleaning web request categories
DBD:[:P]g::st execute failed: ERROR:  column "_rowno" does not exist
LINE 1: select min(_rowno), max(_rowno) from websec_reqcat
                   ^ at adbs-maintenance.pl line 248.

##################
...........SNIP.............

and in system logs
/var/log/system/2013/02/system-2013-02-21.log.gz:2013:02:21-18:40:05 gatekeeper postgres[13153]: [3-1] ERROR: column "_rowno" does not exist at character 12

/var/log/system/2013/02/system-2013-02-21.log.gz:2013:02:21-18:40:05 gatekeeper adbs-maintenance[13131]: execute failed: ERROR: column "_rowno" does not exist
/var/log/system/2013/02/system-2013-02-22.log.gz:2013:02:22-06:40:03 gatekeeper postgres[27765]: [3-1] ERROR: column "_rowno" does not exist at character 12
/var/log/system/2013/02/system-2013-02-22.log.gz:2013:02:22-06:40:03 gatekeeper adbs-maintenance[27743]: execute failed: ERROR: column "_rowno" does not exist
/var/log/system/2013/02/system-2013-02-22.log.gz:2013:02:22-18:40:05 gatekeeper postgres[9824]: [3-1] ERROR: column "_rowno" does not exist at character 12
/var/log/system/2013/02/system-2013-02-22.log.gz:2013:02:22-18:40:05 gatekeeper adbs-maintenance[9803]: execute failed: ERROR: column "_rowno" does not exist
/var/log/system.log:2013:02:23-06:40:04 gatekeeper postgres[24102]: [3-1] ERROR: column "_rowno" does not exist at character 12
/var/log/system.log:2013:02:23-06:40:04 gatekeeper adbs-maintenance[24081]: execute failed: ERROR: column "_rowno" does not exist

Regards
Bill
Share Feedback
×

Submitted a Tech Support Case lately from the Support Portal?