Debug logs for additional python modules(oracledb)

[praphi-git]

I am running query exporter for Oracle Database using MacOS using the command against python virtual environment

query-exporter --config oracle-stats.yaml --log-level debug

i get a stack trace indicating that i need to use thick client

logs

/Users/pgana1/work/prom_exporter/.venv/lib/python3.13/site-packages/oracledb/connection.py:576 │
│ in init │
│ │
│ 573 │ │ │ │ │ impl = pool_impl.acquire(params_impl) │
│ 574 │ │ │ │ else: │
│ 575 │ │ │ │ │ impl = thin_impl.ThinConnImpl(dsn, params_impl) │
│ ❱ 576 │ │ │ │ │ impl.connect(params_impl) │
│ 577 │ │ │ else: │
│ 578 │ │ │ │ impl = thick_impl.ThickConnImpl(dsn, params_impl) │
│ 579 │ │ │ │ impl.connect(params_impl, pool_impl) │
│ │
│ ╭─────────────────────────────────── locals ───────────────────────────────────╮ │
│ │ dsn = 'ebs_TSTIDL' │ │
│ │ impl = <oracledb.thin_impl.ThinConnImpl object at 0x1055ed480> │ │
│ │ kwargs = {'password': 'EbabIDL2024', 'user': 'apps'} │ │
│ │ mode_mgr = <oracledb.driver_mode.DriverModeManager object at 0x1055082f0> │ │
│ │ params = None │ │
│ │ params_impl = <oracledb.base_impl.ConnectParamsImpl object at 0x10597e340> │ │
│ │ pool = None │ │
│ │ pool_impl = None │ │
│ │ self = <oracledb.Connection disconnected> │ │
│ │ thin = True │ │
│ ╰──────────────────────────────────────────────────────────────────────────────╯ │
│ │
│ in oracledb.thin_impl.ThinConnImpl.connect:433 │
│ │
│ in oracledb.thin_impl.ThinConnImpl.connect:429 │
│ │
│ in oracledb.thin_impl.ThinConnImpl._connect_with_params:389 │
│ │
│ in oracledb.thin_impl.ThinConnImpl._connect_with_description:370 │
│ │
│ in oracledb.thin_impl.ThinConnImpl._connect_with_address:343 │
│ │
│ in oracledb.thin_impl.Protocol._connect_phase_two:327 │
│ │
│ in oracledb.thin_impl.Protocol._process_message:408 │
│ │
│ in oracledb.thin_impl.Protocol._process_message:385 │
│ │
│ in oracledb.thin_impl.Message.send:340 │
│ │
│ in oracledb.thin_impl.AuthMessage._write_message:1765 │
│ │
│ /Users/pgana1/work/prom_exporter/.venv/lib/python3.13/site-packages/oracledb/errors.py:195 in │
│ _raise_err │
│ │
│ 192 │ supplied arguments. │
│ 193 │ """ │
│ 194 │ error = _create_err(error_num, context_error_message, cause, **args) │
│ ❱ 195 │ raise error.exc_type(error) from cause │
│ 196 │
│ 197 │
│ 198 def _raise_not_supported(feature: str) -> None: │
│ │
│ ╭──────────────────────────────── locals ────────────────────────────────╮ │
│ │ args = {'verifier_type': 2361} │ │
│ │ cause = None │ │
│ │ context_error_message = None │ │
│ │ error = <oracledb.errors._Error object at 0x1059ddfd0> │ │
│ │ error_num = 3015 │ │
│ ╰────────────────────────────────────────────────────────────────────────╯ │
╰──────────────────────────────────────────────────────────────────────────────────────────────────╯
NotSupportedError: (oracledb.exceptions.NotSupportedError) DPY-3015: password verifier type 0x939 is
not supported by python-oracledb in thin mode
Help: https://python-oracledb.readthedocs.io/en/latest/user_guide/troubleshooting.html#dpy-3015
(Background on this error at: https://sqlalche.me/e/20/tw8g)

2025-02-11 13:24:26 [debug ] updating metric labels={'database': 'oracle'} method=inc metric=database_errors value=1
2025-02-11 13:24:26 [error ] database error database=oracle

There seems to be issues with loading the client library for Oracle. it is unable to switch to thick client mode. I am trying to debug this further and see what could be the problem.

I have tried adding DPI_DEBUG_LEVEL=64 to trace the issue further, but i am unable to see the debug logs. Where do the additional logs get stored

i have tried testing the connection using test code(sqlalchemy/create_engine) and I am able to connect and run when i use oracledb.init_oracle_client(lib_dir=<instantclient_23_3 dir path>)

sample debug logs with (DPI_DEBUG_LEVEL=64)

oracledb debug logs

debug logs for oracledb

ODPI [9684695] 2025-02-11 13:51:37.078: ODPI-C 4.3.0
ODPI [9684695] 2025-02-11 13:51:37.078: debugging messages initialized at level 64
ODPI [9684695] 2025-02-11 13:51:37.149: ODPI-C 5.4.1
ODPI [9684695] 2025-02-11 13:51:37.149: debugging messages initialized at level 64
ODPI [9684695] 2025-02-11 13:51:37.149: Context Parameters:
ODPI [9684695] 2025-02-11 13:51:37.149: Oracle Client Lib Dir: /Users/pgana1/work/instantclient_23_3
ODPI [9684695] 2025-02-11 13:51:37.149: Oracle Client Config Dir: /Users/pgana1/work/instantclient_23_3/network/admin
ODPI [9684695] 2025-02-11 13:51:37.149: Environment Variables:
ODPI [9684695] 2025-02-11 13:51:37.149: ORACLE_HOME => "/Users/pgana1/work/instantclient_23_3"
ODPI [9684695] 2025-02-11 13:51:37.149: TNS_ADMIN => "/Users/pgana1/work/instantclient_23_3/network/admin"
ODPI [9684695] 2025-02-11 13:51:37.149: LD_LIBRARY_PATH => "/Users/pgana1/work/instantclient_23_3"
ODPI [9684695] 2025-02-11 13:51:37.149: load in parameter directory
ODPI [9684695] 2025-02-11 13:51:37.149: load in dir /Users/pgana1/work/instantclient_23_3
ODPI [9684695] 2025-02-11 13:51:37.149: load with name /Users/pgana1/work/instantclient_23_3/libclntsh.dylib
ODPI [9684695] 2025-02-11 13:51:37.886: load by OS successful
ODPI [9684695] 2025-02-11 13:51:37.886: validating loaded library

[albertodonato]

I'm not familiar with Oracle, but I see https://python-oracledb.readthedocs.io/en/latest/user_guide/troubleshooting.html#dpy-3015 has some steps to address the issue. Have you tried following those?

[praphi-git]

yes i have seen that page

To debug it further I have enabled the logging

DPI_DEBUG_LEVEL=64

But I am unable to see the logs when I run the query-exporter

I am able to see the logs when I use the setting and yes code using SQL Alchemy python library