"NpgsqlException - ERROR: 57014: canceling statement due to user request"

[kuladee...@gmail.com]

I am using Npgsql with .Net application and it works perfectly but some
times it gives below error.

"NpgsqlException - ERROR: 57014: canceling statement due to user request"

Please can you help me for this,there is any setting or any thing that can
resolve this issue for me.

Thank in advance.

Kuldeep Singh

[Francisco Figueiredo Jr.]

On Mon, Jun 9, 2014 at 3:19 AM, <kuladee...@gmail.com> wrote:

I am using Npgsql with .Net application and it works perfectly but some
times it gives below error.

"NpgsqlException - ERROR: 57014: canceling statement due to user request"

Please can you help me for this,there is any setting or any thing that can
resolve this issue for me.

Are you getting this error when sending commands to server? If so, it is related to a too low value for the command timeout. 

If you are getting this error when connecting, you should increase your timeout value in your connection string.

You should check your queries and your server to see if you are having a high demand in pick times which may be doing your server to become slow to answer your queries and time'ing out instead. 

Please, let us know if this doesn't solve your problem so we can think about some other possibilities. 

I hope it helps.

--
Regards,

Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://gplus.to/franciscojunior
http://fxjr.blogspot.com
http://twitter.com/franciscojunior