--- chewbacca/YodaProfiler/src/PamelaDBOperations.cpp	2009/12/30 10:46:35	1.31
+++ chewbacca/YodaProfiler/src/PamelaDBOperations.cpp	2013/04/10 08:54:28	1.35
@@ -1730,9 +1730,9 @@
     TYPE = 0;
     TSYNC = 0;
     //
-    Double_t minimum = 0.;
-    Double_t maximum = 0.;
-    Double_t minimum2 = 0.;
+    //    Double_t minimum = 0.;
+    // Double_t maximum = 0.;
+    //Double_t minimum2 = 0.;
     Double_t maximum2 = 0.;
     //
     //
@@ -1740,9 +1740,9 @@
     pamela::McmdRecord *mcrc = 0;
     TArrayC *mcmddata = 0;
     //
-    minimum = numeric_limits<Double_t>::max();
-    maximum = numeric_limits<Double_t>::min();
-    minimum2 = numeric_limits<Double_t>::max();
+    //    minimum = numeric_limits<Double_t>::max();
+    //    maximum = numeric_limits<Double_t>::min();
+    //    minimum2 = numeric_limits<Double_t>::max();
     maximum2 = numeric_limits<Double_t>::min();
     //
     T = (TTree*)file->Get("Mcmd");
@@ -2270,8 +2270,10 @@
   //
   // no runtrailers in the file!
   //
-  if ( !rtev ){
-    if ( !rhev ){
+  if ( IsDebug() ) printf(" Start rtev %i rhev %i nrtev %i nrhev %i \n",rtev,rhev,nrtev,nrhev); 
+  if ( !rtev || (chewbacca && !nrtev) ){
+    if ( IsDebug() ) printf(" No runtrailers \n"); 
+    if ( !rhev || (chewbacca && !nrhev) ){
       if ( IsDebug() ) printf(" No runheaders nor runtrailers!! \n"); 
       if ( !(upperentry-chminentry) ){
 	if ( IsDebug() ) printf(" No physics events nor runs in the file \n"); // di nuovo potrebbe esserci un runtrailer senza eventi (riempimento MM)
@@ -2308,6 +2310,7 @@
     //
   } else {
     //
+    if ( IsDebug() ) printf(" We have runtrailers \n"); 
     Int_t conptt = -1;
     for (Int_t ptt=0; ptt<rtev; ptt++){
       //
@@ -3595,7 +3598,7 @@
   //  
   EventCounter *code=0;
   //
-  UInt_t nevent = 0;
+  //  UInt_t nevent = 0;
   UInt_t checkfirst = 0;
   UInt_t checklast = 0;
   UInt_t firstentry = 0;
@@ -3617,7 +3620,7 @@
   EventHeader *eh = 0;
   PscuHeader *ph = 0;
   T->SetBranchAddress("Header", &eh);
-  nevent = T->GetEntries();
+  //  nevent = T->GetEntries();
   //
   //
   if ( firstev == lastev+1 || lastev == firstev ) { // no events inside the run!
@@ -4138,7 +4141,7 @@
   EventCounter *code=0;
   UInt_t firstev = 0;
   UInt_t lastev = 0;
-  UInt_t nevent = 0;
+  //  UInt_t nevent = 0;
   UInt_t checkfirst = 0;
   UInt_t checklast = 0;
   UInt_t firstentry = 0;
@@ -4163,7 +4166,7 @@
   EventHeader *eh = 0;
   PscuHeader *ph = 0;
   T->SetBranchAddress("Header", &eh);
-  nevent = T->GetEntries();
+  //  nevent = T->GetEntries();
   //
   codt = eht->GetCounter();
   codh = ehh->GetCounter();
@@ -5446,7 +5449,8 @@
 
 	if ( IsDebug() ) cout << endl << ">>>> TRY TO RECOVER TRACKER CALIBRATIONS <<<<"<<endl;
 
-	TSQLResult *result = 0;
+	TSQLResult *rresult = 0; // 10RED bug, result is re-used inside result looop...
+	TSQLResult *result = 0; // 10RED bug, result is re-used inside result looop...
 	TSQLRow    *row    = 0;
 	//
 	stringstream oss;
@@ -5476,7 +5480,7 @@
 	oss << " ORDER BY ID DESC LIMIT "<<ncalib<<"; ";	
 	if ( IsDebug() ) cout << oss.str().c_str() << endl;
 
-	result = conn->Query(oss.str().c_str());
+	rresult = conn->Query(oss.str().c_str());
 	if ( !result ) throw -4;;
 	if ( IsDebug() ) cout <<"Rows: "<<result->GetRowCount()<<endl;
 	
@@ -5485,7 +5489,7 @@
 	// -----------------------------------
 	UInt_t nn=0;
 	do {
-	    row = result->Next();
+            row = rresult->Next();
 	    if(!row)break;
 	    
 	    UInt_t id       = (UInt_t)atoll(row->GetField(0));
@@ -5524,9 +5528,9 @@
 	    TString path       = "";
 	    TString name       = "";
 	    TString raw        = "";
-	    UInt_t obt0        = 0;
-	    UInt_t timesync    = 0;
-	    UInt_t boot_number = 0;
+            //	    UInt_t obt0        = 0;
+            //	    UInt_t timesync    = 0;
+            //	    UInt_t boot_number = 0;
 	    bool   FOUND       = false;
 
 	    if ( IsDebug() ) cout << "------------------------------------------------------------" <<endl;
@@ -5599,9 +5603,9 @@
 		    path       = (TString)row2->GetField(0);
 		    name       = (TString)row2->GetField(1);
 		    raw        = (TString)row2->GetField(5);
-		    obt0        = (UInt_t)atoll(row2->GetField(2));
-		    timesync    = (UInt_t)atoll(row2->GetField(3));
-		    boot_number = (UInt_t)atoll(row2->GetField(4));
+                    //		    obt0        = (UInt_t)atoll(row2->GetField(2));
+                    //		    timesync    = (UInt_t)atoll(row2->GetField(3));
+                    //		    boot_number = (UInt_t)atoll(row2->GetField(4));
 		
 		    if ( IsDebug() ) cout << "- - - - - - - - - - -" <<endl;
 //		    cout << path <<endl;
@@ -5665,7 +5669,8 @@
 		    if(FOUND)break;
 
 		}while(1);//endl loop over root table entries
-
+                
+                delete result2; // 10RED potential memory leak
 		if(FOUND)break;
 
 	    }//end loop over tables 
@@ -5819,7 +5824,7 @@
 	}while(1);//end loop over calibrations
 	
 	
-	if( result )delete result;
+	if( rresult )delete rresult; // 10RED bug
 	if( row    )delete row;
 	
 	
@@ -6120,7 +6125,7 @@
     memset(myid,0,500*sizeof(UInt_t));
     //
     oss.str("");
-    oss << "SELECT ID,RUNTRAILER_TIME,RUNTRAILER_PKT,BOOT_NUMBER FROM GL_RUN_FRAGMENTS WHERE INSERT_TIME <= '" << clean_time->AsSQLString() << "'order BY RUNHEADER_TIME asc;";
+    oss << "SELECT ID,RUNTRAILER_TIME,RUNTRAILER_PKT,BOOT_NUMBER FROM GL_RUN_FRAGMENTS WHERE INSERT_TIME <= '" << clean_time->AsSQLString() << "' order BY RUNHEADER_TIME asc;";
     if ( IsDebug() ) printf(" Select from GL_RUN_FRAGMENTS runs older than %s : query is \n %s \n",clean_time->AsSQLString(),oss.str().c_str());
     nresult = conn->Query(oss.str().c_str());
     //