Thank you Adrian. We replicated the issue with OS upgrade.
On Tue, 26 Nov, 2024, 11:06 am Adrian Klaver, <adrian.kla...@aklaver.com> wrote: > On 11/25/24 19:07, shashidhar Reddy wrote: > > Hi Adrian, > > > > Thank you for your response. > > > > I don't think index corrupted as I can generate the ddl script from the > > What DDL script? > > > index and the index is still in use when we query. > > See Tom Lanes post for more detail. Short version the index will still > 'work' except for the part where it lets in duplicate entries. > > > To rebuild the index we are still removing duplicate entries. But > > nothing found in logs. > > > > On Mon, 25 Nov, 2024, 9:30 pm Adrian Klaver, <adrian.kla...@aklaver.com > > <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > >
