From 7c250c37d720eb39ed564b8ed1b18fd0329e6d87 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 23 Mar 2015 19:11:45 +0000 Subject: [PATCH] express statement-limit in minutes Signed-off-by: Galen Charlton --- Open-ILS/src/reporter/clark-kent.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/reporter/clark-kent.pl b/Open-ILS/src/reporter/clark-kent.pl index de8d80679e..27bbc28b6a 100755 --- a/Open-ILS/src/reporter/clark-kent.pl +++ b/Open-ILS/src/reporter/clark-kent.pl @@ -34,7 +34,7 @@ my ($count, $config, $sleep_interval, $lockfile, $daemon) = (1, 'SYSCONFDIR/open # set upper bound on number of rows in the resultset # before Clark refuses to try to draw a chart my $max_rows_for_charts = 1000; -my $statement_timeout = 10 * 60 * 1000; +my $statement_timeout = 60; my $resultset_limit; GetOptions( @@ -213,7 +213,7 @@ for my $r ( @reports ) { RaiseError => 1 } ); - $data_dbh->do('SET statement_timeout = ?', {}, $statement_timeout); + $data_dbh->do('SET statement_timeout = ?', {}, ($statement_timeout * 60 * 1000)); try { $state_dbh->do(<<' SQL',{}, $r->{id}); -- 2.11.0