Problem with 6.3.2

From: Michael Meskes <meskes(at)usa(dot)net>
To: PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: Problem with 6.3.2
Date: 1998-11-21 16:00:33
Message-ID: 19981121170033.A1551@usa.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was just told in a completely different subject that someone has problems
with 6.3.2 running wild.

They use PHP and have many persistant connections. Sometimes the following
messages pop up:

NOTICE: PortalHeapMemoryFree: 0x81c98e0 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x81c98b0 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x81c9428 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x81c93f8 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x81c9140 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x81c1620 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x81c9620 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x81c9550 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x81c8de0 not in alloc set!
NOTICE: PortalHeapMemoryFree: 0x81c8dc0 not in alloc set!
NOTICE: SIAssignBackendId: discarding tag 2147475715
FATAL 1: Backend cache invalidation initialization failed
NOTICE: SIAssignBackendId: discarding tag 2147475715
FATAL 1: Backend cache invalidation initialization failed
NOTICE: SIAssignBackendId: discarding tag 2147475715

Without ipcclean there is no way to re-start the postmaster after this.

At some point (not always though) some postgres processes start eating the
com,plete CPU time. The load goes up way too high so that watchdog kicks in,
which is the reason why I heard about this.

Does this ring a bell for anyone?

Michael

--
Dr. Michael Meskes, Manager of the Western Branch Office, Datenrevision GmbH
work: Cuxhavener Str. 36, D-21149 Hamburg
home: Th.-Heuss-Str. 61, D-41812 Erkelenz, Michael(dot)Meskes(at)usa(dot)net
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

Browse pgsql-hackers by date

  From Date Subject
Next Message Hui Chun Kit, Jacky 1998-11-21 18:32:33 Questions on using multi-byte character in a field of a table (BIG5)
Previous Message Peter T Mount 1998-11-21 12:29:35 Re: [HACKERS] Solaris 7