1 Topic by rein

  • rein
  • Member
  • Offline
  • Registered: 2010-04-28
  • Posts: 36

Topic: [SOLVED] Lock wait timeout exceeded; try restarting transaction

My server all of a sudden has started to crawl , even with 1200 emails in the que, it takes hours before mails are delivered.
It seems the problem is the Amavisd database.

when i try to even delete one message: i get this error, trying to restart mysql , it aint gonna restart but just hangs there, rebooting also doesnt help.

tries this too but no solutions yet:

http://www.iredmail.org/wiki/index.php? … s.Manually

veriosn is : Freebsd 8.2 - 64bit
IredAdmin 1.6.1 Ldap edition.

any help would be greatly appreciated as this is my production server.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,135

Re: [SOLVED] Lock wait timeout exceeded; try restarting transaction

Any error log in postfix log file?

3 Reply by rein

  • rein
  • Member
  • Offline
  • Registered: 2010-04-28
  • Posts: 36

Re: [SOLVED] Lock wait timeout exceeded; try restarting transaction

ZhangHuangbin wrote:

Any error log in postfix log file?


Looks like the major culprit was clamav. After turining up log level , a single mail took 20-30s to get scanned. Upgrading clamav to clamav-0.97.1 solved the problem.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,135

Re: [SOLVED] Lock wait timeout exceeded; try restarting transaction

Thanks for your sharing. smile