Hi, I just attempted to run a program which I had left alone for a couple weeks, and found that every sqlite query i try to run generates this in gdb:
Program received signal SIGSEGV, Segmentation fault.
0x40865d34 in sqliteSafetyOn () from /usr/lib/libsqlite.so.0
For a specific case, a statement that generates this is:
SELECT ( id ) FROM song where ( filename
=="/home/fwph/why-cooperation-with-rms-is-impossible.mp3" )
the relevant line of code(i'm using the compile/step method):
sqlite_compile (theDb, buffer, &tail, &vm, &err);
buffer contains the above string. theDb is a pointer to the database
already successfully opened. the three remaining double pointers are set
to NULL. The segfault occurs inside this call, according to gdb.
-i'm running gentoo linux kernel version 2.6.1, sqlite version 2.8.13 .
this is using optimization flags -O2 -march=athlon-mp -funroll-loops
-fomit-frame-pointer -pipe : i don't know if any of these could be
causing the trouble.
-i swear this was working two weeks ago..:) but i'm pretty sure i was
using 2.8.13 then, too. are there any libraries which may have been
updated on my system since then that could cause this breakdown? i'm
inclined to think this is something outside of sqlite, be it a problem
with optimization flags or external libraries, i don't know... i'm just
not sure where to start to try and debug this.
-if the dbase schema in question would be useful to answering this
question, i can post it. suffice to say, there is a table song with
field filename.
(fwph)
--
Frederick Heckel
[EMAIL PROTECTED]
(The strange attachment is my digital signature; do not be alarmed)
===================================================================
Applause, n:
The echo of a platitude from the mouth of a fool.
-- Ambrose Bierce
pgp00000.pgp
Description: PGP signature
