Query cancelled errors

From: David Rickard <David(dot)Rickard(at)GTScompanies(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Query cancelled errors
Date: 2003-09-16 19:05:49
Message-ID: 5.2.1.1.0.20030916115815.037ab508@mail.gtscompanies.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

We have encountered numerous instances when we have encountered the
following error message:
ERROR: Query was cancelled.
Specific instances include:

Attempting an export with pg_dump:
% pg_dump -c -C -D -F t -f
/data/export/daily/CT_ADMIN~EXPORT~20030916.sql.tar CT_ADMIN
% pg_dump: query to obtain list of data types failed:
ERROR: Query was cancelled.

Doing a vacuum:
% vacuumdb -a -f -z -v
% INFO: --Relation pg_catalog.pg_conversion--
INFO: Pages 2: Changed 0, reaped 0, Empty 0, New 0; Tup 114: Vac
0, Keep/VTL 0/0, UnUsed 0, MinLen 117, MaxLen 117; Re-using: Free/Avail.
Space 2208/2096; EndEmpty/Avail. Pages 0/1.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: Index pg_conversion_default_index: Pages 2; Tuples 114.
CPU 0.00s/0.01u sec elapsed 0.00 sec.
INFO: Index pg_conversion_name_nsp_index: Pages 4; Tuples 114.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: Index pg_conversion_oid_index: Pages 2; Tuples 114.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: Rel pg_conversion: Pages: 2 --> 2; Tuple(s) moved: 0.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: Analyzing pg_catalog.pg_conversion
INFO: --Relation pg_catalog.pg_depend--
INFO: Pages 21: Changed 0, reaped 1, Empty 0, New 0; Tup 2800:
Vac 0, Keep/VTL 0/0, UnUsed 56, MinLen 49, MaxLen 49; Re-using: Free/Avail.
Space 3388/3148; EndEmpty/Avail. Pages 0/1.
CPU 0.01s/0.00u sec elapsed 0.01 sec.
INFO: Index pg_depend_depender_index: Pages 17; Tuples 2800:
Deleted 0.
CPU 0.01s/0.00u sec elapsed 0.08 sec.
INFO: Index pg_depend_reference_index: Pages 21; Tuples 2800:
Deleted 0.
CPU 0.01s/0.02u sec elapsed 0.06 sec.
ERROR: Query was cancelled.
vacuumdb: vacuum testdb failed

Getting table comments inside psql session:
CT_ADMIN=# \dd pg_conversion
ERROR: Query was cancelled.

Any ideas?

--

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(dot)Rickard(at)GTSCompanies(dot)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]

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-09-16 19:09:29 Re: Query cancelled errors
Previous Message Tom Lane 2003-09-16 18:45:54 Re: Query cancelled errors