[PHPLIB] WaitOnLock error with db_pgsql.inc From: admin (admin <email protected>)
Date: 12/04/99

I am getting a WaitOnLock error when too many people are searching my
database simultaneously. I am keeping statistics of which products are
being accessed, so there is a write for each returned product.
The error message points to the query() function in db_pgsql.inc, on the
following line:
$this->Query_ID = pg_Exec($this->Link_ID, $Query_String);

The query in my code causing this error looks like:
update products set stat='$x' where id='$id';

I, myself, am probably at the source of the problem having abused of the
system with multiple concurrent writes to the db, but I'm hoping the
phplib mailing list will be able to provide somekind of alternative for me
to keep logging statistics while providing multiple simultaneous
connections.

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
And installed phplib_7, of course.

Thanks in advance,
Marc

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.