What is causing 'canceling statement due to user request' ?

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: What is causing 'canceling statement due to user request' ?
Date: 2006-10-23 14:14:38
Message-ID: 1161612878.32342.121.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2006-10-23 14:34:14 Fw: [ANNOUNCE] == PostgreSQL Weekly News - October 22 2006 ==
Previous Message Wes Sheldahl 2006-10-23 13:54:11 Re: performace review