EF Core 3.1 database connection cannot recover

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
pergardebrink
Posts: 6
Joined: Mon 02 Jul 2018 08:26

EF Core 3.1 database connection cannot recover

Post by pergardebrink » Tue 25 Feb 2020 15:52

Hi,

I have a problem in which Devart seems to be unable to recover from a faulty state when the underlying issue is resolved. I have provided a sample where I see this behaviour and wondering if I'm doing something wrong or if it's a problem in the Devart driver.

Sample project: https://1drv.ms/u/s!AqygmiqDj6CNipIuXsk ... w?e=IIMEgI

Steps to reproduce
  • Create database from database.sql
  • Replace Licensekey, username, password etc in Program.cs in both projects
  • Set the maxconnections in ConnectionEater to the max connections the db supports + 1 (to make sure all are taken)
  • Run ConnectionEater and let it stay at having all connections
  • Run DevartEFCore and wait until it fails with "Too many connections"
  • Press a key in ConnectionEater to release all connections
Expected result
DevartEFCore should now be able to get a connection and get the contents of the database

Actual result
DevartEFCore continues to show "Too many connections" even though there should be connections available (verify by restarting application)

Shalex
Site Admin
Posts: 9103
Joined: Thu 14 Aug 2008 12:44

Re: EF Core 3.1 database connection cannot recover

Post by Shalex » Wed 04 Mar 2020 20:55

Thank you for your report. We have reproduced the issue and are investigating it. We will notify you about the result.

Post Reply