Обсуждение: 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
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/
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.
Angular momentum makes the world go 'round.
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