On Jan 14, 2010, at 7:44 AM, D. Richard Hipp wrote: > > 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.
Another possibility: You are using up all of your file descriptors. Are you sure there is no file descriptor leak in your path enumeration code? > > D. Richard Hipp > d...@hwaci.com > > > D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users