On Jan 14, 2010, at 12:06 AM, Jamie Hardt wrote: > > So, has anyone else run into SQLITE_CANTOPEN in a situation where it > wasn't a permissions issue? >
My guess would be that the SQLite database is located in the same directory hierarchy that you are indexing and that somehow the system calls you are making to enumerate the paths are interfering with SQLite's ability to write to the database. The fact that it is a CANTOPEN error suggests that it was trying to open a new rollback journal. You might work around the problem by putting all of your inserts inside a single big transaction. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users