[sqlite] SQLITE_BUSY on rare occasions, single thread, single connection

[Jesper Baekdahl]

Hey everybody.

I'm getting SQLITE_BUSY on sqlite_step on insert statement, that is
part of an explicit transaction of multiple statements. There is only
1 thread and 1 connection, so there should not be anything holding a
lock.
It does not happen very often, so I'm having a hard time debugging it.
The code is something like this:
do {
        res = sqlite3_step(insert_statement);
        if( res == SQLITE_BUSY )
            usleep(1000);
} while ( res == SQLITE_BUSY);

And it will just hang there forever..

Looking foward to some advice.

Regards,

Jesper
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users