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. Oh, BTW, this is with version 2.8.5. Thanks! Derrell --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
