Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Mon, 23 Oct 2006 16:14:38 +0200
  • Message-id: <1161612878(dot)32342(dot)121(dot)camel(at)coppola(dot)muc(dot)ecircle(dot)de>

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.





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group