Re: [BUGS] BUG #4222: ERROR: cache lookup failed for relation

Heikki Linnakangas Thu, 05 Jun 2008 08:53:02 -0700

Please keep the list cc'd so that others can help you out.


Parag Goyal wrote:

Actually my client-server application is using default database postgres and
using 39 tables. Out of thase one table is 'eventregistration' created by
hibernate automatically.

Some how we got stuck and tried delete all the tables using 'drop-cascaded'
option of pgAdminIII. It has deleted the tables except mentioned one. Now if
we try to drop the table using query 'drop table eventregistration' -> it is
giving error as mentioned eralier.

Well, if you really want to just drop everything, you could try droppingand recreating the whole database. That doesn't explain why you got theerror, of course, so please back up by tarring or zipping up the datadirectory before you do that. We don't want to lose the evidence ifsomeone wants to investigate this further.

Did you by chance run two DROP commands at the same time from differentpgAdmin sessions? There has been some race conditions in the dependencytraversal, though I don't recall anything that would leave the databasein such a state.

It is giving same exception with any query.


Any query, even if not related to that table?

Log ->

2008-06-05 14:28:19 IST DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:19 IST DEBUG:  CommitTransaction
2008-06-05 14:28:19 IST DEBUG:  name: unnamed; blockState:       STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:19 IST DEBUG:  autovacuum: processing database "postgres"
2008-06-05 14:28:19 IST DEBUG:  StartTransaction
2008-06-05 14:28:19 IST DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:19 IST DEBUG:  pg_statistic: vac: 0 (threshold 120), anl:
348 (threshold 85)
2008-06-05 14:28:19 IST DEBUG:  pg_authid: vac: 0 (threshold 50), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_database: vac: 0 (threshold 50), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_tablespace: vac: 0 (threshold 50), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_shdepend: vac: 0 (threshold 50), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_shdescription: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_type: vac: 111 (threshold 127), anl: 0
(threshold 88)
2008-06-05 14:28:19 IST DEBUG:  pg_attribute: vac: 0 (threshold 409), anl: 0
(threshold 230)
2008-06-05 14:28:19 IST DEBUG:  pg_proc: vac: 0 (threshold 479), anl: 0
(threshold 264)
2008-06-05 14:28:19 IST DEBUG:  pg_class: vac: 0 (threshold 96), anl: 0
(threshold 73)
2008-06-05 14:28:19 IST DEBUG:  pg_attrdef: vac: 24 (threshold 55), anl: 0
(threshold 52)
2008-06-05 14:28:19 IST DEBUG:  pg_constraint: vac: 0 (threshold 51), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_index: vac: 0 (threshold 68), anl: 0
(threshold 59)
2008-06-05 14:28:19 IST DEBUG:  pg_operator: vac: 0 (threshold 190), anl: 0
(threshold 120)
2008-06-05 14:28:19 IST DEBUG:  pg_opclass: vac: 0 (threshold 72), anl: 0
(threshold 61)
2008-06-05 14:28:19 IST DEBUG:  pg_am: vac: 0 (threshold 51), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_amop: vac: 0 (threshold 119), anl: 0
(threshold 85)
2008-06-05 14:28:19 IST DEBUG:  pg_amproc: vac: 0 (threshold 99), anl: 0
(threshold 74)
2008-06-05 14:28:19 IST DEBUG:  pg_language: vac: 0 (threshold 51), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_aggregate: vac: 0 (threshold 73), anl: 0
(threshold 62)
2008-06-05 14:28:19 IST DEBUG:  pg_rewrite: vac: 0 (threshold 65), anl: 0
(threshold 58)
2008-06-05 14:28:19 IST DEBUG:  pg_trigger: vac: 0 (threshold 51), anl: 0
(threshold 51)
2008-06-05 14:28:19 IST DEBUG:  pg_description: vac: 0 (threshold 451), anl:
0 (threshold 251)
2008-06-05 14:28:19 IST DEBUG:  pg_cast: vac: 0 (threshold 88), anl: 0
(threshold 69)
2008-06-05 14:28:19 IST DEBUG:  pg_namespace: vac: 0 (threshold 51), anl: 0
(threshold 51)
2008-06-05 14:28:19 IST DEBUG:  pg_depend: vac: 1199 (threshold 1236), anl:
0 (threshold 643)
2008-06-05 14:28:19 IST DEBUG:  eventregistration: vac: 4 (threshold 50),
anl: 4 (threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_toast_630151: vac: 0 (threshold 50), anl:
0 (threshold 50)
2008-06-05 14:28:19 IST DEBUG:  CommitTransaction
2008-06-05 14:28:19 IST DEBUG:  name: unnamed; blockState:       STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:19 IST DEBUG:  proc_exit(0)
2008-06-05 14:28:19 IST DEBUG:  shmem_exit(0)
2008-06-05 14:28:19 IST DEBUG:  exit(0)
2008-06-05 14:28:19 IST DEBUG:  reaping dead processes
2008-06-05 14:28:19 IST DEBUG:  server process (PID 3224) exited with exit
code 0
2008-06-05 14:28:58 IST DEBUG:  StartTransactionCommand
2008-06-05 14:28:58 IST DEBUG:  StartTransaction
2008-06-05 14:28:58 IST DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:58 IST DEBUG:  ProcessUtility
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to toast table
pg_toast.pg_toast_630151
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to type
pg_toast.pg_toast_630151
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to index
pg_toast.pg_toast_630151_index
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to type eventregistration
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to type
eventregistration[]
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to constraint
eventregistration_pkey on table eventregistration
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to index
eventregistration_pkey
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to constraint
fk490d8536643b1db on table eventregistration
2008-06-05 14:28:58 IST ERROR:  cache lookup failed for relation 630146
2008-06-05 14:28:58 IST STATEMENT:  drop table eventregistration;



2008-06-05 14:28:19 IST DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:19 IST DEBUG:  CommitTransaction
2008-06-05 14:28:19 IST DEBUG:  name: unnamed; blockState:       STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:19 IST DEBUG:  autovacuum: processing database "postgres"
2008-06-05 14:28:19 IST DEBUG:  StartTransaction
2008-06-05 14:28:19 IST DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:19 IST DEBUG:  pg_statistic: vac: 0 (threshold 120), anl:
348 (threshold 85)
2008-06-05 14:28:19 IST DEBUG:  pg_authid: vac: 0 (threshold 50), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_database: vac: 0 (threshold 50), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_tablespace: vac: 0 (threshold 50), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_shdepend: vac: 0 (threshold 50), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_shdescription: vac: 0 (threshold 50),
anl: 0 (threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_type: vac: 111 (threshold 127), anl: 0
(threshold 88)
2008-06-05 14:28:19 IST DEBUG:  pg_attribute: vac: 0 (threshold 409), anl: 0
(threshold 230)
2008-06-05 14:28:19 IST DEBUG:  pg_proc: vac: 0 (threshold 479), anl: 0
(threshold 264)
2008-06-05 14:28:19 IST DEBUG:  pg_class: vac: 0 (threshold 96), anl: 0
(threshold 73)
2008-06-05 14:28:19 IST DEBUG:  pg_attrdef: vac: 24 (threshold 55), anl: 0
(threshold 52)
2008-06-05 14:28:19 IST DEBUG:  pg_constraint: vac: 0 (threshold 51), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_index: vac: 0 (threshold 68), anl: 0
(threshold 59)
2008-06-05 14:28:19 IST DEBUG:  pg_operator: vac: 0 (threshold 190), anl: 0
(threshold 120)
2008-06-05 14:28:19 IST DEBUG:  pg_opclass: vac: 0 (threshold 72), anl: 0
(threshold 61)
2008-06-05 14:28:19 IST DEBUG:  pg_am: vac: 0 (threshold 51), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_amop: vac: 0 (threshold 119), anl: 0
(threshold 85)
2008-06-05 14:28:19 IST DEBUG:  pg_amproc: vac: 0 (threshold 99), anl: 0
(threshold 74)
2008-06-05 14:28:19 IST DEBUG:  pg_language: vac: 0 (threshold 51), anl: 0
(threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_aggregate: vac: 0 (threshold 73), anl: 0
(threshold 62)
2008-06-05 14:28:19 IST DEBUG:  pg_rewrite: vac: 0 (threshold 65), anl: 0
(threshold 58)
2008-06-05 14:28:19 IST DEBUG:  pg_trigger: vac: 0 (threshold 51), anl: 0
(threshold 51)
2008-06-05 14:28:19 IST DEBUG:  pg_description: vac: 0 (threshold 451), anl:
0 (threshold 251)
2008-06-05 14:28:19 IST DEBUG:  pg_cast: vac: 0 (threshold 88), anl: 0
(threshold 69)
2008-06-05 14:28:19 IST DEBUG:  pg_namespace: vac: 0 (threshold 51), anl: 0
(threshold 51)
2008-06-05 14:28:19 IST DEBUG:  pg_depend: vac: 1199 (threshold 1236), anl:
0 (threshold 643)
2008-06-05 14:28:19 IST DEBUG:  eventregistration: vac: 4 (threshold 50),
anl: 4 (threshold 50)
2008-06-05 14:28:19 IST DEBUG:  pg_toast_630151: vac: 0 (threshold 50), anl:
0 (threshold 50)
2008-06-05 14:28:19 IST DEBUG:  CommitTransaction
2008-06-05 14:28:19 IST DEBUG:  name: unnamed; blockState:       STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:19 IST DEBUG:  proc_exit(0)
2008-06-05 14:28:19 IST DEBUG:  shmem_exit(0)
2008-06-05 14:28:19 IST DEBUG:  exit(0)
2008-06-05 14:28:19 IST DEBUG:  reaping dead processes
2008-06-05 14:28:19 IST DEBUG:  server process (PID 3224) exited with exit
code 0
2008-06-05 14:28:58 IST DEBUG:  StartTransactionCommand
2008-06-05 14:28:58 IST DEBUG:  StartTransaction
2008-06-05 14:28:58 IST DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: <>
2008-06-05 14:28:58 IST DEBUG:  ProcessUtility
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to toast table
pg_toast.pg_toast_630151
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to type
pg_toast.pg_toast_630151
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to index
pg_toast.pg_toast_630151_index
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to type eventregistration
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to type
eventregistration[]
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to constraint
eventregistration_pkey on table eventregistration
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to index
eventregistration_pkey
2008-06-05 14:28:58 IST DEBUG:  drop auto-cascades to constraint
fk490d8536643b1db on table eventregistration
2008-06-05 14:28:58 IST ERROR:  cache lookup failed for relation 630146
2008-06-05 14:28:58 IST STATEMENT:  drop table eventregistration;


--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #4222: ERROR: cache lookup failed for relation

Reply via email to