Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-15 Thread Nikolaus Rath
"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

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-12 Thread D. Richard Hipp
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.

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-12 Thread Ian Jackson
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

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-11 Thread Nikolaus Rath
Edzard Pasma writes: >> 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. > > Hope

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-11 Thread Edzard Pasma
Op 11-jan-2010, om 1:15 heeft Nikolaus Rath het volgende geschreven > Edzard Pasma writes: >> Op 10-jan-2010, om 19:25 heeft Nikolaus Rath het volgende geschreven: >> >>> Filip Navara writes: > I am accessing the same database from several

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-10 Thread Nikolaus Rath
Edzard Pasma writes: > Op 10-jan-2010, om 19:25 heeft Nikolaus Rath het volgende geschreven: > >> Filip Navara writes: I am accessing the same database from several threads, each using a separate connection. Shared cache is not enabled.

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-10 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nikolaus Rath wrote: > Can someone tell me under which conditions sqlite returns > SQLITE_CANTOPEN, and how I can figure out what problem it encounters > exactly? Start your program prefixed by 'strace -f -o /tmp/strace.log -s 200' and then look for

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-10 Thread Edzard Pasma
Op 10-jan-2010, om 19:25 heeft Nikolaus Rath het volgende geschreven: > Filip Navara writes: >>> 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

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-10 Thread Nikolaus Rath
Filip Navara writes: >> 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

Re: [sqlite] Reasons for SQLITE_CANTOPEN

2010-01-10 Thread Filip Navara
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,

[sqlite] Reasons for SQLITE_CANTOPEN

2010-01-09 Thread Nikolaus Rath
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,