Could you check that:
[1] CrateDB is up and running
[2] CrateDB is reachable from where cratedb-prometheus-adapter is being run with the same credentials?
Hi, yes, CrateDB is up and reachable. We do have a large number of metrics already ingested; however, the adapter seems to baulk after approx 20 seconds.
Can you try to increase the values for the timeout parameters so that the Prometheus Adapters does not quit the connection too early? When it’s taking too long to evaluate your query, you may need to optimize it, or your data schema / cluster configuration.
Please let us know if that improves the situation for you.
The assertions are correct. I’ve increased the connect_timeout, read_timeout and write_timeout values which has helped massively.
The server running CrateDB and the adapter is behind multiple firewalls and I don’t have access to the UI. Are there SQL queries I can run to capture CrateDB performance stats?
Thanks Andreas, increasing connect_timeout, read_timeout and write_timeout values has improved things. I’ve only captured a single error in a hour with ingestion at the same rate. I’ll continue to tweak the parameters and monitor.