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
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? |