Skip Menu |

This queue is for tickets about the Apache-Session CPAN distribution.

Report information
The Basics
Id: 54892
Status: open
Priority: 0/
Queue: Apache-Session
People
Owner: Nobody in particular
Requestors: DOUGW [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 1.81
Fixed in: (no value)

History Show all quoted text
  Mon Feb 22 17:36:41 2010 DOUGW [...] cpan.org - Ticket created
Apache::Session::Lock::MySQL has this: my $sth = $self->{dbh}->prepare_cached(q{SELECT GET_LOCK(?, 3600)}, {}, 1); $sth->execute($self->{lockid}); It does not, however, fetch from sth, so you do not know if you obtained a lock . My understanding of GET_LOCK() is that it returns 0 or 1 (or null on error) depending on whether you got the lock or not.
  Thu Feb 25 02:37:40 2010 DOUGW [...] cpan.org - Subject changed from (no value) to 'MySQL::Lock not verifying lock'
  Thu Mar 11 18:26:06 2010 DOUGW [...] cpan.org - Correspondence added
On Mon Feb 22 17:36:41 2010, DOUGW wrote: Show quoted text
> Apache::Session::Lock::MySQL has this: > my $sth = $self->{dbh}->prepare_cached(q{SELECT GET_LOCK(?, 3600)}, > {}, 1); > $sth->execute($self->{lockid}); > > It does not, however, fetch from sth, so you do not know if you obtained > a lock . My understanding of GET_LOCK() is that it returns 0 or 1 (or > null on error) depending on whether you got the lock or not.
I suppose with a timeout of one hour, it's not likely the connection will survive that long...
  Thu Mar 11 18:26:07 2010 DOUGW [...] cpan.org - Status changed from 'new' to 'open'