Search code examples
c#mysqlconnection-timeout

MySqlException: Timeout expired - Increasing Connection Timeout Has Had No Effect

I have a query that is taking longer to execute as the database increases in size. The query is optimized and necessary, but my C# Console Application has recently been giving me this error:

Unhandled Exception: MySql.Data.MySqlClient.MySqlException: Timeout expired.

Increasing the connection time out in the connection string doesn't help; I increased it from

Connect Timeout=28800

to

Connect Timeout=128800

but I'm still getting the error despite this change.

If I run the query from MySQL workbench it only take about 10 seconds, so I'm not sure how to prevent this Unhandled Exception.

Are there other things, besides "the time a query takes", that can produce this exception?

Solution

  • I've had this problem before. ConnectTimeout property only applies to time outs that occur when connecting to the database, not for queries.

    CommandTimeout however specifies how long it should wait for the query to return. I believe the default is 30 seconds. Double check the documentation for your MySql library, but for SqlCommand the CommandTimeout is in Seconds not milliseconds.