LWLock acquire - can't wait without a proc structure

From: Alexey Dashevsky <alex(at)kpgaz(dot)chernigov(dot)ua>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: LWLock acquire - can't wait without a proc structure
Date: 2003-02-03 08:24:27
Message-ID: 20030203082423.C5EC019425@kpgaz.chernigov.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I'm running postgresql 7.2.1(linux kernel 2.4.20).
RAID5 4 x 20G, 2G RAM, two Xeon.

/proc/sysctl.conf
kernel.shmall = 67108864
kernel.shmmax = 67108864

/opt/pgsql/data/postgresql.conf
shared_buffers = 4096
max_lock_per_transaction = 128
effective_cach_size = 40000

From time to time I receive the message:
"LWLockAcquire - can't wait without a proc structure.

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.".

What can be the reasons of these?

Thanks in advance.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-02-03 08:42:32 Re: Fwd: Postfix SMTP server: errors from
Previous Message Aris wendy 2003-02-03 04:55:30 Re: Database Management Setup