FR 2.2.1 rlm_sqlippool / mysql 5.5.31 - deadlocks

[Alan DeKok]

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.