From patrice.beliveau@yahoo.ca Tue Dec 20 14:41:36 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D473A9DCA60 for ; Tue, 20 Dec 2005 10:41:36 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94268-01 for ; Tue, 20 Dec 2005 10:41:39 -0400 (AST) X-Greylist: delayed 00:06:38.364048 by SQLgrey- Received: from web37011.mail.mud.yahoo.com (web37011.mail.mud.yahoo.com [209.191.85.96]) by postgresql.org (Postfix) with SMTP id 4A8729DCA21 for ; Tue, 20 Dec 2005 10:41:33 -0400 (AST) Received: (qmail 79925 invoked by uid 60001); 20 Dec 2005 14:34:58 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.ca; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=2w6px3J+V4WJkvrHiVxJ4xn+WFtZ3KfM74MEE2ELcDUj844+YLaNsuRLHAqNRRFQKM5X9s9NQYlqgKrinm2gw51bMuB9Q9ys+cUXEMSIS/U1VRgmQWnjphr4/pBJuuxbVuUhFGhXtvM3HYGJlBK9Yit2XXZJRK37Xc46GeJBe0Q= ; Message-ID: <20051220143458.79923.qmail@web37011.mail.mud.yahoo.com> Received: from [209.47.34.36] by web37011.mail.mud.yahoo.com via HTTP; Tue, 20 Dec 2005 09:34:58 EST Date: Tue, 20 Dec 2005 09:34:58 -0500 (EST) From: Patrice Beliveau Subject: cache lookup failed for type To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1580910369-1135089298=:79647" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.48 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.48 X-Spam-Level: X-Archive-Number: 200512/232 X-Sequence-Number: 19952 --0-1580910369-1135089298=:79647 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I'm doing a very simple thing... creating a schema xyz; creating domain xyz.abc; (about 100) creating table xyz.def' (abour 100) then drop schema xyz cascade; after a list of NOTICE: drop cascade to type xyz.aaa . . . I got ERROR: cache lookup failed for type 12345 I thing that maybe there is(are) parameter(s) that need to be configure to give more cache to prevent this error can you help me ? --------------------------------- Lèche-vitrine ou lèche-écran ? Yahoo! Magasinage. --0-1580910369-1135089298=:79647 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
 I'm doing a very simple thing...

creating a schema xyz;

creating domain xyz.abc; (about 100)

creating table xyz.def' (abour 100)

then

drop schema xyz cascade;


after a list of
NOTICE: drop cascade to type xyz.aaa
.
.
.
I got
ERROR: cache lookup failed for type 12345

I thing that maybe there is(are) parameter(s) that need to be configure to give more cache to prevent this error

can you help me ?


Lèche-vitrine ou lèche-écran ? Yahoo! Magasinage.
--0-1580910369-1135089298=:79647-- From tgl@sss.pgh.pa.us Wed Dec 21 05:00:15 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7E3119DCBCC for ; Wed, 21 Dec 2005 01:00:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47757-01-2 for ; Wed, 21 Dec 2005 01:00:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 710C99DCBD8 for ; Wed, 21 Dec 2005 01:00:11 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jBL50AJG008987; Wed, 21 Dec 2005 00:00:10 -0500 (EST) To: Patrice Beliveau cc: pgsql-admin@postgresql.org Subject: Re: cache lookup failed for type In-reply-to: <20051220143458.79923.qmail@web37011.mail.mud.yahoo.com> References: <20051220143458.79923.qmail@web37011.mail.mud.yahoo.com> Comments: In-reply-to Patrice Beliveau message dated "Tue, 20 Dec 2005 09:34:58 -0500" Date: Wed, 21 Dec 2005 00:00:10 -0500 Message-ID: <8986.1135141210@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.026 required=5 tests=[AWL=0.026] X-Spam-Score: 0.026 X-Spam-Level: X-Archive-Number: 200512/233 X-Sequence-Number: 19953 Patrice Beliveau writes: > I got > ERROR: cache lookup failed for type 12345 Show us an *exact* procedure to reproduce this, and mention exactly which PG version you saw it on. regards, tom lane From systemguards@gmail.com Wed Dec 21 18:19:13 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5FC359DCA7C for ; Wed, 21 Dec 2005 14:19:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89997-03 for ; Wed, 21 Dec 2005 14:19:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by postgresql.org (Postfix) with ESMTP id 11B8E9DCA6F for ; Wed, 21 Dec 2005 14:19:10 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so187169wri for ; Wed, 21 Dec 2005 10:19:11 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=rOPET+IVX+Z4p8PF8VkH4p3wIId5AAmTsYBAYO1pk/qWXVZMMpF6aYar/SWeyJLxJQ/84TtG0mhyghidtrXd40lTNzWANvcjvTWf1jDloFPaQjZMQx5xpy/bEJDHCDmJU13cfGrdls5rEfI4iE1fUGRIcczyV48vKuEjm8vC8YM= Received: by 10.54.77.8 with SMTP id z8mr932170wra; Wed, 21 Dec 2005 10:18:56 -0800 (PST) Received: by 10.54.92.14 with HTTP; Wed, 21 Dec 2005 10:19:10 -0800 (PST) Message-ID: Date: Wed, 21 Dec 2005 13:19:10 -0500 From: Jaime Casanova To: Patrice Beliveau Subject: Re: cache lookup failed for type Cc: pgsql-admin@postgresql.org In-Reply-To: <20051220143458.79923.qmail@web37011.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20051220143458.79923.qmail@web37011.mail.mud.yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.085 required=5 tests=[AWL=0.085] X-Spam-Score: 0.085 X-Spam-Level: X-Archive-Number: 200512/248 X-Sequence-Number: 19968 > ERROR: cache lookup failed for type 12345 > > I thing that maybe there is(are) parameter(s) that need to be configure t= o > give more cache to prevent this error > > can you help me ? > this is not about memory... it's a bug... can you provide info about the version that you have? -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)