Re: "tuple concurrently updated" in pg_restore --jobs

2020-07-11 Thread Tom Lane
Justin Pryzby writes: > On Fri, Jul 10, 2020 at 05:36:28PM -0400, Tom Lane wrote: >> I'm not sure how far to back-patch it -- I think the parallel restore >> of ACLs behavior is not very old, but we might want to teach older >> pg_dump versions to insert the extra dependency anyway, for safety. >

Re: "tuple concurrently updated" in pg_restore --jobs

2020-07-10 Thread Justin Pryzby
On Fri, Jul 10, 2020 at 05:36:28PM -0400, Tom Lane wrote: > Justin Pryzby writes: > > On Fri, Jul 10, 2020 at 04:54:40PM -0400, Tom Lane wrote: > >> This works about 99% of the time, in fact. It falls down in the --clean > > > Note that this fails for me (sometimes) even without --clean. > > Oh

Re: "tuple concurrently updated" in pg_restore --jobs

2020-07-10 Thread Tom Lane
Justin Pryzby writes: > On Fri, Jul 10, 2020 at 04:54:40PM -0400, Tom Lane wrote: >> This works about 99% of the time, in fact. It falls down in the --clean > Note that this fails for me (sometimes) even without --clean. Oh, I was thinking that REVOKE would only be issued in the --clean case, b

Re: "tuple concurrently updated" in pg_restore --jobs

2020-07-10 Thread Justin Pryzby
On Fri, Jul 10, 2020 at 04:54:40PM -0400, Tom Lane wrote: > Justin Pryzby writes: > > I hit this issue intermittently (roughly half the time) while working with a > > patch David submitted, and finally found a recipe to reproduce it on an > > unpatched v12 instance. > > > I was surprised to see p

Re: "tuple concurrently updated" in pg_restore --jobs

2020-07-10 Thread Tom Lane
Justin Pryzby writes: > I hit this issue intermittently (roughly half the time) while working with a > patch David submitted, and finally found a recipe to reproduce it on an > unpatched v12 instance. > I was surprised to see pg_restore -j2 is restoring ACLs in pre-data in > parallel. It's not p

"tuple concurrently updated" in pg_restore --jobs

2020-07-05 Thread Justin Pryzby
I hit this issue intermittently (roughly half the time) while working with a patch David submitted, and finally found a recipe to reproduce it on an unpatched v12 instance. I was surprised to see pg_restore -j2 is restoring ACLs in pre-data in parallel. Note different session IDs and PIDs: 2020-