RE: [QUESTIONS] FATAL: Backend cache invalidation initialisation failed

-----Original Message-----
From: altex@decebal.ro [SMTP:altex@decebal.ro]
Sent: Wednesday, May 06, 1998 1:34 AM
To: pgsql questions; pgsql hackers
Subject: [QUESTIONS] FATAL: Backend cache invalidation
initialisation failed

On a Digital dual PII/32MB RAM/8GB SCSI
running the same query 45 times I get:

May 6 09:16:27 digital logger: NOTICE: SIAssignBackendId: discarding
tag
2147483646
May 6 09:16:27 digital logger: FATAL 1: Backend cache invalidation
initialization failed
..................
May 6 09:16:40 digital logger: FATAL 1: Backend cache invalidation
initialization failed
May 6 09:17:09 digital PAM_pwdb[397]: (login) session opened for user
root
by (uid=0)
May 6 09:17:09 digital PAM_pwdb[397]: ROOT LOGIN ON tty4
May 6 09:21:41 digital logger: NOTICE: LockRelease: find xid, table
corrupted
May 6 09:23:09 digital logger: NOTICE: Message from PostgreSQL
backend:
May 6 09:23:09 digital logger: ^IThe Postmaster has informed me that
some
other backend died abnormally and possibly corrupted shared memory.
May 6 09:23:09 digital logger: ^II have rolled back the current
transaction
and am going to terminate your database system connection and exit.
May 6 09:23:09 digital logger: ^IPlease reconnect to the database
system
and repeat your query.

This kills my sistem.
Increasing the memory to 96MB didn't work it out.
In real life I expect more than 45 queries simultaneously.

What can I do ?

TIA
Claudiu << File: pg-log >>