Query cancelled errors - Mailing list pgsql-novice

From David Rickard
Subject Query cancelled errors
Date
Msg-id 5.2.1.1.0.20030916115815.037ab508@mail.gtscompanies.com
Whole thread Raw
Responses Re: Query cancelled errors
List 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.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]

pgsql-novice by date:

Previous
From: "M. Bastin"
Date:
Subject: Re: [ANN] Eduphant
Next
From: Tom Lane
Date:
Subject: Re: Query cancelled errors