[DBD-SQLite] load_extension("perlvtab.so")

Brian Duggan bduggan at matatu.org
Thu Oct 29 15:35:24 GMT 2009

Hi DBD::SQliters,

I'd like to use DBD::SQLite in combination with
the SQLite::VirtualTable module/extension, but
attempting to do so produces a seg fault.

DBD::SQLite is loading other extensions fine,
and SQLite::VirtualTable is working fine from
command line sqlite (all versions).

The output I'm seeing is below (including stack trace
+ version info).  Any help or insights would be greatly

thanks in advance

$ cat test.pl

use DBI;
use DBD::SQLite 1.26;

my $dbfile = "/tmp/test.$$";
my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile");
$sth = $dbh->prepare("select load_extension('perlvtab.so')")
     or die "Cannot prepare: " . $dbh->errstr();
$sth->execute or die $sth->errstr;

$ perl test.pl
Segmentation fault (core dumped)

$ debugperl test.pl
panic: free from wrong pool.

$ gdb -c core perl test.pl
Program terminated with signal 11, Segmentation fault.
#0  0x00f90029 in dbih_clearcom (imp_xxh=0x8c29950) at DBI.xs:1432
1432        int debug = DBIS_TRACE_LEVEL;
(gdb) where
#0  0x00f90029 in dbih_clearcom (imp_xxh=0x8c29950) at DBI.xs:1432
#1  0x00f8295d in XS_DBD___mem__common_DESTROY (my_perl=0x8c02008, cv=0x8c68c08) at DBI.xs:5135
#2  0x080b12c0 in Perl_pp_entersub (my_perl=0x8c02008) at pp_hot.c:2866
#3  0x080ad2f2 in Perl_call_sv (my_perl=0x8c02008, sv=0x8c68c08, flags=150) at perl.c:2653
#4  0x080c3293 in Perl_sv_clear (my_perl=0x8c02008, sv=0x8c28808) at sv.c:5122
#5  0x080c398a in Perl_sv_free2 (my_perl=0x8c02008, sv=0x8c28808) at sv.c:5368
#6  0x08098d86 in Perl_mg_free (my_perl=0x8c02008, sv=0x8d5faa0) at mg.c:498
#7  0x080c349e in Perl_sv_clear (my_perl=0x8c02008, sv=0x8d5faa0) at sv.c:5159
#8  0x080c398a in Perl_sv_free2 (my_perl=0x8c02008, sv=0x8d5faa0) at sv.c:5368
#9  0x080c35a7 in Perl_sv_clear (my_perl=0x8c02008, sv=0x8cdc120) at sv.c:5236
#10 0x080c398a in Perl_sv_free2 (my_perl=0x8c02008, sv=0x8cdc120) at sv.c:5368
#11 0x08098d86 in Perl_mg_free (my_perl=0x8c02008, sv=0x8c287d8) at mg.c:498
#12 0x080c349e in Perl_sv_clear (my_perl=0x8c02008, sv=0x8c287d8) at sv.c:5159
#13 0x080c398a in Perl_sv_free2 (my_perl=0x8c02008, sv=0x8c287d8) at sv.c:5368
#14 0x080b8b19 in S_visit (my_perl=<value optimized out>, f=<value optimized out>, flags=2048, mask=2048)
    at sv.c:387
#15 0x080b8b79 in Perl_sv_clean_objs (my_perl=0x8c02008) at sv.c:495
#16 0x080af3c7 in perl_destruct (my_perl=0x8c02008) at perl.c:799
#17 0x08063fa5 in main (argc=2, argv=0xbfbf5e84, env=0xbfbf5e90) at perlmain.c:115
(gdb) quit

$ perl -V
Summary of my perl5 (revision 5 version 10 subversion 0) configuration:
    osname=linux, osvers=2.6.24-23-server, archname=i486-linux-gnu-thread-multi
    uname='linux vernadsky 2.6.24-23-server #1 smp wed apr 1 22:22:14 utc 2009 i686 gnulinux '
    config_args='-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN -Dcccdlflags=-fPIC -Darchname=i486-linux-gnu -Dprefix=/usr -Dprivlib=/usr/share/perl/5.10 -Darchlib=/usr/lib/perl/5.10 -Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5 -Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local -Dsitelib=/usr/local/share/perl/5.10.0 -Dsitearch=/usr/local/lib/perl/5.10.0 -Dman1dir=/usr/share/man/man1 -Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1 -Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm -DDEBUGGING=-g -Doptimize=-O2 -Duseshrplib -Dlibperl=libperl.so.5.10.0 -Dd_dosuid -des'
    hint=recommended, useposix=true, d_sigaction=define
    useithreads=define, usemultiplicity=define
    useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
    use64bitint=undef, use64bitall=undef, uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
    cc='cc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
    optimize='-O2 -g',
    cppflags='-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing -pipe -I/usr/local/include'
    ccversion='', gccversion='4.4.1', gccosandvers=''
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=4, prototype=define
  Linker and Libraries:
    ld='cc', ldflags =' -L/usr/local/lib'
    libpth=/usr/local/lib /lib /usr/lib /usr/lib64
    libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
    perllibs=-ldl -lm -lpthread -lc -lcrypt
    libc=/lib/libc-2.10.1.so, so=so, useshrplib=true, libperl=libperl.so.5.10.0
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
    cccdlflags='-fPIC', lddlflags='-shared -O2 -g -L/usr/local/lib'

Characteristics of this binary (from libperl):
  Built under linux
  Compiled at Oct  1 2009 22:19:26

More information about the DBD-SQLite mailing list