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=search=refs%2Fheads%2FREL9_5_STABLE=commit=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.kla...@aklaver.com
Re: BUG #11141: Duplicate primary key values corruption
9.5.5 is pretty old. I'd strongly think about updating to one of the *seventeen* subsequent patch releases. https://www.postgresql.org/docs/release/9.5.22/ On 6/14/20 2: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 ? B.T.W - Looks like it happens less on Linux. Thanks Danny -- Angular momentum makes the world go 'round.
BUG #11141: Duplicate primary key values corruption
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 ? B.T.W - Looks like it happens less on Linux. Thanks Danny