Put a separate transaction around allocate_clear

to deal with MySQL issues.  It reduces deadlocks

diff --git a/src/modules/rlm_sqlippool/rlm_sqlippool.c b/src/modules/rlm_sqlippool/rlm_sqlippool.c
index 7d2ae16..821fd92 100644 (file)
--- a/src/modules/rlm_sqlippool/rlm_sqlippool.c
+++ b/src/modules/rlm_sqlippool/rlm_sqlippool.c
@@ -584,6 +584,18 @@ static int sqlippool_postauth(void *instance, REQUEST * request)
                          (char *) NULL, 0);
 
        /*
+        * COMMIT
+        */
+       sqlippool_command(data->allocate_commit, sqlsocket, data, request,
+                         (char *) NULL, 0);
+
+       /*
+        * BEGIN
+        */
+       sqlippool_command(data->allocate_begin, sqlsocket, data, request,
+                         (char *) NULL, 0);
+
+       /*
         * FIND
         */
        allocation_len = sqlippool_query1(allocation, sizeof(allocation),