Devart Forums

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?

Forgot to mention running version 6.70.293.0

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?

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

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