Log entry time 13:15:47 on April 09, 2011

Entry number 227473

This entry is a followup to: 227407

I restarted autoanalyzers on cdaql3/5 after Scott confirmed that main detector and lumi pedestal map files are correct. The run range is from Run 11216 to current run. There are 8 analysis jobs on cdaql3 and 4 jobs on cdaql5.

• remove all root files
• clean up mysql data_tracker DB, and set them to be "ready to be analyzed"
• clean up mysql qw_fall2010_20101204 DB

Here I summarized mysql commands which I used in order to remove analysis_id from DB qw_fall2010_20101204 according to Paul's elog. See https://hallcweb.jlab.org/hclog/1104_archive/110407122448.html

• SELECT analysis_id FROM analysis_view WHERE run_number between 11215 and 11226
• DELETE FROM analysis WHERE analysis_id IN (61731 ,61801 ,61831 ,61851 ,61881 ,61931 ,61971 ,62001 ,62041 ,62081 ,62121 ,61861 ,61891 ,61921 ,61961 ,61991 ,62031 ,62071 ,62131 ,62171 ,61911 ,61951 ,61981 ,62021 ,62061 ,62111 ,62161 ,62011 ,62051 ,62091 ,62141 ,62181 ,62211 ,62241 ,62271 ,62311 ,62101 ,62151 ,62191 ,62221 ,62261 ,62291 ,62331 ,62371 ,62421 ,62461 ,62201 ,62231 ,62251 ,62281 ,62321 ,62361 ,62401 ,62451 ,62301 ,62341 ,62381 ,62411 ,62441 ,62491 ,62521 ,62541 ,62571 ,62601 ,62641 ,62681 ,62701 ,62351 ,62391 ,62431 ,62471 ,62501 ,62481 ,62511 ,62531 ,62561 ,62591 ,62621 ,62661 ,62711 ,62741 ,62771 ,62551 ,62581 ,62611 ,62651 ,62691 ,62731 ,62761 ,62791 ,62811 ,62831 ,62851 ,62631 ,62671 ,62721 ,62751 ,62781 ,62801 ,62821 ,62841 ,62861 );