postmaster shutdown - LWLockAcquire?

From: "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: postmaster shutdown - LWLockAcquire?
Date: 2002-03-07 08:59:18
Message-ID: 2266D0630E43BB4290742247C8910575C26E23@dozer.computec.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello!

This behaviour is starting to get on my nerves...

Could somebody give me a hint as to what exactly happened here and how I
can avoid it in the future?

This is the relevant bit of the Logfile:
----------------snip----------------
2002-03-06 16:02:52 FATAL 1: Database "template0" is not currently
accepting connections
2002-03-06 16:02:53 FATAL 1: Database "template0" is not currently
accepting connections
2002-03-06 16:02:53 FATAL 1: LWLockAcquire: can't wait without a PROC
structure
2002-03-06 16:02:53 DEBUG: server process (pid 1848) exited with exit
code 1
2002-03-06 16:02:53 DEBUG: terminating any other active server
processes
2002-03-06 16:02:53 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 system connection and exit.
Please reconnect to the database system and repeat your query.
[this message is repeated six times]
2002-03-06 16:02:56 DEBUG: all server processes terminated;
reinitializing shared memory and semaphores
IpcMemoryCreate: shmget(key=5432001, size=2039808, 03600) failed: Not
enough memory

This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space.
To reduce the request size (currently 2039808 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 128) and/or
its max_connections parameter (currently 32).

The PostgreSQL Administrator's Guide contains more information about
shared memory configuration. [that wasn't really too helpful on this
matter; next I started up the service again. The subsequent entires go
along as follows:]

2002-03-06 16:15:25 DEBUG: database system was interrupted at
2002-03-06 15:58:24
2002-03-06 16:15:25 DEBUG: checkpoint record is at 1/E3952A78
2002-03-06 16:15:25 DEBUG: redo record is at 1/E3952A78; undo record is
at 0/0; shutdown FALSE
2002-03-06 16:15:25 DEBUG: next transaction id: 8343789; next oid:
2876559
2002-03-06 16:15:25 DEBUG: database system was not properly shut down;
automatic recovery in progress
2002-03-06 16:15:25 DEBUG: redo starts at 1/E3952AB8
2002-03-06 16:15:25 DEBUG: ReadRecord: record with zero length at
1/E39594F8
2002-03-06 16:15:25 DEBUG: redo done at 1/E39594D0
2002-03-06 16:15:27 DEBUG: database system is ready
----------------snip----------------

I have absolutely no idea what I should do about this. What does
"LWLockAcquire: can't wait without a PROC structure mean?" Most of the
time the thing is running fine, but it just quits occasionally. It's
PostgreSQL 7.2 running on Cygwin, Win2k, 2GB RAM, quad-processor by the
way, we are doing access via ODBC. I'd be happy to provide any more
information if it could help in solving the problem - and I'd be very
happy about helpful advice.

Thanks in advance,

Markus

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2002-03-07 11:45:31 Re: Linux Distributions
Previous Message Jean-Michel POURE 2002-03-07 08:16:08 Re: Linux Distributions