From: ivan <ivan>
Date: Fri, 29 Apr 2011 01:36:35 +0000 (+0000)
Subject: avoid deadlocks, RT#10574
X-Git-Tag: freeside_2_3_0~324
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=4cd3537f6e3e14a596c67478bb83b2095303ec50

avoid deadlocks, RT#10574
---

diff --git a/FS/bin/freeside-torrus-srvderive b/FS/bin/freeside-torrus-srvderive
index a02d23ea0..80f222b1c 100644
--- a/FS/bin/freeside-torrus-srvderive
+++ b/FS/bin/freeside-torrus-srvderive
@@ -63,6 +63,11 @@ my $orderlimit = "
     LIMIT 100
 "; #50?
 
+if ( driver_name eq 'mysql' ) {
+  dbh->do('SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED');
+  dbh->commit or die dbh->errstr;
+}
+
 our $kids = 0;
 
 #MAIN: while (1) {