Re: FR 2.2.1 rlm_sqlippool / mysql 5.5.31 - deadlocks

George Chelidze wrote:

Investigating the source code for rlm_sqlippool brought me to an idea that moving "CLEAR" query to the distinct transaction can help, because I can't really see any good reason to keep it in the same transaction with "FIND". I have made required minor changes and gave it a try: for two days the server is running without a single deadlock.

Looks good. I'll commit a patch. It should also be doing the CLEAR only once per second. It doesn't make sense to do it on every FIND. That's just unnecessary overhead. Alan DeKok.