<div dir="ltr"><div>Now getting errors like:</div><div><br></div><div>Feb 23 12:28:22 featherby postfix/spawn[7273]: warning: command /usr/lib/postfix/kolab_smtp_access_policy exit status 1</div><div>Feb 23 12:28:22 featherby postfix/smtpd[7245]: warning: premature end-of-input on private/recipient_policy_incoming while reading input attribute name</div>
<div><br></div>If I try to run the command manually I get:<div><br></div><div><div>root@featherby:/etc/postfix# /usr/lib/postfix/kolab_smtp_access_policy -d 9 -l info</div></div><div>[...]</div><div><div>2014-02-23 12:28:29,831 pykolab.smtp_access_policy DEBUG [7356]: Cleaning up the cache</div>
<div>2014-02-23 12:28:29,832 sqlalchemy.pool.QueuePool DEBUG [7356]: Connection <_mysql.connection open to 'localhost' at 91db6ac> checked out from pool</div><div>2014-02-23 12:28:29,833 sqlalchemy.engine.base.Engine INFO BEGIN (implicit)</div>
<div>2014-02-23 12:28:29,833 sqlalchemy.engine.base.Engine INFO DELETE FROM policy_result WHERE policy_result.created < %s</div><div>2014-02-23 12:28:29,833 sqlalchemy.engine.base.Engine INFO (1393032509,)</div><div>Traceback (most recent call last):</div>
<div> File "/usr/lib/postfix/kolab_smtp_access_policy", line 1587, in <module></div><div> cache = cache_init()</div><div> File "/usr/lib/postfix/kolab_smtp_access_policy", line 1199, in cache_init</div>
<div> cache_cleanup()</div><div> File "/usr/lib/postfix/kolab_smtp_access_policy", line 1159, in cache_cleanup</div><div> PolicyResult.created < ((int)(time.time()) - cache_expire)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2677, in delete</div>
<div> result = session.execute(delete_stmt, params=self._params)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 802, in execute</div><div> clause, params or {})</div><div>
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute</div><div> params)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement</div>
<div> compiled_sql, distilled_params</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context</div><div> context)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context</div>
<div> context)</div><div> File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute</div><div> cursor.execute(statement, parameters)</div><div> File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute</div>
<div> self.errorhandler(self, exc, value)</div><div> File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler</div><div> raise errorclass, errorvalue</div><div>sqlalchemy.exc.OperationalError: (OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') 'DELETE FROM policy_result WHERE policy_result.created < %s' (1393032509,)</div>
</div><div><br></div><div>Something is creating locks on the database, and doesn't seem to be releasing them.</div></div>