oracledb_exporter
oracledb_exporter copied to clipboard
No response on huge custom metrics
Our custom SQL creates a huge amount of metrics - more than 1000. It seems that there is a point where oracledb_exporter does not provide any response (timeout on port 9161).
However the console log shows that the metrics were completely run...
{"level":"debug","msg":"ScrapeGenericValues() - metricsCount: 1932","source":"main.go:312","time":"2022-02-28T14:22:25Z"}
{"level":"debug","msg":"Successfully scrapped metric: xxx","source":"main.go:238","time":"2022-02-28T14:22:25Z"}
{"level":"info","msg":"Listening on 0.0.0.0:8161","source":"main.go:419","time":"2022-02-28T14:22:25Z"}
With slightly modified custom SQL the setup works totally fine.
The whole metrics response should be approx. 1.5 MB. Is there any size limit or are there any limits that can be configured?
You can increase the flag “—query.timeout=Xs”, since I’d imagine some of those custom queries are hitting the default timeout of 15s