smtp policy mysql bug ?

[Franz Skale]

Hi,
i'm still testing and running some stress tests of the new release using
debian.
So, i am on debugging the smtp policy mysql problem on my server.
An delete statement hangs and i think there must be a bug on deadlocking
the policy_result table.

This query hangs a long time:
| 258 | kolab | localhost | kolab | Query   | 6    | updating | DELETE
FROM policy_result WHERE policy_result.created < 1394794685 |

Using the mysql client it takes no time.
Is there a bug in the connection pool handling on the smtp policy script ?


Debug:

2014-03-15 11:58:05,605 sqlalchemy.engine.base.Engine INFO SELECT DATABASE()
2014-03-15 11:58:05,605 sqlalchemy.engine.base.Engine INFO ()
2014-03-15 11:58:05,606 sqlalchemy.engine.base.Engine INFO SHOW
VARIABLES LIKE 'character_set%%'
2014-03-15 11:58:05,606 sqlalchemy.engine.base.Engine INFO ()
2014-03-15 11:58:05,607 sqlalchemy.engine.base.Engine INFO SHOW
VARIABLES LIKE 'lower_case_table_names'
2014-03-15 11:58:05,607 sqlalchemy.engine.base.Engine INFO ()
2014-03-15 11:58:05,608 sqlalchemy.engine.base.Engine INFO SHOW COLLATION
2014-03-15 11:58:05,609 sqlalchemy.engine.base.Engine INFO ()
2014-03-15 11:58:05,611 sqlalchemy.engine.base.Engine INFO SHOW
VARIABLES LIKE 'sql_mode'
2014-03-15 11:58:05,611 sqlalchemy.engine.base.Engine INFO ()
2014-03-15 11:58:05,612 sqlalchemy.engine.base.Engine INFO DESCRIBE
`statistic`
2014-03-15 11:58:05,612 sqlalchemy.engine.base.Engine INFO ()
2014-03-15 11:58:05,613 sqlalchemy.engine.base.Engine INFO DESCRIBE
`policy_result`
2014-03-15 11:58:05,613 sqlalchemy.engine.base.Engine INFO ()
2014-03-15 11:58:05,614 pykolab.smtp_access_policy DEBUG [17427]:
Cleaning up the cache
2014-03-15 11:58:05,616 sqlalchemy.pool.QueuePool DEBUG [17427]:
Connection <_mysql.connection open to 'localhost' at 35724a0> checked
out from pool
2014-03-15 11:58:05,616 sqlalchemy.engine.base.Engine INFO BEGIN (implicit)
2014-03-15 11:58:05,616 sqlalchemy.engine.base.Engine INFO DELETE FROM
policy_result WHERE policy_result.created < %s
2014-03-15 11:58:05,616 sqlalchemy.engine.base.Engine INFO (1394794685,)

Mar 15 11:58:04 mail postfix/spawn[17395]: warning: command
/usr/lib/postfix/kolab_smtp_access_policy exit status 1
Mar 15 11:58:04 mail postfix/smtpd[17391]: warning: premature
end-of-input on private/recipient_policy_incoming while reading input
attribute name
Mar 15 11:58:56 mail postfix/spawn[17395]: warning: command
/usr/lib/postfix/kolab_smtp_access_policy exit status 1
Mar 15 11:58:56 mail postfix/smtpd[17391]: warning: premature
end-of-input on private/recipient_policy_incoming while reading input
attribute name
Mar 15 11:58:56 mail postfix/smtpd[17391]: warning: problem talking to
server private/recipient_policy_incoming: Connection reset by peer

Perhaps  someone has a fix for it ?

Rgds

Franz



-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4254 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.kolab.org/pipermail/users/attachments/20140315/412b5b20/attachment.p7s>