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?