25 Nov
2013
25 Nov
'13
10:14 a.m.
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.