Email this page
Send a link

CPAN modules

Table of contents

Session

Apache::Session

The error

DBI::db=HASH(0x8f41154)->disconnect invalidates 2 active statement handles \
(either destroy statement handles or call finish on them before disconnecting) at \
/usr/local/lib/perl5/site_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 90, <DATA> line 1.


My patch

--- /usr/local/lib/perl5/site_perl/5.8.8/Apache/Session/Lock/MySQL.pm.bak       Mon Jun 25 15:22:05 2007
+++ /usr/local/lib/perl5/site_perl/5.8.8/Apache/Session/Lock/MySQL.pm   Mon Jun 25 15:25:02 2007
@@ -52,6 +52,7 @@

     my $sth = $self->{dbh}->prepare_cached(q{SELECT GET_LOCK(?, 3600)}, {}, 1);
     $sth->execute($self->{lockid});
+    $sth->finish();

     $self->{lock} = 1;
 }
@@ -68,6 +69,7 @@

         my $sth = $self->{dbh}->prepare_cached(q{SELECT RELEASE_LOCK(?)}, {}, 1);
         $sth->execute($self->{lockid});
+        $sth->finish();

         $self->{lock} = 0;
     }


I would have submitted this patch to the CPAN team / person - but the site is down :(

http://rt.cpan.org/Public/Dist/Display.html?Name=Apache-Session (external link)
toggle Advanced Search Help
  • + : A leading plus sign indicates that this word must be present in every object returned.
  • - : A leading minus sign indicates that this word must not be present in any row returned.
  • By default (when neither plus nor minus is specified) the word is optional, but the object that contain it will be rated higher.
  • < > : These two operators are used to change a word's contribution to the relevance value that is assigned to a row.
  • ( ) : Parentheses are used to group words into subexpressions.
  • ~ : A leading tilde acts as a negation operator, causing the word's contribution to the object relevance to be negative. It's useful for marking noise words. An object that contains such a word will be rated lower than others, but will not be excluded altogether, as it would be with the - operator.
  • * : An asterisk is the truncation operator. Unlike the other operators, it should be appended to the word, not prepended.
  • " : The phrase, that is enclosed in double quotes ", matches only objects that contain this phrase literally, as it was typed.

Menu

Search

in:

Help