Hi,
Rarely (I have 4 debug logs from all our beta testers) executing
'COMMIT' statement returns SQLITE_ERROR + 'SQL logic error or missing
database'. Analysis of the debug logs and source codes doesn't show
any problem, there simply begins a transaction, some SQL statements
are executed and COMMIT should finish it - but it doesn't.
Unfortunatelly SQLITE_ERROR is quite a generic term that doesn't tell
much. I tried to go through the places SQLite returns this message (I
don't have any deeper understanding of SQLite sources) and one place
that seems to be related to my problem is in
sqlite3PagerCommitPhaseTwo(), namely:
if( pPager->state<PAGER_RESERVED ){
return SQLITE_ERROR;
}
So, my questions to SQLite experts would be:
1. Do you think that the root of the problem could be here?
2. If not, where else to look for source of this problem?
3. Any suggestion where to place debug messages for the next release
in order to better locate the problem?
Thanks,
Jiri
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
