Re: [racket-users] Re: DB hangs with postgres and broken network link

2020-07-03 Thread James Platt
I wonder if this is a more general TCP/IP issue rather than anything Postgres specific. I'm troubleshooting an issue where a TCP connection to a server is unexpectedly going down, once in a while, with no obvious indication. The solution, for now, is to have the client send a sort of ping over

Re: [racket-users] Re: DB hangs with postgres and broken network link

2020-07-03 Thread Ryan Culpepper
Hi Curtis, thanks for the report. No, that isn't supposed to happen. I haven't managed to reproduce a silent hang, and looking over the virtual-connection code it looks like any errors (eg, TCP timeout) should be propagated to the caller. On the other hand, I don't have a way of simulating a networ

[racket-users] Re: DB hangs with postgres and broken network link

2020-07-03 Thread Curtis Dutton
Ok well on additional investigation this appears only to happen while using virtual connections. If a raw postgresql-connect is used it does raise a tcp timeout error. On Fri, Jul 3, 2020 at 10:51 AM Curtis Dutton wrote: > I'm in the process of writing a simple daemon that periodically checks in