Re: Duplicate data even with primary keys enabled

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

If you used CONCURRENTLY while creating your index, there is a possibility that you hit a bug, which was fixed with 14.4.

However, if you have any indexes that were created using the CONCURRENTLY option under 14.X, you should re-index them after updating. See the first changelog entry below.

https://www.postgresql.org/docs/14/release-14-4.html


Best regards.
Samed YILDIRIM

On Sat, 29 Oct 2022, 14:21 abbas alizadeh, <ramkly@xxxxxxxxx> wrote:
Hi all.
I faced the same issue last week.
We had duplicated records on primary key.
Postgresql version is 14.4


Sent from my iPhone

> On 29 Oct 2022, at 4:18 AM, Erik Wienhold <ewie@xxxxxxxxx> wrote:
>
> 
>>
>> On 28/10/2022 22:50 CEST Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
>>
>> A corrupted index could allow that to happen by failing to catch the duplicate
>> insert. I suppose it might also be able to cause the same row to be returned
>> multiple times--although I have personally only ever seen corrupted indexes
>> cause rows to not be found.
>
> I think it should be possible to tell those two cases apart by looking at system
> column ctid.  The ctid should be the same for duplicate rows if the same row is
> found multiple times in the index.  Different ctid if the corrupted index
> allowed INSERT with duplicates.
>
> --
> Erik
>
>




[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux