Alert Creation Failure: Error Encountered When Detecting pgpool Status Down

anaskhantpl · April 26, 2024, 2:00am

I’ve configured a Patroni cluster, with PGPool serving as the load balancer. We have a file that logs PGPool status in the following format:

Example 1:
up
up
up

Example 2:
up
down
up

I’m able to monitor PGPool status on a Grafana panel using the query:

{job="pgstats"} |= `up`

However, when attempting to use the same query on the Grafana alert page, I encounter the following error:

[sse.readDataError] [A] got error: input data must be a wide series but got type long (input refid)

Running the identical query on a Grafana dashboard panel yields the expected output, but it doesn’t function correctly on the alert page.

Versions:

akshayawate2012 · April 26, 2024, 5:05am