[Dbmail] dbmail-replycache table / vacation loop

2009-06-25 Thread Jon Duggan
Hi Guys, We have what looks like looping mail between two auto responders (by way of vacation in sieve). I can see in our lmtpd logs lots of failed inserts in teh dbmail_replycache table, such as; Jun 25 20:07:41 mail4-db-2 dbmail/lmtpd[427]: Error:[sql] dbmysql.c,db_query(+290): [Duplicate

Re: [Dbmail] dbmail-replycache table / vacation loop

2009-06-25 Thread Paul J Stevens
Jon Duggan wrote: Jun 25 20:07:41 mail4-db-2 dbmail/lmtpd[427]: Error:[sql] dbmysql.c,db_query(+290): [Duplicate entry 'customer.c...@vodafone.co.uk-donotreply@somedomain.c' for key 1] [INSERT INTO dbmail_replycache (to_addr, from_addr, handle, lastseen) VALUES (' Jon, I would need to see

Re: [Dbmail] dbmail-replycache table / vacation loop

2009-06-25 Thread Jon Duggan
Thanks paul, I would need to see the full query, and the one just before this one. You'll need to run at trace_errlog=5 to get at them, or use your mysql logs if you have them. I'll get some better logs and post to the list. This might happen if the same message is being inserted twice,

Re: [Dbmail] dbmail-replycache table / vacation loop

2009-06-25 Thread Aaron Stone
On Thu, 25 Jun 2009 22:21:30 +0100, Jon Duggan j...@host-it.co.uk wrote: Thanks paul, I would need to see the full query, and the one just before this one. You'll need to run at trace_errlog=5 to get at them, or use your mysql logs if you have them. I'll get some better logs and post to