DBI:AnyData -DBI handle 0x85fa9dc cleared whilst still active.



Can anyone explain why I'm getting this error?

I have failed to find anything useful in google or by reading though the CPAN
info.

--Start script
#!/usr/bin/perl
use DBI;

my $dbh = DBI->connect('dbi:AnyData(RaiseError=>1):');
$dbh->func('mytable','CSV','data.csv','ad_catalog');
my $sth = $dbh->prepare("SELECT some FROM mytable");

$sth->execute();

while ( my $row = $sth->fetch ) {
print "@$row\n";
}

$sth->finish();
$dbh->disconnect();
-- End

--Start data.csv
some,csv,data,not,a,lot,but,enough,to,test,with
some1,csv1,data1,not1,a1,lot1,but1,enough1,to1,test1,with1
some2,csv2,data2,not2,a2,lot2,but2,enough2,to2,test2,with2
some3,csv3,data3,not3,a3,lot3,but3,enough3,to3,test3,with3
--End

Result:
$ ./t1.pl
some1
some2
some3
DBI handle 0x85fa9dc cleared whilst still active.
dbih_clearcom (sth 0x85fa9dc, com 0x85fbb48, imp DBD::AnyData::st):
FLAGS 0x182195: COMSET Active Warn RaiseError PrintError PrintWarn
ShowErrorStatement
PARENT DBI::db=HASH(0x85fa8b0)
KIDS 0 (0 Active)
IMP_DATA undef
NUM_OF_FIELDS 1
NUM_OF_PARAMS 0


Stephen
.



Relevant Pages

  • DBI::AnyData problem
    ... v5.8.7 built for i686-linux running on gentoo. ... I have the following script more or less copied from the CPAN example: ... DBI handle 0x8529630 cleared whilst still active. ...
    (perl.beginners)
  • Re: DBD::CSV - UPDATE corrupts data!
    ... DBI 1.607, DBD::CSV 0.20, both runs deliver the same result from your first run. ... This are remnants from the shortening of the original program to generate a minimal test script. ... will try UPDATE Projects ...
    (perl.dbi.users)
  • Re: DBD::CSV - UPDATE corrupts data!
    ... I stumbled over somthing very strange: When I try to update data in a table, the input parameters are going into the right fields - exept the first data row in the table / file. ... Below is a script which demonstrate the thing. ... Running the code below copied and pasted on Linux 2.6.26.5, Perl 5.8.8, DBI 1.607, DBD::CSV 0.20, both runs deliver the same result from your first run. ...
    (perl.dbi.users)
  • Re: DBD::Oracle problem with bind_param_inout and UTF-8
    ... my $uidpwd = 'usr/pwd@db'; ... Using DBI 1.605 and DBD::Oracle 1.23 ... Sym = € ... Consider the following script ... ...
    (perl.dbi.users)
  • New test release (1.15_2) of DBD::ODBC
    ... I have uploaded to CPAN 1.15_2 test release of DBD::ODBC. ... Changed Makefile.PL so if an ODBC driver manager is not found then we ... makes cpan-testers log a fail if DBI is not installed. ...
    (perl.dbi.users)