Re: [sqlite] DBD::SQLite::Amalgamation-3.6.1.2 FTS3 seg faulting... solution... upgrade code
I mean what is benefits of using DBD::SQLite::Amalgamation? Where it can be needed? -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid On Sun, Sep 21, 2008 at 9:51 AM, P Kishor [EMAIL PROTECTED] wrote: On 9/21/08, Alexander Batyrshin [EMAIL PROTECTED] wrote: Sorry for off-topic. What is main difference between DBD::SQLite and DBD::SQLite::Amalgamation? Exactly what it says on the box. The latter uses the SQLite amalgamation. The former doesn't. They both work exactly the same for the end user. -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid On Sat, Sep 20, 2008 at 8:04 PM, P Kishor [EMAIL PROTECTED] wrote: I encountered this problem and solved it, so hopefully this will help some other poor sod. Audrey Tang's otherwise most excellent DBD::SQLite::Amalgamation (bless her for this incredible package) was causing segmentation faults for me while doing FTS3 searches on a RH ES3 Linux box. The package version 3.6.1.2 has code for SQLite 3.6.1. I upgraded the code in the package to SQLite 3.6.2 (just copied the corresponding files from the SQLite tarball... one file had to be renamed from sqlite.c to sqlite-amalgamation.c) and rebuilt the DBD. Everything is now fine in happy town. -- Puneet Kishor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] DBD::SQLite::Amalgamation-3.6.1.2 FTS3 seg faulting... solution... upgrade code
I encountered this problem and solved it, so hopefully this will help some other poor sod. Audrey Tang's otherwise most excellent DBD::SQLite::Amalgamation (bless her for this incredible package) was causing segmentation faults for me while doing FTS3 searches on a RH ES3 Linux box. The package version 3.6.1.2 has code for SQLite 3.6.1. I upgraded the code in the package to SQLite 3.6.2 (just copied the corresponding files from the SQLite tarball... one file had to be renamed from sqlite.c to sqlite-amalgamation.c) and rebuilt the DBD. Everything is now fine in happy town. -- Puneet Kishor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DBD::SQLite::Amalgamation-3.6.1.2 FTS3 seg faulting... solution... upgrade code
Sorry for off-topic. What is main difference between DBD::SQLite and DBD::SQLite::Amalgamation? -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid On Sat, Sep 20, 2008 at 8:04 PM, P Kishor [EMAIL PROTECTED] wrote: I encountered this problem and solved it, so hopefully this will help some other poor sod. Audrey Tang's otherwise most excellent DBD::SQLite::Amalgamation (bless her for this incredible package) was causing segmentation faults for me while doing FTS3 searches on a RH ES3 Linux box. The package version 3.6.1.2 has code for SQLite 3.6.1. I upgraded the code in the package to SQLite 3.6.2 (just copied the corresponding files from the SQLite tarball... one file had to be renamed from sqlite.c to sqlite-amalgamation.c) and rebuilt the DBD. Everything is now fine in happy town. -- Puneet Kishor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DBD::SQLite::Amalgamation-3.6.1.2 FTS3 seg faulting... solution... upgrade code
On 9/21/08, Alexander Batyrshin [EMAIL PROTECTED] wrote: Sorry for off-topic. What is main difference between DBD::SQLite and DBD::SQLite::Amalgamation? Exactly what it says on the box. The latter uses the SQLite amalgamation. The former doesn't. They both work exactly the same for the end user. -- Alexander Batyrshin aka bash bash = Biomechanica Artificial Sabotage Humanoid On Sat, Sep 20, 2008 at 8:04 PM, P Kishor [EMAIL PROTECTED] wrote: I encountered this problem and solved it, so hopefully this will help some other poor sod. Audrey Tang's otherwise most excellent DBD::SQLite::Amalgamation (bless her for this incredible package) was causing segmentation faults for me while doing FTS3 searches on a RH ES3 Linux box. The package version 3.6.1.2 has code for SQLite 3.6.1. I upgraded the code in the package to SQLite 3.6.2 (just copied the corresponding files from the SQLite tarball... one file had to be renamed from sqlite.c to sqlite-amalgamation.c) and rebuilt the DBD. Everything is now fine in happy town. -- Puneet Kishor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DBD::SQLite::Amalgamation?
On 3/31/08, Jim Dodgen [EMAIL PROTECTED] wrote: It makes ok, here is the output from make test. the hang is after t/06error it never finishes DBD-SQLite-Amalgamation-3.5.7 # make test PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/00basic...ok t/01logon...ok t/02cr_tableok t/03insert..ok t/04select..ok t/05tranok t/06error...ok 1/2 (this never finishes) In the beginnig there are unlink and connect commands in t/06 which were successful in previous tests. So something may go wrong with eval of the do test which should throw an error in [EMAIL PROTECTED] You could step in with the debugger to see where's the fault. -- Radek ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DBD::SQLite::Amalgamation?
On 3/31/08, Jim Dodgen [EMAIL PROTECTED] wrote: Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test Today I tried and installed on Solaris successfully. Both the module 1.14 and sqlite3 amalgamation. -- Radek ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DBD::SQLite::Amalgamation?
Humm... I'll keep looking. thanks On 3/30/08, Jim Dodgen [EMAIL PROTECTED] wrote: Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test It hangs forever and never completes I have tried this on multiple boxes running both Fedora and Redhat ES, all 64 bit. -- Jim Dodgen [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DBD::SQLite::Amalgamation?
On 3/30/08, Jim Dodgen [EMAIL PROTECTED] wrote: Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test It hangs forever and never completes I have tried this on multiple boxes running both Fedora and Redhat ES, all 64 bit. Jim, I am using 3.5.6 (using the amalgamation... see the instructions I put on the SQLite wiki) and that worked well for me on both a Mac Leopard and a RHEL ES3 box. I see no reason to upgrade to 3.5.7 yet. That said, I also not working with 64 bit system. You might get better luck in getting an answer if you post at least the tail portion of the make output, otherwise no one has any idea where your process hangs. -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DBD::SQLite::Amalgamation?
On 3/31/08, P Kishor [EMAIL PROTECTED] wrote: On 3/30/08, Jim Dodgen [EMAIL PROTECTED] wrote: Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test It hangs forever and never completes I have tried this on multiple boxes running both Fedora and Redhat ES, all 64 bit. Jim, I am using 3.5.6 (using the amalgamation... see the instructions I put on the SQLite wiki) and that worked well for me on both a Mac Leopard and a RHEL ES3 box. I see no reason to upgrade to 3.5.7 yet. That said, I also not working with 64 bit system. You might get better luck in getting an answer if you post at least the tail portion of the make output, otherwise no one has any idea where your process hangs. It makes ok, here is the output from make test. the hang is after t/06error it never finishes DBD-SQLite-Amalgamation-3.5.7 # make test PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/00basic...ok t/01logon...ok t/02cr_tableok t/03insert..ok t/04select..ok t/05tranok t/06error...ok 1/2 (this never finishes) # uname -a Linux timmy 2.6.11-1.1369_FC4smp #1 SMP Thu Jun 2 23:16:33 EDT 2005 x86_64 x86_64 x86_64 GNU/Linuxperl # perl -v This is perl, v5.8.6 built for x86_64-linux-thread-multi -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Jim Dodgen [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DBD::SQLite::Amalgamation?
On 3/31/08, Jim Dodgen [EMAIL PROTECTED] wrote:
On 3/31/08, P Kishor [EMAIL PROTECTED] wrote:
On 3/30/08, Jim Dodgen [EMAIL PROTECTED] wrote:
Any Perl people out there using this yet (version 3.5.7)?
I'm continually having problems when doing make test
It hangs forever and never completes
I have tried this on multiple boxes running both Fedora and Redhat ES,
all 64 bit.
Jim,
I am using 3.5.6 (using the amalgamation... see the instructions I put
on the SQLite wiki) and that worked well for me on both a Mac Leopard
and a RHEL ES3 box. I see no reason to upgrade to 3.5.7 yet. That
said, I also not working with 64 bit system.
You might get better luck in getting an answer if you post at least
the tail portion of the make output, otherwise no one has any idea
where your process hangs.
It makes ok, here is the output from make test. the hang is after
t/06error it never finishes
DBD-SQLite-Amalgamation-3.5.7
# make test
PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e
test_harness(0, 'blib/lib', 'blib/arch') t/*.t
t/00basic...ok
t/01logon...ok
t/02cr_tableok
t/03insert..ok
t/04select..ok
t/05tranok
t/06error...ok 1/2
(this never finishes)
well, look in the t directory for the specific test. In my case, I see
the following --
use Test;
BEGIN { plan tests = 2 }
use DBI;
unlink('foo');
my $db = DBI-connect('dbi:SQLite:foo', '', '', { RaiseError = 1,
PrintError = 0 });
eval {
$db-do('ssdfsdf sdf sd sdfsdfdsf sdfsdf');
};
ok($@);
$db-do('create table testerror (a, b)');
$db-do('insert into testerror values (1, 2)');
$db-do('insert into testerror values (3, 4)');
$db-do('create unique index testerror_idx on testerror (a)');
eval {
$db-do('insert into testerror values (1, 5)');
};
ok($@);
You could follow from there and see what is actually failing, or where
it is getting stuck. Seems like a pretty simple test to me, so I can't
fathom where things are hanging.
If you want to live dangerously, you could also just force a make
anyway in spite of the hanging test and see if the installation works
for you. Then you could work back and try and figure out what is going
wrong.
# uname -a
Linux timmy 2.6.11-1.1369_FC4smp #1 SMP Thu Jun 2 23:16:33 EDT 2005
x86_64 x86_64 x86_64 GNU/Linuxperl
# perl -v
This is perl, v5.8.6 built for x86_64-linux-thread-multi
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] DBD::SQLite::Amalgamation?
Hi,
[...]
t/06error...ok 1/2
(this never finishes)
well, look in the t directory for the specific test. In my case, I see
the following --
[...]
my $db = DBI-connect('dbi:SQLite:foo', '', '', { RaiseError = 1,
I'm not certain what the call to DBI-connect() does exactly, I understand it
creates a database called 'foo' in the current directory. Is the current
directory mounted through NFS?
--
Dimitri
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] DBD::SQLite::Amalgamation?
Any Perl people out there using this yet (version 3.5.7)? I'm continually having problems when doing make test It hangs forever and never completes I have tried this on multiple boxes running both Fedora and Redhat ES, all 64 bit. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
