En/na Luca Olivetti ha escrit: > En/na Luca Olivetti ha escrit: > >> Hello, >> I'm using sqlite 3.3.8 under linux (mandriva 2007.1). > > [...] > >> 1) is sqlite suitable when you have multiple threads accessing the same >> database? Or should I delegate the access in a single thread and >> serialize the queries from the various threads? >> 2) is sqlite suitable when you access the database from multiple programs? >> 3) why did the first error (rowid missing, wrong # of entries) occur? > > Is it possible that the problem is due to the fact that apparently 3.3.8 > didn't --enable-threadsafe by default (and neither did the distro > provided package)?
It happened again (I have two machines where my program is running, one I have updated to 3.5.6 with --enable-threadsafe, the other was still running 3.3.8 without --enable-threadsafe, this one is the one that failed, now I have upgraded it too), after a cascade of events the database was cleaned with no tables, but this time I saved a copy of the damaged file. Could it be useful to analyze the situation, or should I just assume that the problem was due to the missing "--enable-threadsafe"? (I'm starting to wonder if my questions are too stupid anyway, in such a case, please tell so). 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
