X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-torrus-srvderive;h=b4113b714a53a3f613ecbc83b49be2fd49d8c27d;hb=90c85ed3e1baaf7eed459cc9d5bd587d5b90b3bc;hp=c2ee0329d4ca8a478a1550c46a36561d209eb719;hpb=51a651e4f6c97dc18132f937c8e4c3b61a94bfcd;p=freeside.git diff --git a/FS/bin/freeside-torrus-srvderive b/FS/bin/freeside-torrus-srvderive index c2ee0329d..b4113b714 100644 --- a/FS/bin/freeside-torrus-srvderive +++ b/FS/bin/freeside-torrus-srvderive @@ -8,7 +8,7 @@ use FS::UID qw( adminsuidsetup dbh driver_name ); use FS::Record qw( qsearch str2time_sql str2time_sql_closing concat_sql ); use FS::torrus_srvderive; -our $DEBUG = 1; +our $DEBUG = 2; my $user = shift or die &usage; $FS::Daemon::PID_NEWSTYLE = 1; @@ -89,9 +89,11 @@ while (1) { $ssql .= $orderlimit; - warn $ssql if $DEBUG > 1; + warn "searching for times to add $serviceid\n" if $DEBUG; + warn $ssql if $DEBUG > 2; my $sth = dbh->prepare($ssql) or die $DBI::errstr; #better recovery? $sth->execute($serviceid, $serviceid) or die $sth->errstr; + my $prev = 0; while ( my $row = $sth->fetchrow_arrayref ) { last if sigterm() || sigint(); @@ -142,11 +144,13 @@ while (1) { $prev = $cur; } + warn "done with $serviceid\n" if $DEBUG; } - + dbh->commit or die dbh->errstr; myexit() if sigterm() || sigint(); + warn "restarting main loop\n" if $DEBUG > 1; sleep 60 unless $found; }