FR 2.2.1 rlm_sqlippool / mysql 5.5.31 - deadlocks
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