Ok, I have updated my database with analyze so that stat1 and stat4 tables have been created. I also have added an index to a table, in order to get rid a an auto index warning after each query. It seems that now out of some "Database locked" errors, I am not getting the original error message anymore.
I'll be monitoring that, and come back here if I find something weird again. Thanks all for your time and your input. Regards, -- Stéphane On Wed, Mar 12, 2014 at 12:36 AM, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Mar 11, 2014 at 6:59 PM, St. B. <sbart...@gmail.com> wrote: > > > HI, > > > > So I updated to V1.0.91 of SDS, but now I get the following error at each > > query run against the database : > > SQLite error (1): no such table: sqlite_stat1 > > > > What is the text of the query you are running? > > > > > > What should I do to get the table properly created? > > > > > > > > > > On Tue, Mar 11, 2014 at 12:50 PM, Simon Slavin <slav...@bigfraud.org> > > wrote: > > > > > > > > On 11 Mar 2014, at 11:06am, St. B. <sbart...@gmail.com> wrote: > > > > > > > There is one writing thread (every 5 minutes). The one writing thread > > > > writes in the same database, but it is on a different table. > > > > > > Have you set a timeout for all your database handles (or just the one > > > handle if they're all using the same handle): > > > > > > <http://www.sqlite.org/c3ref/busy_timeout.html> > > > > > > Many problems disappear if you set a timeout of ten seconds. > > > > > > Simon. > > > _______________________________________________ > > > 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 > > > > > > -- > D. Richard Hipp > d...@sqlite.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
