Page 1 of 1

EF Core 3.1 database connection cannot recover

Posted: Tue 25 Feb 2020 15:52
by pergardebrink
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)

Re: EF Core 3.1 database connection cannot recover

Posted: Wed 04 Mar 2020 20:55
by Shalex
Thank you for your report. We have reproduced the issue and are investigating it. We will notify you about the result.

Re: EF Core 3.1 database connection cannot recover

Posted: Thu 16 Apr 2020 12:37
by pergardebrink
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?

Re: EF Core 3.1 database connection cannot recover

Posted: Fri 17 Apr 2020 18:03
by Shalex
The investigation is in progress. As soon as we have any results, we will notify you.

Re: EF Core 3.1 database connection cannot recover

Posted: Mon 15 Jun 2020 13:57
by pergardebrink
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..

Re: EF Core 3.1 database connection cannot recover

Posted: Mon 20 Jul 2020 19:42
by Shalex
There is no timeframe at the moment. We will notify you about the progress.

Re: EF Core 3.1 database connection cannot recover

Posted: Tue 24 Nov 2020 09:23
by pergardebrink
Hi,

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

Re: EF Core 3.1 database connection cannot recover

Posted: Mon 14 Dec 2020 13:52
by Shalex
We are working on the issue to find a solution. We will contact you ASAP.