"D. Richard Hipp" <d...@hwaci.com> writes: > On Jan 12, 2010, at 6:58 AM, Ian Jackson wrote: > >> Nikolaus Rath writes ("Re: [sqlite] Reasons for SQLITE_CANTOPEN"): >>> Edzard Pasma <pasm...@concepts.nl> writes: >>>> Hope strace (see Roger Binns' post) will help you further. Also lsof >>>> may help. >>> >>> The problem was indeed that I reached the maximum number of fds. >>> Thanks >>> for the help! >> >> If SQLite had reported the errno value from the failed system call, >> the cause would have been obvious and this entire investigation would >> have been unnecessary. > > > sqlite3_file_control(db, "main", SQLITE_LAST_ERRNO, &errno_value);
This does not seem to work. With SQLite 3.6.22, errno seems to be always zero, especially also if there are no file descriptors left or the database file is not readable. See also: http://code.google.com/p/apsw/issues/detail?id=92 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