connection must be open

[alain.maisonneuve]

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]

Forgot to mention running version 6.70.293.0

[Shalex]

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?

[alain.maisonneuve]

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..

[Shalex]

We will investigate the issue and post here about the results.