Code: Select all
Devart.Data.PostgreSql.PgSqlException: canceling statement due to user request
at Devart.Data.PostgreSql.PgSqlDataReader.e(Int32 A_0)
at Devart.Data.PostgreSql.PgSqlCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at Devart.Common.DbCommandBase.ExecuteNonQuery()
I ran my code again minutes later against the same data and all update queries worked ok.
I have the postgres server and client application running on the same machine. Windows xp pro sp3, C#, .net 3.5. The connection string to the server uses my computers name.
Any thoughts on what this error means and what I can do to avoid it?
Also, a rollback does not work in this situation - does the transaction still get committed? - what is the best way to handle this?