FATAL: Backend cache invalidation initialisation failed

Started by Claudiu Balcizaabout 28 years ago1 messageshackers
Jump to latest
#1Claudiu Balciza
altex@decebal.ro

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

Attachments:

pg-logapplication/octet-stream; name=pg-logDownload