Bug #21406 for DBD-SQLite: DBD-SQLite 1.13 broke Class-DBI

Sat Sep 09 13:35:28 2006 ATOURBIN [...] cpan.org - Ticket created

Subject:

DBD-SQLite 1.13 broke Class-DBI

Message body is not shown because it is too large.

Mon Jan 22 13:13:55 2007 sabol [...] alderaan.gsfc.nasa.gov - Correspondence added

From:

sabol [...] alderaan.gsfc.nasa.gov

On Sat Sep 09 13:35:28 2006, ATOURBIN wrote: Show quoted text

> After I upgraded from 1.12 to 1.13, I found some applications issuing > "statement handle DBIx::ContextualFetch::st=HASH(0x8e86ee4) still > Active at /usr/lib/perl5/vendor_perl/Ima/DBI.pm line 391" warnings. > Moreover, some test suites got broken, most notable that of Class- > DBI. After I rolled back to 1.12, things work fine again.

This continues to be a widespread problem. Matt, any fix (besides downgrading to DBD:: SQLite 1.12) in sight? Do you need a failing test case to resolve it?

Mon Jan 22 13:13:58 2007 The RT System itself - Status changed from 'new' to 'open'

Mon Jan 22 13:28:45 2007 ATOURBIN [...] cpan.org - Correspondence added

From:

ATOURBIN [...] cpan.org

On Mon Jan 22 13:13:55 2007, sabol@alderaan.gsfc.nasa.gov wrote: Show quoted text

> This continues to be a widespread problem. Matt, any fix (besides > downgrading to DBD:: > SQLite 1.12) in sight? Do you need a failing test case to resolve it?

Hello, that's me again. I managed to hack around the problem. I had to patch Class-DBI. Some details are available here: http://git.altlinux.org/people/at/packages/?p=perl-Class-DBI.git

Mon Feb 05 23:33:47 2007 SMPETERS [...] cpan.org - Correspondence added

On Mon Jan 22 13:28:45 2007, ATOURBIN wrote: Show quoted text

> On Mon Jan 22 13:13:55 2007, sabol@alderaan.gsfc.nasa.gov wrote:

> > This continues to be a widespread problem. Matt, any fix (besides > > downgrading to DBD:: > > SQLite 1.12) in sight? Do you need a failing test case to resolve it?

> > Hello, that's me again. I managed to hack around the problem. > I had to patch Class-DBI. Some details are available here: > http://git.altlinux.org/people/at/packages/?p=perl-Class-DBI.git

Looking at DBI's documentation, I think you have pointed to the solution that is needed. "If execute() is called on a statement handle that's still active ($sth->{Active} is true) then it should effectively call finish() to tidy up the previous execution results before starting this new execution." Obviously, it seems that the finish is not being called on the DBI/DBD side to make the statement handle inactive.

Mon Dec 17 14:36:43 2007 wonko [...] cpan.org - Broken in 1.14 added

Mon Dec 17 14:36:55 2007 wonko [...] cpan.org - Severity Important added

Fri Apr 03 19:31:34 2009 adamk [...] cpan.org - Correspondence added

This appears to be resolved now.

Fri Apr 03 19:31:37 2009 adamk [...] cpan.org - Status changed from 'open' to 'resolved'