Thread Info
  • State Not Answered
  • Replies 4 replies
  • Subscribers 0 subscribers
  • Views 470 views
  • Users 0 members are here
Options
Suggested

[7.450][DUPE][FIXED] mailsec related generates errors

Billybob
The cron job 40 6,18 * * *   root    /usr/local/bin/adbs-maintenance.plx generates the following errors:

2009:06:01-18:40:02 gatekeeper adbs-maintenance[11566]: Operating on database: 'reporting' (table name: 'websec_bud_archive' column name: 'dayabs' threshold_day: '733529')
2009:06:01-18:40:02 gatekeeper adbs-maintenance[11566]: finished ADBS maintenance on reporting / websec_bud_archive
2009:06:01-18:40:02 gatekeeper adbs-maintenance[11566]: cleaning anonymizing mappings
2009:06:01-18:40:02 gatekeeper postgres[11592]: [3-1] ERROR:  relation "_mailsec_anon" does not exist
2009:06:01-18:40:02 gatekeeper postgres[11592]: [3-2] STATEMENT:  delete from mailanon_addrs where _rowno not in (select distinct(id) as idf from (select distinct(srcuser) as id from
2009:06:01-18:40:02 gatekeeper postgres[11592]: [3-3]  _mailsec_anon union select distinct(dstuser) from _mailsec_anon) as a)
2009:06:01-18:40:02 gatekeeper adbs-maintenance[11566]: >=========================================================================
2009:06:01-18:40:02 gatekeeper adbs-maintenance[11566]: SQL call failed
2009:06:01-18:40:02 gatekeeper adbs-maintenance[11566]: 
2009:06:01-18:40:02 gatekeeper adbs-maintenance[11566]:  1. main::top-level:202() adbs-maintenance.pl
Parents Reply Children