Received: from www-uk-05.digiserve.com ([195.97.231.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2EGYSx37550 for ; Wed, 14 Mar 2001 11:34:28 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id QAA23254; Wed, 14 Mar 2001 16:35:12 GMT Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 990C02A684; Wed, 14 Mar 2001 16:27:02 +0000 (GMT) Message-ID: <005601c0aca3$98ca10c0$1001a8c0@archonet.com> From: "Richard Huxton" To: "Alexaki Sofia" , References: Subject: Re: Date: Wed, 14 Mar 2001 16:26:59 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200103/278 X-Sequence-Number: 1939 From: "Alexaki Sofia" > I execute the following query > select * from test1 where fromuri like 'http://ww%'; > > I get the following message > NOTICE: PortalHeapMemoryFree: 0x16563a8 not in alloc set! > ERROR: AllocSetFree: cannot find block containing chunk It's complaining that memory it tries to free hasn't been allocated. Something has got mangled here. I'd take a backup of the table drop the index and recreate it, see if that helps. Also - what version of Postgres is this? One of the developers might recognise a known bug if it isn't current. - Richard Huxton > This is a bit strange taking into account that the total size > of database buffers I have defined is 80Mb > > Thanks in advance for your help > Sofia Alexaki > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl >