GNOME Bugzilla – Bug 568093
crash with latest revision 3285
Last modified: 2009-02-18 20:39:28 UTC
Using Anjuta I've got a crash with libgda rev 3285. Everything worked fine with 3284. Program received signal SIGSEGV, Segmentation fault.
+ Trace 211618
Thread 3001301904 (LWP 16776)
Can you check if you still have the crash with when replacing the contents of the libgda/sqlite/sqlite-src with what it was in rev #3284? (rev #3285 has been moved to SQLite 3.6.10)
Actually with libgda/sqlite/sqlite-src to rev 3284 I don't have a crash anymore.
Ok, thanks! Could you try to provide a simple standalone program which reproduces the crash so I can investigate?
Created attachment 126795 [details] reproduceable crash. here it is. Finally I got it crash and I was able to isolate the bug. I took some anjuta connecting/executing code and I simply placed it in a example.c. I included also the .anjuta_sym_db.db SQLite db which is responsible for the crash. Sorry for the 2.5 MB size but it was necessary. oh well, I forgot the main point: it seems that the crash was due to PRAGMA journal_mode = OFF we absolutely need this pragma for speed and usability issues, so I don't think it's a good thing to remove. here it is my stack trace Program received signal SIGSEGV, Segmentation fault.
+ Trace 211686
Thread 3078633216 (LWP 21731)
ps2: I cannot have bugzilla to upload the 2.5 MB file. I'll send it to you by mail.
Bug reported to SQLite's developers, see http://www.sqlite.org/cvstrac/tktview?tn=3603
there's still no sqlite 3.6.11. I suppose you'll ship for the release with the current sqlite version? (No problems about it, I'm just wondering...)
I think that yes, the V4 will be with Sqlite 3.6.7, except if a 3.6.1 comes out quickly enough so the Anjuta team can make sure it's ok (and of course Libga's own tests are Ok).
Today SQLite released 3.6.11, and: - it is explicitely said that upgrading from versions prior to 3.6.10 is recommended - this bug seems to be resolved with this version - Libgda's tests all pass with that version so I put it into Libgda rev #3326. Can you please check there is no more problem with Anjuta and that version? If so I'll ship V4 with this version of SQLite.
all good here, at least for the tests I had. Seems like the nasty bug has gone.
Ok, so I'm closing this bug and keeping 3.6.11 in Libgda.