Обсуждение: More Query Cancelled Matters
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;
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]
Вложения
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