If pgbouncer dies, then the connection may get stuck in `PQsocket() can't get
socket descriptor` state. Wrap the query in a transaction to allow the
connection to return to the pool and recover. This also potentially prevents
idle-in-transaction cancellations.

Closes #5145