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 network outage for testing, so maybe in that case the connection never realizes it is no longer connected, unlike the things I tried.
Could you run your program with db logging at the debug level (eg, set the environment variable PLTSTDERR to "debug@db error") and also add `#:debug? #t` to your call to `postgresql-connect` and see what gets logged/printed before the hang occurs? (You may want to redact the output.) Ryan On Fri, Jul 3, 2020 at 5:07 PM Curtis Dutton <curtd...@gmail.com> wrote: > 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 <curtd...@gmail.com> wrote: > >> I'm in the process of writing a simple daemon that periodically checks in >> with a postgres database. I'm trying to make it resilient with network >> outages. >> >> >> If you connect to the database. >> Unplug the network cable. >> Run a query. >> >> The query will hang for what appears to be forever without throwing an >> exception. >> >> Is this expected behavior? >> >> >> Thanks, >> Curtis >> > -- > You received this message because you are subscribed to the Google Groups > "Racket Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to racket-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/racket-users/CAPChLEqzeN3FjhD59tTHUf3EFgW8Bo0xi_3e3Va5kPg2Ut7miA%40mail.gmail.com > <https://groups.google.com/d/msgid/racket-users/CAPChLEqzeN3FjhD59tTHUf3EFgW8Bo0xi_3e3Va5kPg2Ut7miA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Racket Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to racket-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/racket-users/CANy33qkN3tUxav9xkVnnWrA9Hd1K9JBhOdwAzSxJgDmDXtVkeg%40mail.gmail.com.
