perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vijaya Dasari" <...@zim.mpg.de>
Subject Locks on sessions database
Date Fri, 14 Nov 2003 10:12:34 GMT
Hi,

We have problem with locking of rows in the session database. We are
using postgres as the Store.

Configuration of the system is Apache 2.0.47 + Embperl 2.0b9 + 
mod_perl 1.99_09

I tried using MySQL as Store, but still the same problem.

| 40 | sessions | localhost | sessions | Query   | 313  | User lock |
SELECT GET_LOCK('Apache-Session-30fac6623276e16798300d56c8de3989', 3600)
|
| 41 | sessions | localhost | sessions | Query   | 266  | User lock |
SELECT GET_LOCK('Apache-Session-30fac6623276e16798300d56c8de3989', 3600)
|

Two processes are trying to acquire a lock ( seems simultaneously ) on
the same session id (row).
We did not had this problem with Apache 1.3

I tried to use Semaphore combinations, but has the same problem.

Thanks in advance,
Vijaya.


-------------------------------------------
Vijaya Krishna Dasari
Heinz Nixdorf Zentrum fuer Informationsmanagement in der
Max-Planck-Gesellschaft (ZIM)
Phone:  +49-89-3299-1557
Fax: +49-89-3299-1555 
E-Mail: vid@zim.mpg.de
http: www.zim.mpg.de
Boltzmannstrasse 2/ITER Gebaeude 
D- 85748 Garching
GERMANY
-------------------------------------------



---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org


Mime
View raw message