Hi,
Some time ago I asked here about a strange and very rare SQLite DB
problem that puzzles me, but unfortunatelly I got no answer. I'll try
to describe it again and hopefully someone will be able to comment
it...
Very rarely (I have just 5 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?
If you have any idea about what can be wrong, please let me know.
Thanks,
Jiri
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
