Can't reconnect until invalid transaction is rolled back.

[msavdert]

Describe the bug

Thanks for writing this great exporter.

I can get metrics from oracle database with query-exprter without any problem.

However, when the database is restarted, I encounter the following errors. Despite the database being up and running, these errors continue to occur during each scrape, and the metric collection process stops. Problem fix after restarting the query-exporter.

Nov 27 01:40:13 ora02 query-exporter[58203]: 2024-11-27 01:40:13,620 - ERROR - query-exporter - query "oracledb_fra_stats" on database "orclgg" failed: Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding (Background on this error at: https://sqlalche.me/e/20/8s2b)

[albertodonato]

Could you please provide which version are you using, and possibly log with debug enabled? (passing -L DEBUG)

[RubenNL]

I have the same issue with a Postgres database.

query-exporter version 2.11.1 (latest on docker currently)

I included my config and the log with debugging enabled. I manually restarted the database here to trigger the error.

query-exporter-log.txt

query-exporter-config.yaml.txt

[RubenNL]

I'm now getting this error with debugging disabled. Might not be related:

ERROR - query-exporter - error from database "ov": AssertionError

[RubenNL]

I just tested this with the latest 3.0.0 release, and got a new log. This log is exported from Kubernetes with Helm, and got timestamps. It also got some pretty error messages, but I have no idea how to make that more readable in a log file...

So this is the raw one:

app.log

[albertodonato]

Do you happen to have autocommit: false set on your database configuration?

[RubenNL]

No, should I try that option?