Re: ERROR: canceling query due to user request

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Janian" <ajanian(at)scottrade(dot)com>
Cc: "Tore Halset" <halset(at)pvv(dot)ntnu(dot)no>, pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: canceling query due to user request
Date: 2004-09-07 15:39:39
Message-ID: 1197.1094571579@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrew Janian" <ajanian(at)scottrade(dot)com> writes:
> I am experiencing a similar problem with PostgreSQL running on Debian.
> I am not doing anything special when it happens, just once and a
> while. It is not a production system (on which this problem does not
> occur) so I just restart and everything is fine.

Restart? Do you actually need to restart to make the problem stop?
If so, do you mean restarting the PG postmaster, or rebooting the whole
machine? Would maybe just starting a fresh backend (psql session) make
the problem stop?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2004-09-07 15:41:30 Re: restricting non superuser from accessing other
Previous Message Tom Lane 2004-09-07 15:29:17 Re: supressing NOTICE messages on Windows/cygwin only not working?