Re: BUG #11141: Duplicate primary key values corruption

2020-06-14 Thread 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

Re: BUG #11141: Duplicate primary key values corruption

2020-06-14 Thread Ron
s 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

2020-06-14 Thread 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

Re: duplicate primary key

2017-11-24 Thread Michael Paquier
On Thu, Nov 23, 2017 at 1:28 AM, Alexander Pyhalov wrote: > On 11/22/17 07:24 PM, Magnus Hagander wrote: >> What is your postgres version, and what's the "version history" of >> upgrades >> from it (talking pg_upgrade upgrades, not dump/reload upgrades). This >> might >> be fallout from old bugs t

Re: duplicate primary key

2017-11-22 Thread Alexander Pyhalov
On 11/22/17 07:24 PM, Magnus Hagander wrote: What is your postgres version, and what's the "version history" of upgrades from it (talking pg_upgrade upgrades, not dump/reload upgrades). This might be fallout from old bugs thaat have been known to cause this type of problem. It's PostgreSQL 9.

Re: duplicate primary key

2017-11-22 Thread Magnus Hagander
On Wed, Nov 22, 2017 at 12:05 PM, Alexander Pyhalov wrote: > Hello. > > I'm a bit shocked. During import/export of our database we've found a > duplicate primary key. > > # \d player > > Table "public.player" >Column |

Re: duplicate primary key

2017-11-22 Thread Thomas Markus
Am 22.11.17 um 12:05 schrieb Alexander Pyhalov: Hello. I'm a bit shocked. During import/export of our database we've found a duplicate primary key. # \d player Table "public.player"    Column   |    Type |  

duplicate primary key

2017-11-22 Thread Alexander Pyhalov
Hello. I'm a bit shocked. During import/export of our database we've found a duplicate primary key. # \d player Table "public.player" Column |Type |