Re: Auto rollback using Apache::DBI

2000-09-08 Thread Jeff Horn
-- From: "Honza Pazdziora" <[EMAIL PROTECTED]> To: "Nicolas MONNET" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, September 07, 2000 9:17 AM Subject: Re: Auto rollback using Apache::DBI > On Thu, Sep 07, 2000 at 04:03:04PM +0200, Nicolas MONNET

Re: Auto rollback using Apache::DBI

2000-09-08 Thread Nicolas MONNET
On Fri, 8 Sep 2000, Honza Pazdziora wrote: |The code | |my $needCleanup = ($Idx =~ /AutoCommit[^\d]+0/) ? 1 : 0; |if(!$Rollback{$Idx} and $needCleanup and Apache->can('push_handlers')) { |print STDERR "$prefix push PerlCleanupHandler \n" if $Apache::DBI::DEBUG > 1; |Apache

Re: Auto rollback using Apache::DBI

2000-09-08 Thread Honza Pazdziora
On Thu, Sep 07, 2000 at 11:06:00AM -0700, Perrin Harkins wrote: > On Thu, 7 Sep 2000, Nicolas MONNET wrote: > > |Well, Apache::DBI does push a cleanup handler that does a rollback if > > |auto-commit is off. Are you saying this isn't working? > > > > I've run into a situation where it was'nt. I

Re: Auto rollback using Apache::DBI

2000-09-07 Thread Perrin Harkins
On Thu, 7 Sep 2000, Nicolas MONNET wrote: > |Well, Apache::DBI does push a cleanup handler that does a rollback if > |auto-commit is off. Are you saying this isn't working? > > I've run into a situation where it was'nt. I wanted to make sure > it's not the desired behaviour, before I can dig mor

Re: Auto rollback using Apache::DBI

2000-09-07 Thread Nicolas MONNET
On Thu, 7 Sep 2000, Perrin Harkins wrote: |On Thu, 7 Sep 2000, Nicolas MONNET wrote: |> I might get something wrong, but while in non-autocommit, if a script dies |> before rollbacking or commiting, looks like the transaction never gets |> cancelled until I kill -HUP httpd! Quite a problem ... |>

Re: Auto rollback using Apache::DBI

2000-09-07 Thread Perrin Harkins
On Thu, 7 Sep 2000, Nicolas MONNET wrote: > I might get something wrong, but while in non-autocommit, if a script dies > before rollbacking or commiting, looks like the transaction never gets > cancelled until I kill -HUP httpd! Quite a problem ... > > Is there any known way to catch this? Well

Re: Auto rollback using Apache::DBI

2000-09-07 Thread Matt Sergeant
On Thu, 7 Sep 2000, Nicolas MONNET wrote: > > > Hi there, > > I might get something wrong, but while in non-autocommit, if a script dies > before rollbacking or commiting, looks like the transaction never gets > cancelled until I kill -HUP httpd! Quite a problem ... > > Is there any known way

Re: Auto rollback using Apache::DBI

2000-09-07 Thread Honza Pazdziora
On Thu, Sep 07, 2000 at 04:03:04PM +0200, Nicolas MONNET wrote: > > I might get something wrong, but while in non-autocommit, if a script dies > before rollbacking or commiting, looks like the transaction never gets > cancelled until I kill -HUP httpd! Quite a problem ... > > Is there any known

Auto rollback using Apache::DBI

2000-09-07 Thread Nicolas MONNET
Hi there, I might get something wrong, but while in non-autocommit, if a script dies before rollbacking or commiting, looks like the transaction never gets cancelled until I kill -HUP httpd! Quite a problem ... Is there any known way to catch this?