On Mon, May 24, 2021 at 02:07:12PM -0400, Alvaro Herrera wrote: > I suppose a fix would imply that the error report waits until after the > "cancel" step is over, but I'm not sure how to do that. > > Maybe we can change the "cancel" query to something like > > SELECT pg_cancel_backend(pid), somehow_wait_for_detach_to_terminate() FROM > d3_pid; > > ... where maybe that function can check the "state" column in s3's > pg_stat_activity row? I'll give that a try.
Couldn't you achieve that with a small PL function in a way similar to what 32a9c0b did, except that you track a different state in pg_stat_activity for this PID? -- Michael
signature.asc
Description: PGP signature
