[Bucardo-general] cron

[Mathieu Arnold]

+--On 14 janvier 2011 20:15:40 -0500 Bill McGonigle <bill at bfccomputing.com>
wrote:
| On 01/14/2011 06:08 PM, Mathieu Arnold wrote:
|> Now, I don't get why I need to also put a DELETE statement to "which
|> cleans up q table entries that do not get taken care of by the
|> bucardo_purge_q_table function" which feels wrong, kinda.
|> 
| 
| Hi, Mathieu,
| 
| You want this thread, from Monday:
| 
| https://mail.endcrypt.com/pipermail/bucardo-general/2011-January/000901.h
| tml
| 
| If you don't have these sorts of entries, it's unnecessary.

Hum, ok, so I read that thread already, on Monday... So I can forget things
from Monday to Friday, that's interesting :-)

I don't seem to have that kind of entries, and, hum, the query you point in
that first email seems strange as :

bucardo=# select count(*) FROM q WHERE (started < now() - '5 minutes
ago'::interval OR ended < now() - '5 minutes ago'::interval OR aborted <
now() - '5 minutes ago'::interval OR cdate < now() - '5 minutes
ago'::interval) AND (ended IS NULL OR aborted IS NULL);
 count 
-------
   202
(1 ligne)

bucardo=# select count(*) from q;
 count 
-------
   202
(1 ligne)

(radius aaa database, and it's Saturday, so, no one's working, so, no
tickets going in)

-- 
Mathieu Arnold