PGSQL 6.4 is crashing

From: Marc Eggenberger <me(at)ieo(dot)ch>
To: pgsql-admin(at)postgresql(dot)org
Subject: PGSQL 6.4 is crashing
Date: 1999-01-20 11:18:00
Message-ID: 199901201017.LAA31710@linux1.ieo.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi there

I have a quite busy site with about 150'000 hits a day which runs on SuSe Linux 6, apache 1.3.3, php 3.0.5 and postgres 6.4

now the postmaster task is going down quite often now (sometimes several times an hour) ... here's a brief log:

FATAL: s_lock(4015504d) at spin.c:125, stuck spinlock. Aborting.

FATAL: s_lock(4015504d) at spin.c:125, stuck spinlock. Aborting.
ERROR: attribute f not found
FATAL 1: Database system does not exist. PGDATA directory '/var/lib/pgsql/data' not found.
Normally, you create a database system by running initdb.
ERROR: postmaster: StreamConnection: accept: Invalid argument
TRAP: Failed Assertion("!(lock->nHolding > 0):", File: "lock.c", Line: 1318)

!(lock->nHolding > 0) (0) [Illegal seek]

NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died abnormally and possibly
corrupted shared memory.
I have rolled back the current transaction and am going to terminate your database s
ystem connection and exit.
Please reconnect to the database system and repeat your query.
TRAP: Failed Assertion("!(proc == MyProc || pid != MyProcPid):", File: "proc.c", Line: 355)

!(proc == MyProc || pid != MyProcPid) (0) [Illegal seek]
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died abnormally and possibly
corrupted shared memory.
I have rolled back the current transaction and am going to terminate your database s
ystem connection and exit.
Please reconnect to the database system and repeat your query.
TRAP: Failed Assertion("!(proc == MyProc || pid != MyProcPid):", File: "proc.c", Line: 355)

!(proc == MyProc || pid != MyProcPid) (0) [Illegal seek]
ERROR: attribute f not found

does anybody maybe knows any hints?

or how can I set the log to a more verbose mode? I mean time when those events happend would be interessting ...
and when the postmaster crashes I have a lot of zombie tasks ....

--
mit freundlichen Gruessen
=====================================
Eggenberger Marc me(at)ieo(dot)ch
Muenchhaldenstr. 33 Tel 01/3804670
8034 Zuerich Fax 01/3816400
=====================================

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Olivier 1999-01-20 19:03:38 6.4.2 vs. 6.3.2 - Q's about differences
Previous Message Herouth Maoz 1999-01-20 10:22:08 Re: [ADMIN] v6.4.2 backend crashing on certain sql stmts