connection must be open

connection must be open

Postby alain.maisonneuve » Wed 05 Sep 2012 16:51

I have a system setup that loads an larget series of data into a table, then have another application that does analystic on this data set.

Infrastucture:

Window 2008 R2 (Application Server, IIS)
Debian 6 (Percona Mysql running Innodb tables)

Data we are talking 800M rows of data.


The .Net Appliation will randomly crap out with the following "connection must be open"

I was wondering if it had to do with the exception that was happening for the Postgress version that you guys fixed a few builds back.

thoughts?
alain.maisonneuve
 
Posts: 3
Joined: Wed 05 Sep 2012 16:42

Re: connection must be open

Postby alain.maisonneuve » Wed 05 Sep 2012 16:52

Forgot to mention running version 6.70.293.0
alain.maisonneuve
 
Posts: 3
Joined: Wed 05 Sep 2012 16:42

Re: connection must be open

Postby Shalex » Fri 07 Sep 2012 16:51

alain.maisonneuve wrote:I was wondering if it had to do with the exception that was happening for the Postgress version that you guys fixed a few builds back.

This error was generated in dotConnect for PostgreSQL when trying to commit/roll back transaction after expiration of command timeout.

Try increasing the MySqlCommand.CommandTimeout value (zero value specifies that the wait time is unlimited), does it help?
Shalex
Devart Team
 
Posts: 7401
Joined: Thu 14 Aug 2008 12:44

Re: connection must be open

Postby alain.maisonneuve » Wed 12 Sep 2012 13:37

This error is also generated in dotconnect for MySQL.

Now i have set the value to 0 and it does help, but by no means does the issue go away..
alain.maisonneuve
 
Posts: 3
Joined: Wed 05 Sep 2012 16:42

Re: connection must be open

Postby Shalex » Thu 13 Sep 2012 12:40

We will investigate the issue and post here about the results.
Shalex
Devart Team
 
Posts: 7401
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL