perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gerald Richter" <rich...@ecos.de>
Subject Re: Locks on sessions database
Date Sat, 15 Nov 2003 13:58:32 GMT
Vijaya Dasari wrote:
> Hi,
>
> We have problem with locking of rows in the session database. We are
> using postgres as the Store.
>

How does your Embperl session configuration look like?

Gerald


> 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

--------------------------------------------------------------
Gerald Richter     ecos electronic communication services gmbh
IT-Securitylösungen * dynamische Webapplikationen * Consulting

Post:       Tulpenstrasse 5          D-55276 Dienheim b. Mainz
E-Mail:     richter@ecos.de          Voice:   +49 6133 939-122
WWW:        http://www.ecos.de/      Fax:     +49 6133 939-333
--------------------------------------------------------------
|
|   ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info
|
+-------------------------------------------------------------


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


Mime
View raw message