MySql.Data.MySqlClient.MySqlException: Timeout expired

c# mysql query-optimization ibatis timeoutexception
Gopi picture Gopi · Aug 13, 2010 · Viewed 38.8k times · Source

In recent times, a particular page in my web app throws the

Exception Details: MySql.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Though I use Ibtais as persistence layer, this error occurs. I have restarted the MySql service instance but stil i get the same error. It didn't happen earlier but happens frequently in recent times.

All the web applications deployed on the server uses Ibatis and the DB server remains on the same machine where IIS is installed. There are about 8000 records in which around 300 to 500 would be filtered on page load

Any insights for the cause of the problem?

Answer

Raven picture Raven · Jul 17, 2013

I encountered the same problem with yours, and I found this MySQLConnection--Specifying default command timeout.

Just add "default command timeout=xxx" into your connectString, this key's value is in seconds.
I tried and it worked for me.

Related questions

Configuration System Failed to Initialize

I'm new to Visual Studio. I'm currently creating a Login form. I have this code. string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; try { using (OdbcConnection connect = new OdbcConnection(connectionString)) { connect.Open(); OdbcCommand cmd = new OdbcCommand("SELECT username, password FROM receptionist", connect); …

Read More
How to connect to MySQL Database?

New to C# programming, I'd like to be able to access MySQL Databases. I know MySQL connector/NET and MySQL for Visual Studio are required for C# development. Do I need to install them into my app? Is it possible …

Read More
Index (zero based) must be greater than or equal to zero

Hey I keep getting an error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. My code: OdbcCommand cmd = new OdbcCommand("SELECT FirstName, SecondName, Aboutme FROM User WHERE UserID=1", …

Read More