From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Claudiu Balciza <altex(at)decebal(dot)ro>, pgsql questions <pgsql-questions(at)hub(dot)org>, pgsql hackers <pgsql-hackers(at)hub(dot)org> |
Cc: | PostgreSQL Hackers Mailing List <pgsql-hackers(at)hub(dot)org> |
Subject: | RE: [QUESTIONS] FATAL: Backend cache invalidation initialisation failed |
Date: | 1998-05-08 16:03:45 |
Message-ID: | F10BB1FAF801D111829B0060971D839F276221@dal_cps.cpsgroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Forwarded to HACKERS list.
-DEJ
> -----Original Message-----
> From: altex(at)decebal(dot)ro [SMTP:altex(at)decebal(dot)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 >>
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1998-05-08 16:06:52 | RE: [QUESTIONS] initdb fail in v 6.3.2 |
Previous Message | Jackson, DeJuan | 1998-05-08 15:57:57 | RE: [QUESTIONS] Using psql \f to change delimiter to space |