FR 2.2.1 rlm_sqlippool / mysql 5.5.31 - deadlocks

Alan DeKok aland at
Mon Nov 25 15:31:22 CET 2013

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.

More information about the Freeradius-Devel mailing list