FR 2.2.1 rlm_sqlippool / mysql 5.5.31 - deadlocks

Phil Mayers p.mayers at imperial.ac.uk
Mon Nov 25 16:14:03 CET 2013


On 25/11/13 14:31, Alan DeKok wrote:
> 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's probably worth making the 2nd transaction conditional on the 
"clear" query being defined.

Personally I think this is a MySQL problem, not a FR/rlm_sql_ippool one.


More information about the Freeradius-Devel mailing list