From 4cd3537f6e3e14a596c67478bb83b2095303ec50 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 29 Apr 2011 01:36:35 +0000 Subject: [PATCH] avoid deadlocks, RT#10574 --- FS/bin/freeside-torrus-srvderive | 5 +++++ 1 file changed, 5 insertions(+) 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) { -- 2.11.0