Re: PKEY getting corrupted

2020-09-10 Thread Alvaro Herrera
Danny, On 2020-Sep-10, Abraham, Danny wrote: > We have seen several times a situation where a PKEY is compromised and > duplicate values are created within a table. Yeah, this is not unheard of. > This has happened so far on PG 928 on Linux and Windows, and also on > PG955 on AIX. You do reali

Re: PKEY getting corrupted

2020-09-10 Thread Adrian Klaver
On 9/10/20 3:43 AM, Abraham, Danny wrote: Hi, We have seen several times a situation where a PKEY is compromised and duplicate values are created within a table. Table definition? The situation is? Postgres log entries from the error? This has happened so far on PG 928 on Linux and Windo

Re: PKEY getting corrupted

2020-09-10 Thread Philip Semanchuk
> On Sep 10, 2020, at 6:43 AM, Abraham, Danny wrote: > > Hi, > > We have seen several times a situation where a PKEY is compromised and > duplicate values are created within a table. > > This has happened so far on PG 928 on Linux and Windows, and also on PG955 on > AIX. > > We ran massiv

PKEY getting corrupted

2020-09-10 Thread Abraham, Danny
Hi, We have seen several times a situation where a PKEY is compromised and duplicate values are created within a table. This has happened so far on PG 928 on Linux and Windows, and also on PG955 on AIX. We ran massive test on PG10.4 but it has not recreated the problem. Has anyone faced the s