[sqlite] Commit failing with error SQLITE_ERROR

[Teg]

Hi all,

I have a multithreaded app using 3.5.1 latest on the site.

I "BEGIN EXCLUSIVE TRANSACTION;"

Add some data and then

"COMMIT;"

The COMMIT sometimes returns SQLITE_ERROR but, the error message is
"Select still in progress". I was under the impression I was supposed
to get a "SQLITE_BUSY" in this case and be allowed to retry until the
commit actually happens.

I'm using direct execution to BEGIN the transaction and the same to
COMMIT

                        nResult = sqlite3_exec
                        (
                                m_pDb,
                                pszQuery,
                                NULL,
                                NULL, 
                                &m_pszErrorMessage
                        );
                        if( nResult == SQLITE_OK )
                        {
                                break;
                        }
                        .....

Is there an update? Is this expected behavior? If I mutex the entire
process, I get no errors but, the performance is terrible.


Best regards,
 Teg                            mailto:[EMAIL PROTECTED]


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------