What is causing 'canceling statement due to user request' ? - Mailing list pgsql-general

From Csaba Nagy
Subject What is causing 'canceling statement due to user request' ?
Date
Msg-id 1161612878.32342.121.camel@coppola.muc.ecircle.de
Whole thread Raw
Responses Re: What is causing 'canceling statement due to user request' ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: What is causing 'canceling statement due to user request' ?  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Hi all,

I know of 2 causes:

 - hit CTRL-C in the psql client;
 - have a non-zero statement timeout and have the statement actually
time out;

But I am seeing this via JDBC which can't cancel a statement AFAIK, and
the statement_timeout is set to 0 (in the config file globally, and
there's no override for the users, nor in our JDBC code).

I wonder if there is any other scenario which can trigger this error ? I
found a lot of them in our logs, last night we had hundreds of them, but
now that I looked it happened sporadically in the past too...

Could some network problem trigger this ?

TIA,
Csaba.



pgsql-general by date:

Previous
From: "Shane Wright"
Date:
Subject: recovery from xid wraparound
Next
From: Jeff Davis
Date:
Subject: Re: strange encoding behavior