Skip to content

Use PyCoral for python menu access

Aleksandra Poreba requested to merge aporeba/athena:config-access-execute-recovery-2 into master

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 by Aleksandra Poreba

Merge request reports