[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] PGSQL 6.4 is crashing
From:       Marc Eggenberger <me () ieo ! ch>
Date:       1999-01-20 11:18:00
[Download RAW message or body]

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@ieo.ch
Muenchhaldenstr. 33     Tel 01/3804670
8034 Zuerich            Fax 01/3816400
=====================================


[prev in list] [next in list] [prev in thread] [next in thread]