search

FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
152 stars 63 forks source link

Connection shutdown connection should not go back to pool #1097

Open cincuranet opened 1 year ago

cincuranet commented 1 year ago

When connection is closed from server-side (connection shutdown response, from i.e. DELETE FROM MON$ATTACHMENTS WHERE MON$ATTACHMENT_ID<>CURRENT_CONNECTION), the socket is no longer usable, yet the code puts the connection back to the pool (no IO problem happened yet). This means the connection will get back to application and application will for sure have to use retry logic to get new connection and continue doing what it was doing. Not a deal-breaker as retry logic should be there anyway, but it should be handled more pro-actively.

Taken from #1095.

cincuranet commented 1 year ago

cc @luronumen

mrjohnr commented 1 year ago

hi, any news about this issue? thanks

cincuranet commented 1 year ago

Nope.

mrjohnr commented 1 year ago

is that project abandoned ?no bugs fixed for a while, no Net 7 version, in about four moths Net 8 will be released and I'm still on Net 3.1(reached end of life/no longer supported) :(

cincuranet commented 1 year ago

You're more than welcome to select a bug and fix it.

What from .NET 7 you need in provider (maybe better to continue in mailing list, instead of polluting this issue)? BTW EF7 is happening here, depending on my free time.