Обсуждение: BUG #11141: Duplicate primary key values corruption

Поиск
Список
Период
Сортировка

BUG #11141: Duplicate primary key values corruption

От
"Abraham, Danny"
Дата:
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



Re: BUG #11141: Duplicate primary key values corruption

От
Ron
Дата:
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.

Re: BUG #11141: Duplicate primary key values corruption

От
Adrian Klaver
Дата:
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