WaitOnLock error on wakeup

From: admin <admin(at)wtbwts(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: WaitOnLock error on wakeup
Date: 1999-12-06 02:17:06
Message-ID: Pine.BSF.4.10.9912060205560.59446-100000@server.b0x.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am getting a WaitOnLock error on wakeup when searching my database
using php on my website. This is clearly a pgsql error message, but I
can't seem to understand why pgsql would lock on me.

My problem query returns batches of 100 found products and I keep
statistics for each product found. Therefore, there is 100 writes to the
db for each query. My code causing the error looks like:
update product_table set stat='$x' where id='$id';

My current OS and software are:
Freebsd 3.3-CURRENT with the following ports:
apache+php+mod_ssl-1.3.9+3.0.12+2.4.2
postgresql-5.4.1

I am running postmaster with the following flags:
postmaster -i -S -o -F

Thanks in advance,
Marc

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 1999-12-06 02:45:18 Re: [GENERAL] null and =
Previous Message The Hermit Hacker 1999-12-06 00:56:47 Oft Ask: How to contribute to PostgreSQL?