Hi! Does "pragma journal_mode=truncate;" make any difference? Is this on Windows? Do you have TortoiseSVN installed on the same system?
If you answer Yes to all these questions then use Google, I have already explained at least twice why it happens. Best regards, Filip Navara On Sun, Jan 10, 2010 at 4:59 AM, Nikolaus Rath <nikol...@rath.org> wrote: > Hello, > > I am accessing the same database from several threads, each using a > separate connection. Shared cache is not enabled. > > When my program has been running for a while, I suddenly get an > SQLITE_CANTOPEN error when I'm trying to open a database connection with > a new thread. The database file, however, is definitively present and > accessible. > > At the time of the error, there are probably around 30 threads holding > database connections, and with certainty less than 213. > > (213 is the total number of threads that the program has created at that > point, but most of them should have had only a short lifetime, so the > actual number of active connections should be much smaller. I did not > investigate the number of active threads closer, because even 213 active > connection doesn't seem like a critical number to me). > > Can someone tell me under which conditions sqlite returns > SQLITE_CANTOPEN, and how I can figure out what problem it encounters > exactly? > > > Best, > > > -Nikolaus > > -- > »Time flies like an arrow, fruit flies like a Banana.« > > PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C > > _______________________________________________ > 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
