Re: Fw: PortalHeapMemoryFree error in OpenACS
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Brian Mueller" <brian@twotomatoes.com>
Cc: pgsql-bugs@postgresql.org
Date: 2000-08-12T23:25:57Z
Lists: pgsql-bugs
"Brian Mueller" <brian@twotomatoes.com> writes: > When doing a large query from either an OpenACS 3.2.2 web page (/intranet/e= > mployees/admin/index.tcl) or from psql, I get the following error:=20 > NOTICE: PortalHeapMemoryFree: 0x0x41a37610 not in alloc set! > NOTICE: PortalHeapMemoryFree: 0x0x41a37cc8 not in alloc set! > NOTICE: PortalHeapMemoryFree: 0x0x41a37ca0 not in alloc set! > ERROR: btree scan list trashed; can't find 0x0x41a37bf0 Interesting. However, I can't get excited about having to reverse-engineer your database before I can try to duplicate the problem. How about a schema dump (pg_dump -s)? Also, what query plan is shown by EXPLAIN for the problem query? regards, tom lane