Am 29.04.2015 um 17:36 schrieb Mark Maurer:
apologies, I forgot to add this originally. In addendum to below:
while this occurs, I’m seeing this in the logs from dbmail:
Apr 29 15:26:31 mail dbmail/imap4d[4621]: Error:[db] db_exec(+388):
SQLException: Lock wait timeout exceeded; try restarting transaction
Apr 29 15:26:31 mail last message repeated 2 times
Apr 29 15:26:31 mail dbmail/imap4d[4621]: Error:[db] db_exec(+389): failed
query [UPDATE dbmail_messages SET status=2 WHERE message_idnr=24497739 ]
Apr 29 15:26:31 mail dbmail/imap4d[4621]: Error:[db] db_exec(+389): failed
query [UPDATE dbmail_messages SET status=2 WHERE message_idnr=24497733 ]
Apr 29 15:26:31 mail dbmail/imap4d[4621]: Error:[db] db_exec(+389): failed
query [UPDATE dbmail_messages SET status=2 WHERE message_idnr=24497745 ]
Apr 29 15:26:32 mail dbmail/imap4d[4621]: Error:[db] db_exec(+388):
SQLException: Lock wait timeout exceeded; try restarting transaction
Apr 29 15:26:32 mail last message repeated 2 times
Apr 29 15:26:32 mail dbmail/imap4d[4621]: Error:[db] db_exec(+389): failed
query [UPDATE dbmail_messages SET status=2 WHERE message_idnr=24497735 ]
Apr 29 15:26:32 mail dbmail/imap4d[4621]: Error:[db] db_exec(+389): failed
query [UPDATE dbmail_messages SET status=2 WHERE message_idnr=24497747 ]
Apr 29 15:26:32 mail dbmail/imap4d[4621]: Error:[db] db_exec(+389): failed
query [UPDATE dbmail_messages SET status=2 WHERE message_idnr=24497741 ]
Hi
Did you try running one/some of those queries manually?
If so what was the result?
Regards
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail