[EMAIL PROTECTED] wrote:
I'm occasionally seeing ATTACH failing. sqlite_get_table_vprintf() is
returning SQLITE_ERROR (not SQLITE_LOCKED!) but the error string is set to
"database is locked". (The query is "ATTACH '/dbpath/global.db' AS global;")
The primary database (the open one to which I'm attempting to attach the
additional database) has previously been given a 60 second timeout with
sqlite_busy_timeout(hDB, 60000). Although it's possible that the database
being attached to is locked at the instant I issue the request, there is no
time that it remains locked for more than about 1 second. The ATTACH is not
occuring during a transaction, so the primary database should not be locked.
Any hints as to why I'm getting this error, or what to do to avoid it, would
be greatly appreciated.
Another fellow hit this same bug today. He wrote a ticket.
See http://www.sqlite.org/cvstrac/tktview?tn=514.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
