Re: Dubugging an intermittent foreign key insert error with csvlog

2019-09-16 Thread Adrian Klaver
On 9/16/19 3:16 PM, Jeff Ross wrote: On 9/16/19 4:07 PM, Adrian Klaver wrote: On 9/16/19 1:46 PM, Jeff Ross wrote: The csvlog snip shows what I believe are 2 simultaneous but separate sessions and the session that attempts to insert into the cargo_det table is not the same session that ins

Re: Dubugging an intermittent foreign key insert error with csvlog

2019-09-16 Thread Jeff Ross
On 9/16/19 4:07 PM, Adrian Klaver wrote: On 9/16/19 1:46 PM, Jeff Ross wrote: The csvlog snip shows what I believe are 2 simultaneous but separate sessions and the session that attempts to insert into the cargo_det table is not the same session that inserted into the load_det table. That's

Re: Dubugging an intermittent foreign key insert error with csvlog

2019-09-16 Thread Adrian Klaver
On 9/16/19 1:46 PM, Jeff Ross wrote: Hi all, I've been debugging an intermittent foreign key insert error on our single database / multi-tenant server.  To help isolate traffic by tenant, I've switched to using csvlog and for the duration and have set log_min_duration_statement to 0 to get *e

Dubugging an intermittent foreign key insert error with csvlog

2019-09-16 Thread Jeff Ross
Hi all, I've been debugging an intermittent foreign key insert error on our single database / multi-tenant server. To help isolate traffic by tenant, I've switched to using csvlog and for the duration and have set log_min_duration_statement to 0 to get *everything*. Fortunately, daily 80G c