Skip Menu |

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

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

People
Owner: Nobody in particular
Requestors: DAMI [...] cpan.org
Cc:
AdminCc:

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



Subject: win32 core dump on fts4 tokenizer
While working on CPAN module Lingua::Thesaurus, which uses SQLite, some of my tests generate core dumps. This happens when one program creates a database with a custom FTS4 tokenizer, and then another program reads that same database. Below are two excerpts to reproduce the problem, and some indications about the context. - problem seen only on Windows 7; same programs on Solaris work fine - using perl 5.14 - the program results are OK, which means that FTS4 tokenizer does its job - apparently prog2 core dumps while performing DESTROY on the dbh. When bypassing the END section (through POSIX::_exit), everything is fine. prog1.pl ======== use strict; use warnings; use DBI; use Search::Tokenizer; my $dbname = "foo.sqlite"; unlink $dbname; my $dbh = DBI->connect("dbi:SQLite:dbname=$dbname", "",""); $dbh->do(<<""); CREATE VIRTUAL TABLE term USING fts4(content, tokenize=perl 'Search::Tokenizer::unaccent') $dbh->do(<<""); INSERT INTO term(content) values ('il était une bergère') print "done"; prog2.pl ======== use strict; use warnings; use DBI; use Search::Tokenizer; my $dbname = "foo.sqlite"; my $dbh = DBI->connect("dbi:SQLite:dbname=$dbname", "",""); my $sql = "select * from term WHERE content MATCH 'bergere'"; my $sth = $dbh->prepare($sql); $sth->execute; my $res = $sth->fetchall_arrayref; use YAML; print Dump $res; print "done";
Le Sam 08 Juin 2013 20:51:02, DAMI a écrit : Show quoted text
> While working on CPAN module Lingua::Thesaurus, which uses SQLite, > some of my tests generate core dumps. This happens when one program > creates a database with a custom FTS4 tokenizer, and then another > program reads that same database.
This problem is quite similar to #97598; but unfortunately the recent patch which solves #97598 still doesn't solve the present ticket.
On Wed Aug 20 21:27:39 2014, DAMI wrote: Show quoted text
> Le Sam 08 Juin 2013 20:51:02, DAMI a écrit :
> > While working on CPAN module Lingua::Thesaurus, which uses SQLite, > > some of my tests generate core dumps. This happens when one program > > creates a database with a custom FTS4 tokenizer, and then another > > program reads that same database.
> > This problem is quite similar to #97598; but unfortunately the recent > patch which solves #97598 still doesn't solve the present ticket.
Fixed tentatively in the master: https://github.com/DBD-SQLite/DBD-SQLite/commit/69d9a31fc01308350d6a1eb45af66336a7cc9759
On Wed Feb 11 12:57:18 2015, ISHIGAKI wrote: Show quoted text
> On Wed Aug 20 21:27:39 2014, DAMI wrote:
> > Le Sam 08 Juin 2013 20:51:02, DAMI a écrit :
> > > While working on CPAN module Lingua::Thesaurus, which uses SQLite, > > > some of my tests generate core dumps. This happens when one program > > > creates a database with a custom FTS4 tokenizer, and then another > > > program reads that same database.
> > > > This problem is quite similar to #97598; but unfortunately the recent > > patch which solves #97598 still doesn't solve the present ticket.
> > Fixed tentatively in the master: https://github.com/DBD-SQLite/DBD- > SQLite/commit/69d9a31fc01308350d6a1eb45af66336a7cc9759
Closed as 1.48 with a fix was out. Thanks.