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
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
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,
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