Please help with these error messages

From: "V Krishnaraj" <kimi(at)intercept(dot)co(dot)in>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Please help with these error messages
Date: 1999-12-09 20:22:07
Message-ID: 199912090945.CAA13551@intercept-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Community need your help once again:

We are running on one installation 2 databases: one for tracking
any activity on a site another for serving out ads based on certain
targeting parameters.

The OS is Linux and the Web Server is Apache

We keep getting around 5-7 requests / sec and activity involves
continuous read and writes into the databases.

Now for some unknown reasons ( I mean unknown to us !!!)
postmaster keeps shutting off..We worked on it for a while and
found one apparent reason to be corrupted data being written...we
rectified that..and now we find that postgres shuts itself off with the
following error messages:

=====

IpcMemoryCreate: shmget failed (Identifier removed) key=5432010,
size=120, permi
ssion=700
IpcMemoryIdGet: shmget failed (Identifier removed) key=5432010,
size=120, permis
sion=0
IpcMemoryAttach: shmat failed (Invalid argument) id=-2
FATAL 1: AttachSLockMemory: could not attach segment

=====

On another occasion we got the following error message:

SISegmentGet: failed: Identifier removed
FATAL 1: CreateSharedInvalidationState: failed segment init
ERROR: cannot open segment 1 of relation sessions_index1
NOTICE: LockReleaseAll: xid table corrupted

FATAL: s_lock(4017aaa4) at bufmgr.c:665, stuck spinlock.
Aborting.

FATAL: s_lock(4000b011) at spin.c:125, stuck spinlock. Aborting.
NOTICE: LockReleaseAll: xid loop detected, giving up
pq_flush: send() failed: Bad file descriptor

=====

Please help.

Also, I wanted to have a quick check on using Postgresql. We are
planning to use it as a large scale adserver where one installation
could need to handle about 75 requests per second on a 24 / 7
basis. This means picking parameters from an HTTP requests
making 5 SELECTS, 25 reads and 5 writes...concurrency issues
already taken care off.

Thanks for taking time off to write to this one.

Kimi

Browse pgsql-general by date

  From Date Subject
Next Message Peter Bojanic 1999-12-09 20:26:09 Problems with pg_dump
Previous Message kaiq 1999-12-09 19:26:32 Re: [GENERAL] get the previous assigned sequence value