smtp policy mysql bug ?

[Franz Skale]

Hi,
this fix i tried already.
Works two times and then stalls again.
Also i created a new package of python-mysqldb pulling from sourceforge
(1.2.4b4) which changed nothing.
So, the bug must be in the sqlalchemy code of the smtp policy python script.
I think the spawned processes are deadlocking the mysql connection until
a timeout happens.

25854 ?        S      0:00 spawn -n sender_policy_incoming -t unix
user=kolab-n argv=/usr/lib/postfix/kolab_smtp_access_policy
--verify-sender --allow-unauthenticated -d 9 -l info
25857 ?        S      0:00 spawn -n recipient_policy_incoming -t unix
user=kolab-n argv=/usr/lib/postfix/kolab_smtp_access_policy
--verify-recipient --allow-unauthenticated -d 9 -l info
25864 ?        S      0:00 spawn -n sender_policy_incoming -t unix
user=kolab-n argv=/usr/lib/postfix/kolab_smtp_access_policy
--verify-sender --allow-unauthenticated -d 9 -l info
25869 ?        Ss     0:00 /usr/bin/python
/usr/lib/postfix/kolab_smtp_access_policy --verify-sender
--allow-unauthenticated -d 9 -l info
25871 ?        Ss     0:00 /usr/bin/python
/usr/lib/postfix/kolab_smtp_access_policy --verify-recipient
--allow-unauthenticated -d 9 -l info

 344 | kolab | localhost | kolab | Query   | 30   | updating | DELETE
FROM policy_result WHERE policy_result.created < 1394876634 |

Rgds.

Franz


Am 15.03.14 22:10, schrieb Scott Newton:
>
> On Sat, 15 Mar 2014 12:03:39 Franz Skale wrote:
>
> > Perhaps someone has a fix for it ?
>
>  
>
> Not a code fix but to manually fix it do:
>
>  
>
> 1. Stop postfix
>
> 2. delete * from policy_result;
>
> 3. Start postfix
>
>  
>
> I've had this happen to me twice but haven't been able to figure out
> what causes it. I suspect something to do with upgrading/restarting
> but nothing definitive.
>
>  
>
> Hope this helps.
>
>  
>
> -- 
>
> Regards
>
> Scott Newton
>
>
>
> _______________________________________________
> users mailing list
> users at lists.kolab.org
> https://lists.kolab.org/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kolab.org/pipermail/users/attachments/20140316/49607b1c/attachment-0001.html>
-------------- 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/20140316/49607b1c/attachment-0001.p7s>