✅ SQL Command Timeout does not work with async calls

Has anyone encountered the following issue? When using a sync call to the database, the command timeout parameter works, but when I'm using an async call it does not work?

See sample code below:

var connection = new MySqlConnection("***");await connection.OpenAsync();
var command = new MySqlCommand("select Count(Id) from eventlog", connection);
command.CommandTimeout = 10;

// Hits the exception at 10 second mark
var count = command.ExecuteScalar();

// Executes indefinitely
var count = await command.ExecuteScalarAsync(cancellationToken);

var connection = new MySqlConnection("***");await connection.OpenAsync();
var command = new MySqlCommand("select Count(Id) from eventlog", connection);
command.CommandTimeout = 10;

// Hits the exception at 10 second mark
var count = command.ExecuteScalar();

// Executes indefinitely
var count = await command.ExecuteScalarAsync(cancellationToken);

Removing the

CommandTimeout

CommandTimeout

, meaning using the default timeout of 30 seconds, works for sync calls but not with async calls.

I tried adding a connection timeout and it also does not work. I tried using Dapper, and it also does not work. Am I missing something or what?

C#•3y ago•

24 replies

pirrippu

✅ SQL Command Timeout does not work with async calls

Has anyone encountered the following issue? When using a sync call to the database, the command timeout parameter works, but when I'm using an async call it does not work?

See sample code below:

var connection = new MySqlConnection("***");await connection.OpenAsync();
var command = new MySqlCommand("select Count(Id) from eventlog", connection);
command.CommandTimeout = 10;

// Hits the exception at 10 second mark
var count = command.ExecuteScalar();

// Executes indefinitely
var count = await command.ExecuteScalarAsync(cancellationToken);

var connection = new MySqlConnection("***");await connection.OpenAsync();
var command = new MySqlCommand("select Count(Id) from eventlog", connection);
command.CommandTimeout = 10;

// Hits the exception at 10 second mark
var count = command.ExecuteScalar();

// Executes indefinitely
var count = await command.ExecuteScalarAsync(cancellationToken);

Removing the

CommandTimeout

CommandTimeout

✅ SQL Command Timeout does not work with async calls

✅ SQL Command Timeout does not work with async calls

Similar Threads