MIME-Version: 1.0
References: <CAH=zU4t3KRpt6uTZn_4eKkvpL_X9ACGNZ+XDxfMjnn6ovAyPVQ@mail.gmail.com>
 <CAMurXp115NcKB64EsksfSMJmztS_FBm0PuAmnXu_OXgh8MVz3w@mail.gmail.com>
 <CAH=zU4tTUYCyhipNy-auv-Zum=CFiV0g1BURyFxrx7_nsv0Ucg@mail.gmail.com> <42ed36a1-2581-43f7-a606-2c139929b38f@aklaver.com>
In-Reply-To: <42ed36a1-2581-43f7-a606-2c139929b38f@aklaver.com>
From: shashidhar Reddy <shashidharreddy001@gmail.com>
Date: Tue, 26 Nov 2024 08:37:08 +0530
Message-ID: <CAH=zU4syqG08eH7+McKeVL1f+ggfBSbpe89R0wwmfcDhk_3kiQ@mail.gmail.com>
Subject: Re: Unique key constraint Issue
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: ajit wangkhem <ajit.wangkhem@gmail.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b99dda0627c82579"
Archived-At: <https://www.postgresql.org/message-id/CAH%3DzU4syqG08eH7%2BMcKeVL1f%2BggfBSbpe89R0wwmfcDhk_3kiQ%40mail.gmail.com>
Precedence: bulk

--000000000000b99dda0627c82579
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Adrian,

Thank you for your response.

I don't think index corrupted as I can generate the ddl script from the
index and the index is still in use when we query.
 To rebuild the index we are still removing duplicate entries. But nothing
found in logs.

On Mon, 25 Nov, 2024, 9:30=E2=80=AFpm Adrian Klaver, <adrian.klaver@aklaver=
.com>
wrote:

> On 11/25/24 00:44, shashidhar Reddy wrote:
> > Hi Ajit,
> >
> > Thank you for your reply!
> >
> > The result of the query is same across all servers and yes streaming
> > replication does not have any issue but the question is how did
> > duplicate values entered when there unique key in place.
>
> Corrupted index?
>
> Have you tried doing a REINDEX?
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>

--000000000000b99dda0627c82579
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi Adrian,<div dir=3D"auto"><br></div><div dir=3D"auto">T=
hank you for your response.</div><div dir=3D"auto"><br></div><div dir=3D"au=
to">I don&#39;t think index corrupted as I can generate the ddl script from=
 the index and the index is still in use when we query.=C2=A0</div><div dir=
=3D"auto">=C2=A0To rebuild the index we are still removing duplicate entrie=
s. But nothing found in logs.</div></div><br><div class=3D"gmail_quote"><di=
v dir=3D"ltr" class=3D"gmail_attr">On Mon, 25 Nov, 2024, 9:30=E2=80=AFpm Ad=
rian Klaver, &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver=
@aklaver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 11/2=
5/24 00:44, shashidhar Reddy wrote:<br>
&gt; Hi Ajit,<br>
&gt; <br>
&gt; Thank you=C2=A0for your reply!<br>
&gt; <br>
&gt; The result of the query is same across all servers and yes streaming <=
br>
&gt; replication does not have any issue but the question is how did <br>
&gt; duplicate values entered when there unique key in place.<br>
<br>
Corrupted index?<br>
<br>
Have you tried doing a REINDEX?<br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank" rel=3D"noref=
errer">adrian.klaver@aklaver.com</a><br>
<br>
</blockquote></div>

--000000000000b99dda0627c82579--