En/na Dennis Cote ha escrit: >> or should I just assume >> that the problem was due to the missing "--enable-threadsafe"? > > I wouldn't assume that. You should test it with a thread safe version to > see if the problem is resolved.
That's what I'm doing now (in fact I was already doing it on the other machine). I think I followed all the other guidelines to avoid problems, each thread has its own connection (or more than one), I have a busy handler in place, I only do queries with the automatic transaction or with "BEGIN EXCLUSIVE", I do a sqlite3_reset if the result isn't SQLITE_DONE or SQLITE_ROW and I always do a sqlite3_finalize, and I'm sure that no process crashed, so I really hope the problem came from the missing --enable-threadsafe (and maybe doing too many VACUUMs when it wasn't necessary, though I wouldn't have expected it to leave the database with no tables at all) otherwise I really don't know what to do. The thread safe version has been working 2 days now, but that means nothing (the non thread safe version worked for at least a week before failing). >> (I'm starting to wonder if my questions are too stupid anyway, in such a >> case, please tell so). > > Your questions aren't too stupid, just a little vague and without enough > detailed context info for anyone to offer much real assistance. Well, I posted all the error messages I got back from sqlite, as well as the snippet of code I use to execute all my queries, but I can post more details if it can be useful (I'd only need to know which details could be). Bye -- Luca Olivetti Wetron Automatización S.A. http://www.wetron.es/ Tel. +34 93 5883004 Fax +34 93 5883007 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
