oracledb_exporter icon indicating copy to clipboard operation
oracledb_exporter copied to clipboard

No response on huge custom metrics

Open lunanigra opened this issue 3 years ago • 1 comments

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?

lunanigra avatar Feb 28 '22 22:02 lunanigra

You can increase the flag “—query.timeout=Xs”, since I’d imagine some of those custom queries are hitting the default timeout of 15s

6fears7 avatar Mar 29 '22 14:03 6fears7