prometheus-postgresql-adapter icon indicating copy to clipboard operation
prometheus-postgresql-adapter copied to clipboard

Duplicate key value constraint problems

Open thecodeassassin opened this issue 7 years ago • 3 comments

Hi,

One one of our clusters we're fighting with integrity constraint errors:

"level=warn ts=2018-11-13T16:00:00.390643264Z caller=main.go:274 msg="Error sending samples to remote storage" err="pq: duplicate key value violates unique constraint "metrics_labels_metric_name_labels_key"" storage=PostgreSQL num_samples=100 "

This causes all our prometheus-postgresql-adapter pods to fail, is there anything we can do to solve this? We are using the latest master image.

thecodeassassin avatar Nov 13 '18 16:11 thecodeassassin

Maybe this PR would fix it? https://github.com/timescale/prometheus-postgresql-adapter/pull/47. Has this been released in the latest image on Dockerhub?

thecodeassassin avatar Nov 13 '18 16:11 thecodeassassin

@thecodeassassin Please make sure to use the image tagged with :latest or :version. :master tag is discontinued as it's non standard.

niksajakovljevic avatar Nov 13 '18 16:11 niksajakovljevic

We will investigate

bboule avatar Sep 06 '19 21:09 bboule