PostgreSQL and SAM3 UI

Europe/Zurich
513/R-068 (CERN)

513/R-068

CERN

19
Show room on map
Description
Two topics to discuss: * Project plan * PostgreSQL * SAM3 UI
Videoconference Rooms
WLCG_monitoring_consolidation
Name
WLCG_monitoring_consolidation
Description
Kick-off meeting for the WLCG monitoring consolidation project
Extension
109258925
Owner
Pablo Saiz
Auto-join URL
Useful links
Phone numbers
Participated at CERN:

Eddie, Lionel, Pablo, Marian,  Julia, Alberto, Nicolo, Robert, Alessandro, Luca (last to arrive)
Remotely: Alessandra
Apologies: Maarten, Stefan, David C.  


Review of Open Tickets from indico.

18 open tickets due to end of April still open. 
  5 of them finished, and the presentation still to do.
  Costin's update on publishing from the experiment might be a topic for a future meeting
  Moving to AI only one machine left , 3 tasks blocked due this
  Meeting on Wednesday about CREAMCE submission
  Several HC tickets need to be reviewed, we will check offline.
  Elastic search we have a one person on this.
  Downtime info still a couple of weeks
  HDFS will be postponed
  Transition SAM by 15th of May
  OPS after EGI still to be decided.
  C5 content should be discussed in section leader meeting. today we have some summary generated from OPS, we need to review.


second topic, Robert -- PostgreSQL for SSB
false friends: need to review all the  sql queries (5k lines!) and check if they are ANSI SQL

--- question at the end of the presentation.
Julia: we know how much effort to translate, but we don't know if postrgresql is performant enough. 
Robert: This will have to be evaluated.

Alberto: If we want to move to another SQL DB (e.g. mariaDB), would  it be a big change?
Robert: It would not be big huge work (order of a week).

Alberto: why postgresql?
Pablo: one reason is because is better integrated with python, another is that now mysql is oracle...

Lionel: I propose to have some tools to check that the SQL code is ANSI SQL compliant 


SAM3 interface
did anyone use it? no.

Pablo pointed out three things:

o) Site downtimes are not propagated correctly. Still to be verified

o) Site grouping:  It comes from the VOFeed. LHCb seems to be missing some parts.
it's on side of LHCb to improve grouping if needed.
http://wlcg-sam-cms.cern.ch/dashboard/request.py/latestresultssmry-sum

grouping is on the experiment side. country could be useful, but it's the experiments.


o) validity of the data: in the past it was 24h, now we are testing with validity 2h. for the first implementation we will keep the 24h, then we change. having 2 profiles is difficult, duplication of metrics




Next meeting: Friday 9th May at 14:00. Topics: MVC framework and caching






There are minutes attached to this event. Show them.
    • 14:00 14:05
      JIRA actions for April 5m
      Review of the JIRA actions scheduled for this and next month https://its.cern.ch/jira/issues/?filter=13902
      Speaker: Pablo Saiz (CERN)
    • 14:05 14:25
      PostgreSQL plugin for SSB 20m
      Speaker: Mr Robert Vežnaver (CERN)
      Slides
    • 14:25 14:45
      SAM3 interface 20m
    • 14:45 14:55
      Discussion 10m
    • 14:55 15:00
      Next meeting 5m