A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=508 ====================================================================== Reported By: Anne Assigned To: aaron ====================================================================== Project: DBMail Issue ID: 508 Category: Sieve (delivery, dbmail-sievecmd, dbmail-timsieved) Reproducibility: always Severity: minor Priority: normal Status: feedback target: ====================================================================== Date Submitted: 16-Feb-07 16:48 CET Last Modified: 31-Aug-07 08:51 CEST ====================================================================== Summary: vacation sieve script always sends reply instead of just once Description: Starting version 2.2.2 the vacation sieve script always sends a reply even when the recipient has already been cached in dbmail_replycache. ======================================================================
---------------------------------------------------------------------- Tarick - 19-Mar-07 15:44 ---------------------------------------------------------------------- I confirm, 2.2.4 still has this problem. From dbmail.err: Debug:[sql] dbpgsql.c,db_query(+281): [SELECT lastseen FROM dbmail_replycache WHERE to_addr = '[EMAIL PROTECTED]' AND f rom_addr = '[EMAIL PROTECTED]' AND handle = '4257e0eca3659acfbf3cf8f3c964289c' AND lastseen > (NOW() - INTERVAL '1 DAY')] Debug:[delivery] pipe.c,parse_and_escape(+54): parsing address [EMAIL PROTECTED] Debug:[delivery] pipe.c,parse_and_escape(+54): parsing address [EMAIL PROTECTED] Info:[delivery] pipe.c,send_mail(+144): opening pipe to [/usr/sbin/sendmail -f [EMAIL PROTECTED] [EMAIL PROTECTED] Debug:[delivery] pipe.c,send_mail(+152): pipe opened Debug:[delivery] pipe.c,send_mail(+173): pipe closed Info:[delivery] pipe.c,send_mail(+178): sendmail exited normally Debug:[sql] dbpgsql.c,db_query(+281): [SELECT lastseen FROM dbmail_replycache WHERE to_addr = '[EMAIL PROTECTED]' AND f rom_addr = '[EMAIL PROTECTED]' AND handle = '4257e0eca3659acfbf3cf8f3c964289c' ] Debug:[sql] dbpgsql.c,db_query(+281): [INSERT INTO dbmail_replycache (to_addr, from_addr, handle, lastseen) VALUES ('[EMAIL PROTECTED]','[EMAIL PROTECTED]','4257e0eca3659acfbf3cf8f3c964289c', CURRENT_TIMESTAMP)] Info:[sort] sortsieve.c,sort_vacation(+145): Sending vacation to [EMAIL PROTECTED] from [EMAIL PROTECTED] handle [425 7e0eca3659acfbf3cf8f3c964289c] repeat days [1] ---------------------------------------------------------------------- Tarick - 19-Mar-07 17:30 ---------------------------------------------------------------------- I switched to 2.2.1, succesfully sent bunch of messages and had one autoreply. But when I changed subject of message, handle changed also and I've got another autoreply. I don't think this is intentional behaviour. ---------------------------------------------------------------------- aaron - 21-Mar-07 09:07 ---------------------------------------------------------------------- So 2.2.2 has a bug in autoreplies that 2.2.1 did not have? This will narrow down the set of changes that I have to look back at. ---------------------------------------------------------------------- aaron - 26-Apr-07 01:30 ---------------------------------------------------------------------- Fixed in SVN. The bug was that a call to db_result_free() was added above db_num_rows() in db_replycache_validate(), so we always thought we'd seen 0 rows of recent replies/vacations. ---------------------------------------------------------------------- Anne - 15-Aug-07 09:54 ---------------------------------------------------------------------- Still (or again) the same problem with 2.2.6rc1 Note: in dbmail_replycache, a new record is added each time with a different value for "handle" ---------------------------------------------------------------------- paul - 26-Aug-07 15:51 ---------------------------------------------------------------------- Anne, I can't reproduce this. Please provide more details if you don't mind. ---------------------------------------------------------------------- Anne - 30-Aug-07 16:35 ---------------------------------------------------------------------- Meanwhile I discovered that an auto reply is only sent multiple times if the subject is different than before. IMHO that's a bug not a feature ;-) ---------------------------------------------------------------------- paul - 31-Aug-07 08:51 ---------------------------------------------------------------------- What subject? The subject in the reply message? Or the subject in the received message? In the first case: it's a feature In the latter case: it is a bug: but this condition is what I've checked for specifically (works for me). Issue History Date Modified Username Field Change ====================================================================== 16-Feb-07 16:48 Anne New Issue 19-Mar-07 15:44 Tarick Note Added: 0001925 19-Mar-07 17:30 Tarick Note Added: 0001926 21-Mar-07 09:07 aaron Note Added: 0001932 26-Apr-07 01:28 aaron Status new => assigned 26-Apr-07 01:28 aaron Assigned To => aaron 26-Apr-07 01:30 aaron Status assigned => resolved 26-Apr-07 01:30 aaron Fixed in Version => 2.2.5 26-Apr-07 01:30 aaron Resolution open => fixed 26-Apr-07 01:30 aaron Note Added: 0002098 15-Aug-07 09:53 Anne Status resolved => feedback 15-Aug-07 09:53 Anne Resolution fixed => reopened 15-Aug-07 09:53 Anne Note Added: 0002326 15-Aug-07 09:54 Anne Note Edited: 0002326 26-Aug-07 15:51 paul Note Added: 0002332 26-Aug-07 15:51 paul Resolution reopened => unable to reproduce 30-Aug-07 16:33 Anne Note Added: 0002340 30-Aug-07 16:35 Anne Note Edited: 0002340 31-Aug-07 08:51 paul Note Added: 0002341 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev