FATAL: Backend cache invalidation initialisation failed

From: altex(at)decebal(dot)ro
To: "pgsql questions" <pgsql-questions(at)hub(dot)org>, "pgsql hackers" <pgsql-hackers(at)hub(dot)org>
Subject: FATAL: Backend cache invalidation initialisation failed
Date: 1998-05-06 06:33:43
Message-ID: 01bd78b8$e9f36540$0300010a@claudiu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
pg-log application/octet-stream 16.5 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 1998-05-06 07:08:38 Re: [HACKERS] OK to send e-mail?
Previous Message Brett McCormickS 1998-05-06 06:08:32 non-functional update notice unneccesarily