Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 1981
Status: resolved
Priority: 0/
Queue: DBD-SQLite

People
Owner: Nobody in particular
Requestors: pw-cpan [...] terlkin.org
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 0.23
Fixed in: (no value)



Subject: 'bus error' in perl on mac os x when using DBD::SQLite and prepared statements
Versions -- Mac OS X 10.2.3 (Darwin 6.3 Darwin Kernel Version 6.3: Sat Dec 14 03:11:25 PST 2002; root:xnu/xnu-344.23.obj~4/RELEASE_PPC ) Standard Perl (5.6.0) DBD::SQLite 0.23 -- The following code fails after running through the loop 20 times or so (in reads in from a file). $name = "the name"; $email = "the email"; $sth = $dbh->prepare("insert into emails (email, name) values (?,?); while (<INPUT>) { $sth->execute($email, $name); } The following code works fine: $name = "the name"; $email = "the email"; while (<INPUT>) { $dbh->do("insert into emails (email, name) values ($email, $name)"); } Both versions work fine on Linux. Also "Testing INSERT speed ..." during install fails with bus error too. I've used force install to get it on - this is from cpan. Sorry no idea of where a fix should go but happy to test any changes. peter wilkinson.
Date: Thu, 23 Jan 2003 13:28:27 +0000 (GMT)
From: Matt Sergeant <matt [...] sergeant.org>
To: Guest via RT <bug-DBD-SQLite [...] rt.cpan.org>
Subject: Re: [cpan #1981] 'bus error' in perl on mac os x when using DBD::SQLite and prepared statements
RT-Send-Cc:
On Thu, 23 Jan 2003, Guest via RT wrote: Show quoted text
> Mac OS X 10.2.3 (Darwin 6.3 Darwin Kernel Version 6.3: Sat Dec 14 03:11:25 PST 2002; root:xnu/xnu-344.23.obj~4/RELEASE_PPC )
[snip] Sadly this appears to be a bug in sqlite itself. The problem didn't occur in earlier versions of the library. I've logged a bug with the sqlite team, and they've set it to high priority. -- <!-- Matt --> <:->get a SMart net</:-> Spam trap - do not mail: spam-sig@spamtrap.messagelabs.com
OK, found the bug. Fixed and uploaded 0.24 to CPAN (based on sqlite 2.7.6).
On Thu Jan 23 07:24:53 2003, guest wrote: Show quoted text
> Versions > -- > > Mac OS X 10.2.3 (Darwin 6.3 Darwin Kernel Version 6.3: Sat Dec 14 > 03:11:25 PST 2002; root:xnu/xnu-344.23.obj~4/RELEASE_PPC ) > > Standard Perl (5.6.0) > > DBD::SQLite 0.23 > > -- > > The following code fails after running through the loop 20 times or
so Show quoted text
> (in reads in from a file). > > $name = "the name"; > $email = "the email"; > $sth = $dbh->prepare("insert into emails (email, name) values (?,?); > while (<INPUT>) { > $sth->execute($email, $name); > } > > The following code works fine: > $name = "the name"; > $email = "the email"; > while (<INPUT>) { > $dbh->do("insert into emails (email, name) values ($email,
$name)"); Show quoted text
> } > > Both versions work fine on Linux. > > Also "Testing INSERT speed ..." during install fails with bus error > too. I've used force install to get it on - this is from cpan. > > Sorry no idea of where a fix should go but happy to test any changes. > > peter wilkinson.
On Thu Jan 23 07:24:53 2003, guest wrote: Show quoted text
> Versions > -- > > Mac OS X 10.2.3 (Darwin 6.3 Darwin Kernel Version 6.3: Sat Dec 14 > 03:11:25 PST 2002; root:xnu/xnu-344.23.obj~4/RELEASE_PPC ) > > Standard Perl (5.6.0) > > DBD::SQLite 0.23 > > -- > > The following code fails after running through the loop 20 times or
so Show quoted text
> (in reads in from a file). > > $name = "the name"; > $email = "the email"; > $sth = $dbh->prepare("insert into emails (email, name) values (?,?); > while (<INPUT>) { > $sth->execute($email, $name); > } > > The following code works fine: > $name = "the name"; > $email = "the email"; > while (<INPUT>) { > $dbh->do("insert into emails (email, name) values ($email,
$name)"); Show quoted text
> } > > Both versions work fine on Linux. > > Also "Testing INSERT speed ..." during install fails with bus error > too. I've used force install to get it on - this is from cpan. > > Sorry no idea of where a fix should go but happy to test any changes. > > peter wilkinson.
On Thu Jan 23 07:24:53 2003, guest wrote: Show quoted text
> Versions > -- > > Mac OS X 10.2.3 (Darwin 6.3 Darwin Kernel Version 6.3: Sat Dec 14 > 03:11:25 PST 2002; root:xnu/xnu-344.23.obj~4/RELEASE_PPC ) > > Standard Perl (5.6.0) > > DBD::SQLite 0.23 > > -- > > The following code fails after running through the loop 20 times or
so Show quoted text
> (in reads in from a file). > > $name = "the name"; > $email = "the email"; > $sth = $dbh->prepare("insert into emails (email, name) values (?,?); > while (<INPUT>) { > $sth->execute($email, $name); > } > > The following code works fine: > $name = "the name"; > $email = "the email"; > while (<INPUT>) { > $dbh->do("insert into emails (email, name) values ($email,
$name)"); Show quoted text
> } > > Both versions work fine on Linux. > > Also "Testing INSERT speed ..." during install fails with bus error > too. I've used force install to get it on - this is from cpan. > > Sorry no idea of where a fix should go but happy to test any changes. > > peter wilkinson.
On Thu Jan 23 07:24:53 2003, guest wrote: Show quoted text
> Versions > -- > > Mac OS X 10.2.3 (Darwin 6.3 Darwin Kernel Version 6.3: Sat Dec 14 > 03:11:25 PST 2002; root:xnu/xnu-344.23.obj~4/RELEASE_PPC ) > > Standard Perl (5.6.0) > > DBD::SQLite 0.23 > > -- > > The following code fails after running through the loop 20 times or
so Show quoted text
> (in reads in from a file). > > $name = "the name"; > $email = "the email"; > $sth = $dbh->prepare("insert into emails (email, name) values (?,?); > while (<INPUT>) { > $sth->execute($email, $name); > } > > The following code works fine: > $name = "the name"; > $email = "the email"; > while (<INPUT>) { > $dbh->do("insert into emails (email, name) values ($email,
$name)"); Show quoted text
> } > > Both versions work fine on Linux. > > Also "Testing INSERT speed ..." during install fails with bus error > too. I've used force install to get it on - this is from cpan. > > Sorry no idea of where a fix should go but happy to test any changes. > > peter wilkinson.