Thread: More Query Cancelled Matters

More Query Cancelled Matters

From
David Rickard
Date:
PG version: 7.3.4
Server: SunOS 5.9 Generic_112233-07 sun4u sparc SUNW,Ultra-250
We're still encountering situations (vacuum, exports, certain queries & psql commands) where PostGreSQL throws a "psql: ERROR:  Query was cancelled." message;
Previous enquiries on this issue have received suggestions that something on our server may be throwing SIGINTs--but our system people cannot find anything that might be causing such events;
We are attaching our postgresql.conf file, on the off chance that someone can see some mis-set value(s) therein;

--

David Rickard
Software Engineer
The GTS Companies
A TechBooks Company

----------------------------------------------------------------------------------
The GTS Companies:
GTS Publishing Services, GTS Graphics, GTS Innova:
Your Single-Source Solution!
Los Angeles CA  *  York, PA  *  Boston MA  *  New Delhi, India
----------------------------------------------------------------------------------


David.Rickard@GTSCompanies.com
Visit us on the World Wide Web
http://www.gtscompanies.com
5650 Jillson St., Los Angeles, CA 90040
(323) 888-8889 x331
(323) 888-1849 [fax]

Attachment

Re: More Query Cancelled Matters

From
Tom Lane
Date:
David Rickard <David.Rickard@GTScompanies.com> writes:
> We're still encountering situations (vacuum, exports, certain queries &
> psql commands) where PostGreSQL throws a "psql: ERROR:  Query was
> cancelled." message;
> Previous enquiries on this issue have received suggestions that something
> on our server may be throwing SIGINTs--but our system people cannot find
> anything that might be causing such events;
> We are attaching our postgresql.conf file, on the off chance that someone
> can see some mis-set value(s) therein;

Like this one?

> statement_timeout = 120        # 0 is disabled, in milliseconds

This will trigger "Query was canceled" for any query running longer than
120 msec, which is not a lot ...

            regards, tom lane