Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" - Mailing list pgsql-general

From Laurenz Albe
Subject Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
Date
Msg-id efd746b47ab0ac43c432c8f79383e4b1237f586e.camel@cybertec.at
Whole thread Raw
In response to Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"  (Torsten Krah <krah.tm@gmail.com>)
List pgsql-general
On Wed, 2023-09-06 at 10:33 +0200, Torsten Krah wrote:
> Am Mittwoch, dem 06.09.2023 um 10:21 +0200 schrieb Laurenz Albe:
> > You are lucky that the corrupted table is one that holds data that
> > can be rebuilt.
>
> It is a test instance / container anyway which is deleted afterwards
> and can be setup again as often as I want.
>
> But how is that corruption happening - I mean it is a docker image,
> freshly fetched from the registry.
>
> After that I am starting a container from that image, (re)importing
> data (different tests => different data so the cycle of delete data /
> import data / analyze the data happens quite often) and running my
> tests.
> The OS does not report anything which would relate nor does any other
> tool / system fail nor does postgresl itself fail on any other table
> here - it always fails only on that analyze part.
>
> That happens all in about 8-10 minutes for the whole process - what is
> causing that corruption in that short timeframe here?

If you have a reproducible way to create the data corruption, that would
be very interesting.  It micht be a software bug.

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: Torsten Krah
Date:
Subject: Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"
Next
From: Erik Wienhold
Date:
Subject: Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index"