Unable to Scrape prometheus from Postgres DB - Error "Conn busy"

[Shahidus Shamshad]

Hi Team,

I have integrated prometheus with external RDS postgres DB to store the data permanently. 

But i am trying to read the 3 week data inside prometheus using read handler , data is not reflecting in the prometheus dashboard showing "conn busy error" or sometimes "timeline exceeded".

Could someone please look into this on priority basis.

Thanks,

Shahid - DevOps Engineer

[Brian Candler]

On Sunday, 22 January 2023 at 19:25:27 UTC irtizahs...@gmail.com wrote:

Hi Team,

I have integrated prometheus with external RDS postgres DB to store the data permanently. 

But i am trying to read the 3 week data inside prometheus using read handler , data is not reflecting in the prometheus dashboard showing "conn busy error" or sometimes "timeline exceeded".

Prometheus doesn't talk to Postgres directly, so presumably you are using some sort of third-party remote-write/remote-read adapter, and most likely you're having a problem with that adapter.  Therefore, your starting point should be to look at logs of that adapter.

You haven't said anything about what adapter you're using, nor even what version of Prometheus you're using.  But the best place to get help with the adapter will be wherever it came from.

There are many other long-term storage solutions available, which may work better for you if you don't necessarily require Postgres.

 

Could someone please look into this on priority basis.

http://www.catb.org/~esr/faqs/smart-questions.html#urgent 

(the whole document is well worth reading).