Can not quit pgcli if server has shutdown #1467

Activity

1. j-bennet

   added

   bug

   on Jun 27, 2024
2. Zverik commented on Aug 15, 2025

   

   Zverik

   on Aug 15, 2025

   More actions

   Looks like this bug happens even when there are any kinds of network errors. Why do we need a connection to quit?

   I'm connecting to a database behind a VPN, so this one time I allowed VPN to expire, losing the connection. So I stepped in this bug:

   sync> select count(*) from segments;
   consuming input failed: could not receive data from server: Can't assign requested address
   SSL SYSCALL error: Can't assign requested address
   Time: 55.661s (55 seconds), executed in: 55.660s (55 seconds)
   
   sync> select count(*) from segments;
   sending query failed: could not receive data from server: Can't assign requested address
   SSL SYSCALL error: Can't assign requested address
   another command is already in progress
   Time: 0.002s
   
   sync> select count(*) from segments;
   sending query failed: could not receive data from server: Can't assign requested address
   SSL SYSCALL error: Can't assign requested address
   another command is already in progress
   another command is already in progress
   Time: 0.002s
   
   sync> \q
   A transaction is ongoing. Choose `c` to COMMIT, `r` to ROLLBACK, `a` to abort exit. [a]: ^[[A
   A transaction is ongoing. Choose `c` to COMMIT, `r` to ROLLBACK, `a` to abort exit. [a]: r
   sending query failed: could not receive data from server: Can't assign requested address
   SSL SYSCALL error: Can't assign requested address
   another command is already in progress
   another command is already in progress
   another command is already in progress
   Time: 0.006s
   
   sync> select count(*) from segments;
   sending query failed: could not receive data from server: Can't assign requested address
   SSL SYSCALL error: Can't assign requested address
   another command is already in progress
   another command is already in progress
   another command is already in progress
   another command is already in progress
   Time: 0.001s
   
   sync> \q
   A transaction is ongoing. Choose `c` to COMMIT, `r` to ROLLBACK, `a` to abort exit. [a]: r
   sending query failed: could not receive data from server: Can't assign requested address
   SSL SYSCALL error: Can't assign requested address
   another command is already in progress
   another command is already in progress
   another command is already in progress
   another command is already in progress
   another command is already in progress
   Time: 0.003s
   
   sync> \q
   A transaction is ongoing. Choose `c` to COMMIT, `r` to ROLLBACK, `a` to abort exit. [a]: r
   sending query failed: could not receive data from server: Can't assign requested address
   SSL SYSCALL error: Can't assign requested address
   another command is already in progress
   another command is already in progress
   another command is already in progress
   another command is already in progress
   another command is already in progress
   another command is already in progress
   Time: 0.002s
   

   All three options(c, r, a) lead to the same result.
3. j-bennet

   closed this as completedin #1573on May 12, 2026