search

powa-team / powa-archivist

powa-archivist: the powa PostgreSQL extension
http://powa.readthedocs.io/
PostgreSQL License
53 stars 20 forks source link

"powa_statements_snapshot" failed #52

Closed mencutekinf closed 2 years ago

mencutekinf commented 2 years ago

Hi Team,

I am using PoWA 4.1.4 on PostgreSQL 14.5. I have faced powa snapshot fail error; powa_take_snapshot(1): function "powa_statements_snapshot" failed: duplicate key value violates unique constraint "powa_statements_pkey" I truncated the pow_statements table, it worked for a while, but the error occurred again.

What should I do for the solution?

Thanks in advance for your help.

rjuju commented 2 years ago

Hi,

That's very strange. If the issue is still happening, could you paste the full error logs (including the details about the problematic key)? Have you tried to run a VACUUM FULL (or REINDEX) powa_statements? An index corruption could be one explanation.

Also, I'm transferring this issue to powa-archivist, as this is where the problem is.

rjuju commented 2 years ago

@mencutekinf any news on this issue?

mencutekin commented 2 years ago

Hi, Yes, I have fixed the problem by updating the powa collector. Thank you.

rjuju commented 2 years ago

Ah, that's a great news. Thanks a lot for the feedback!