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 appreciated. thanks in advance Brian $ cat test.pl #!/usr/bin/perl use DBI; use DBD::SQLite 1.26; my $dbfile = "/tmp/test.$$"; my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile"); $dbh->sqlite_enable_load_extension(1); $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: Platform: 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 Compiler: 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 gnulibc_version='2.10.1' 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): Compile-time options: MULTIPLICITY PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP USE_ITHREADS USE_LARGE_FILES USE_PERLIO USE_REENTRANT_API Built under linux Compiled at Oct 1 2009 22:19:26 @INC: /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl . $ _______________________________________________ DBD-SQLite mailing list DBD-SQLite@lists.scsys.co.uk http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbd-sqlite