node-mysql2 icon indicating copy to clipboard operation
node-mysql2 copied to clipboard

Receiving "Connection lost: The server closed the connection." with createPool

Open jasonterando opened this issue 2 years ago • 2 comments

When calling execute or query from a Pool returned from createPool, I'm occasionally getting the error "Connection lost: The server closed the connection.". This error looks like it is coming from a stream close event in connection.js.

My understanding is that Pool should automatically capture this condition and recreate a connection, but that does not appear to be happening (i.e. I don't understand why I would be seeing this error when using Pool.execute or Pool.query. I'm not seeing anything in Pool.getConnection/query/execute that appear to be set up to handle a closed connection. Do I need to write my own error handling around this?

As context, I'm using this from Lambda to connect to RDSProxy, so that makes it even more fun to diagnose :)

Thanks

jasonterando avatar Oct 17 '23 12:10 jasonterando

We're also seeing similar issues between our lambdas and proxy. Except the library is saying Can't add new command when connection is in closed state...

We never explicitly close any connections in our lambdas...

ortonomy avatar Oct 20 '23 08:10 ortonomy