Difference: Meeting080128 (1 vs. 2)

Revision 22008-01-28 - PhilippeCharpentier

Line: 1 to 1
 
META TOPICPARENT name="BKDev"

Bookkeeping meeting, January 28th 2008

Changed:
<
<
Present: R.McNulty, T.Kechadi (by phone), Z.Mathe (Dublin), Ph.Charpentier (chair, minutes), E.Lanciotti
>
>
Present: R.McNulty (by phone), Ph.Charpentier (chair, minutes), E.Lanciotti, Z.Mathe
  Apologies: M.Bargiotti
Line: 14 to 14
  Action (Marianne): see with Birger how to install the service on volhcb05
Changed:
<
<
For the new system, Marianne has obtained a DB instance from IT. She has set up the BK services on volhcb07 as well as an AMGA service in Glasgow. One has to see how we shall use these instances (see later)
>
>
For the new system, Marianne has obtained a DB instance from IT. She has set up the BK services on volhcb07 as well as an AMGA service in Glasgow. The main problem today is to figure out how to create the tables in the DB. It seems the tables are created directly with SQL command, and Elisa found a .SQL file that looks as if it is the one to use. There is however some hardcoded information for indexing the tables that look pretty strange as they concern old data. Is there no partitioning for DC06? Elisa will continue investigating with Marianne. The goal is to have the development system work with old code, old schema and old data before moving to a new schema or new software...

Maintenance of the existing system

There are two pending issues:

  • Java crashes for some stripping event types. it seems linked to the Java AMGA interface as the same query is OK with the python API (Elisa's script). Elisa will ask Birger whether he can have a look

  • Duplicate entries of files in the views: if a file has ancestor jobs that were using two versions of a given program, this file is entered in the two JOBFILEINFO corresponding to the two versions. The consequence is that the statistics reported in the BK web page is incorrect (double counting of these files). The Gaudi cards generated however give the correct list and correct number of events. A fix would be to enter each file only once (e.g. with the first version, or with a combined version e.g. Brunel v30r14/v30r15 to indicate there is a mixture). Not only the web page is affected but also the script Carmine gave to the physics coordinator and a few others report that number of events (which is the sum of the events in each matching roottree row).

Items for the new system

  -- PhilippeCharpentier - 28 Jan 2008 \ No newline at end of file

Revision 12008-01-28 - PhilippeCharpentier

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="BKDev"

Bookkeeping meeting, January 28th 2008

Present: R.McNulty, T.Kechadi (by phone), Z.Mathe (Dublin), Ph.Charpentier (chair, minutes), E.Lanciotti

Apologies: M.Bargiotti

Goal of the meetings

These regular meetings (Mondays at 16:00) are intended at reviewing the work to be done and being done on the bookkeeping system. This includes maintenance and short term fixes on the production system as well as new developments for the new system.

Hardware setup

The existing system uses volhcb05.cern.ch as BK server, that accesses the BKDB via AMGA running on lxarda01.cern.ch. This machine has to be retired and the service has to run somewhere else. It is proposed to run the service on volhcb05 itself as it uses very few resources.

Action (Marianne): see with Birger how to install the service on volhcb05

For the new system, Marianne has obtained a DB instance from IT. She has set up the BK services on volhcb07 as well as an AMGA service in Glasgow. One has to see how we shall use these instances (see later)

-- PhilippeCharpentier - 28 Jan 2008

 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback