Upgrading to Kolab 3.1

Brian May brian at microcomaustralia.com.au
Sun Feb 23 02:30:33 CET 2014


Now getting errors like:

Feb 23 12:28:22 featherby postfix/spawn[7273]: warning: command
/usr/lib/postfix/kolab_smtp_access_policy exit status 1
Feb 23 12:28:22 featherby postfix/smtpd[7245]: warning: premature
end-of-input on private/recipient_policy_incoming while reading input
attribute name

​If I try to run the command manually I get:

root at featherby:/etc/postfix# /usr/lib/postfix/kolab_smtp_access_policy -d 9
-l info
[...]
2014-02-23 12:28:29,831 pykolab.smtp_access_policy DEBUG [7356]: Cleaning
up the cache
2014-02-23 12:28:29,832 sqlalchemy.pool.QueuePool DEBUG [7356]: Connection
<_mysql.connection open to 'localhost' at 91db6ac> checked out from pool
2014-02-23 12:28:29,833 sqlalchemy.engine.base.Engine INFO BEGIN (implicit)
2014-02-23 12:28:29,833 sqlalchemy.engine.base.Engine INFO DELETE FROM
policy_result WHERE policy_result.created < %s
2014-02-23 12:28:29,833 sqlalchemy.engine.base.Engine INFO (1393032509,)
Traceback (most recent call last):
  File "/usr/lib/postfix/kolab_smtp_access_policy", line 1587, in <module>
    cache = cache_init()
  File "/usr/lib/postfix/kolab_smtp_access_policy", line 1199, in cache_init
    cache_cleanup()
  File "/usr/lib/postfix/kolab_smtp_access_policy", line 1159, in
cache_cleanup
    PolicyResult.created < ((int)(time.time()) - cache_expire)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
2677, in delete
    result = session.execute(delete_stmt, params=self._params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line
802, in execute
    clause, params or {})
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1449, in execute
    params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1698, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1691, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
line 331, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36,
in defaulterrorhandler
    raise errorclass, errorvalue
sqlalchemy.exc.OperationalError: (OperationalError) (1205, 'Lock wait
timeout exceeded; try restarting transaction') 'DELETE FROM policy_result
WHERE policy_result.created < %s' (1393032509,)

Something is creating locks on the database, and doesn't seem to be
releasing them.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kolab.org/pipermail/users/attachments/20140223/5ba33024/attachment-0001.html>


More information about the users mailing list