Re: BUG #11141: Duplicate primary key values corruption

On 6/14/20 12:17 AM, Abraham, Danny wrote:
> Hi,
> 
> PG 9.5.5 on AIX tends to compromise Primary Key and create duplicates
> when in stress and many concurrent threads updating.
> 
> Is it BUG #11141 ( Duplicate primary key values corruption ).  ?
> 
> Anyone aware of a resolution for this ?

According to the bug report:

https://git.postgresql.org/gitweb/?p=postgresql.git&a=search&h=refs%2Fheads%2FREL9_5_STABLE&st=commit&s=duplicate

This was done almost 2 years before 9.5 was released so it would have 
the fix in it. A quick check of the Git repo showed nothing that seemed 
to apply since. Then again it was a quick check. I would still take 
Ron's advice and upgrade to latest minor release. If that does not fix 
the problem then submit a bug report with a test case.



> 
> B.T.W - Looks like it happens less on Linux.
> 
> Thanks
> 
> Danny
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com