Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
  • Sign in
  • athena athena
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Locked Files
  • Jira
    • Jira
  • Merge requests 193
    • Merge requests 193
  • Deployments
    • Deployments
    • Releases
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Value stream
    • Code review
    • Issue
    • Repository
  • Activity
  • Graph
  • Commits
Collapse sidebar
  • atlas
  • athenaathena
  • Merge requests
  • !49415

Merged
Created Jan 04, 2022 by Aleksandra Poreba@aporebaDeveloper

Use PyCoral for python menu access

  • Overview 37
  • Commits 1
  • Pipelines 4
  • Changes 1

Use PyCoral instead of direct oracle/frontier access for Menu-related queries in TrigConfigAccessBase.

The logic was also changed: now, during load the code iterate through all available connection strings instead of retrieving the first correct one. This way the recovery is possible when the query fails during execution (for example Oracle grid error: CORAL/RelationalPlugins/oracle Error ORA-12154: TNS:could not resolve the connect identifier specified (attaching a server 'ATLAS_COOLPROD')), not only during initialization.

Now the TrigConfigAccessBase doesn't use TrigConfFrontier class, but the Frontier access is managed by Coral.

New code was tested on lxplus, both for oracle and frontier credentials and on the grid https://bigpanda.cern.ch/task/?jeditaskid=28301388

Now a draft - was there a reason PyCoral wasn't used before?

Tagging @mark

Edited Mar 02, 2022 by Aleksandra Poreba
Assignee
Assign to
Reviewer
Request review from
Time tracking
Source branch: config-access-execute-recovery-2