Re: BCAL06 online database crash

We were planning to continue the analysis here where Blake left off. We have another grad student (Stamatis Katsaganis) who was going to look at the energy resolution as a function of angle, runs at small angles and near the edge of the BCAL, and run MCs to match all this.

As a result, David and I decided that he would get that disk and copy the files over somewhere safe and leave it at that for now. In the event we need the online stuff later, we can attempt to get a MySQL server running at the appropriate version and access the DB again.

For now we can proceed with the data files, Run Table, and e-log and hard-logbook.

Cheers, Zisis...

On Sep 17, 2008, at 7:48 AM, David Lawrence wrote:

Hi Folks,

I was informed yesterday that the database server which housed the online run information from the 2006 BCAL beam test has died. This was linked from the BCAL06 wiki page as "Online DAQ Database". This database contained information like the following: beam currents, begin and end run times, shift operators, number of events, etc..

Note that we still have the run table on the wiki that lists all of the important runs by number and conditions (http://www.jlab.org/Hall-D/software/wiki/index.php/Run_Table). The data itself is kept somewhere else and unaffected by this.

The question is whether there is any need to attempt recovery of this database from the disk. The disk is believed to be in good shape, so we can access the files. But without the server running, it will be difficult to extract the data itself. Hence, my inquiry as to how important this is before investing any time into it. Please let me know if anyone thinks they might need this information in the future since if we don't try this now, it is unlikely we'll be able to locate the disk to try it later.

Regards,
-David

--

------------------------------------------------------------------------
David Lawrence Ph.D.
Staff Scientist Office: (757)269-5567 [[[ [ [ [ Jefferson Lab Pager: (757)584-5567 [ [ [ [ [ [ http://www.jlab.org/~davidl davidl@jlab.org [[[ [[ [[ [[[
------------------------------------------------------------------------

---

Dr. Zisis Papandreou | email: zisis@uregina.ca

Department of Physics | tel. : (306) 585-5379

University of Regina | tel. : (306) 585-4149

Regina, SK S4S 0A2 | fax. : (306) 585-5659

World Wide Web: http://www.phys.uregina.ca/sparro/zisis/