supavisor icon indicating copy to clipboard operation
supavisor copied to clipboard

feat: use simple_connection for auth_query

Open abc3 opened this issue 1 year ago • 0 comments

The PID of the Postgrex connection can be lost when ClientHandler terminates in the middle of getting secrets via auth_query. As a result, we may get zombie connections, which can consume all allowed connections to the tenant's database. With this PR, auth_query will be done with SimpleConnection, where the process crashes automatically if the caller (ClientHandler) goes down.

abc3 avatar May 27 '24 15:05 abc3