On Fri, Sep 22, 2006 at 09:40:08AM -0400, Matthew Caron wrote: > > >> I'm testing 2.1 for deployment and it seems to not be able to get email > >> every time MMCron.py runs (once per minute). The only clue in the log > >> file is: > >> > >> 2006-09-15T20:19:06 INFO event.mailmanager.cron INFO(20) MailManager: > >> Failure to get lock for get_mail > >> > > MySQL 5.0.22.
The process_task method makes use of get_lock and release_lock under MySQL. Unfortunately, these are not transaction safe. It is possible that the getmail process failed, aborting the transaction, and leaving the lock open. As Zope does connection pooling with ZMySQLDA, this will hold the lock indefinitely, until that connection is reset. If you wanted to submit a patch for an alternative locking mechanism for MySQL 5, that would be appreciated. For now, if you raise a bug on sf it will be looked at, but I cannot see an immediate fix to this issue. Regards, Kevin -- Kevin Campbell Logicalware Ltd GPG Key: F480EC23 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Mailmanager-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mailmanager-users
