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: 8
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: 9301
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.

pergardebrink
Posts: 8
Joined: Mon 02 Jul 2018 08:26

Re: EF Core 3.1 database connection cannot recover

Post by pergardebrink » Thu 16 Apr 2020 12:37

Have you been able to find a solution to the problem and/or do you know when it could be available in a new version?

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

Re: EF Core 3.1 database connection cannot recover

Post by Shalex » Fri 17 Apr 2020 18:03

The investigation is in progress. As soon as we have any results, we will notify you.

pergardebrink
Posts: 8
Joined: Mon 02 Jul 2018 08:26

Re: EF Core 3.1 database connection cannot recover

Post by pergardebrink » Mon 15 Jun 2020 13:57

Any updates on this? Or do you have any kind of workaround we could apply in order to avoid it?

It has hit us a few times now and we need to restart applications to recover from this error..

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

Re: EF Core 3.1 database connection cannot recover

Post by Shalex » Mon 20 Jul 2020 19:42

There is no timeframe at the moment. We will notify you about the progress.

pergardebrink
Posts: 8
Joined: Mon 02 Jul 2018 08:26

Re: EF Core 3.1 database connection cannot recover

Post by pergardebrink » Tue 24 Nov 2020 09:23

Hi,

it's been quite a while now and this bug is still causing issues for us. When can we expect a fix?

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

Re: EF Core 3.1 database connection cannot recover

Post by Shalex » Mon 14 Dec 2020 13:52

We are working on the issue to find a solution. We will contact you ASAP.

Post Reply