Hi,

On 2021-12-28 15:49:00 +0000, Jelte Fennema wrote:
> The first patch is a cleaned up version of my previous patch. I think I 
> addressed
> all feedback on the previous version in that patch (e.g. removed windows 
> code, 
> fixed formatting).

To me it seems a bit problematic to introduce a divergence between windows /
everything else here. Isn't that just going to lead to other complaints just
like this thread, where somebody discovered the hard way that there's platform
dependent behaviour here?


> The second patch is a new one, it implements honouring of the connect_timeout 
> connection option in PQcancel. This patch requires the first patch to also be 
> applied,
> but since it seemed fairly separate and the code is not trivial I didn't want 
> the first
> patch to be blocked on this.
> 
> Finally, I would love it if once these fixes are merged the would also be 
> backpatched to 
> previous versions of libpq. Does that seem possible? As far as I can tell it 
> would be fine, 
> since it doesn't really change any of the public APIs. The only change is 
> that the pg_cancel 
> struct now has a few additional fields. But since that struct is defined in 
> libpq-int.h, so that 
> struct should not be used by users of libpq directly, right?.

I'm not really convinced this is a good patch to backpatch. There does seem to
be some potential for subtle breakage - code in signal handlers is notoriously
finnicky, it's a rarely exercised code path, etc. It's also not fixing
something that previously worked.


> +      * NOTE: These socket options are currently not set for Windows. The
> +      * reason is that signal safety in this function is very important, and 
> it
> +      * was not clear to if the functions required to set the socket options 
> on
> +      * Windows were signal-safe.
> +      */
> +#ifndef WIN32
> +     if (!IS_AF_UNIX(cancel->raddr.addr.ss_family))
> +     {
> +#ifdef TCP_USER_TIMEOUT
> +             if (cancel->pgtcp_user_timeout >= 0)
> +             {
> +                     if (setsockopt(tmpsock, IPPROTO_TCP, TCP_USER_TIMEOUT,
> +                                                (char *) 
> &cancel->pgtcp_user_timeout,
> +                                                
> sizeof(cancel->pgtcp_user_timeout)) < 0)
> +                     {
> +                             strlcpy(errbuf, "PQcancel() -- 
> setsockopt(TCP_USER_TIMEOUT) failed: ", errbufsize);
> +                             goto cancel_errReturn;
> +                     }
> +             }
> +#endif
> +
> +             if (cancel->keepalives != 0)
> +             {
> +                     int                     on = 1;
> +
> +                     if (setsockopt(tmpsock,
> +                                                SOL_SOCKET, SO_KEEPALIVE,
> +                                                (char *) &on, sizeof(on)) < 
> 0)
> +                     {
> +                             strlcpy(errbuf, "PQcancel() -- 
> setsockopt(SO_KEEPALIVE) failed: ", errbufsize);
> +                             goto cancel_errReturn;
> +                     }
> +             }

This is very repetitive - how about introducing a helper function for this?



> @@ -4467,8 +4601,8 @@ retry3:
>  
>       crp.packetlen = pg_hton32((uint32) sizeof(crp));
>       crp.cp.cancelRequestCode = (MsgType) pg_hton32(CANCEL_REQUEST_CODE);
> -     crp.cp.backendPID = pg_hton32(be_pid);
> -     crp.cp.cancelAuthCode = pg_hton32(be_key);
> +     crp.cp.backendPID = pg_hton32(cancel->be_pid);
> +     crp.cp.cancelAuthCode = pg_hton32(cancel->be_key);


Others might differ, but I'd separate changing the type passed to
internal_cancel() into its own commit.


Greetings,

Andres Freund


Reply via email to