ccgus/fmdb — Issue #43: database locks after sqlite3_step
Author: isatech
Created: 2012-01-14 06:55:58+00:00
State: open

this is related to my old question about insert, i think i know where things are going wrong..

so i tried a simple insert, and stepped through the execution, and realize that the database locks right after line 704 of FMDatabase.m, which is

/* Call sqlite3_step() to run the virtual machine. Since the SQL being
** executed is not a SELECT statement, we assume no data will be returned.
*/
numberOfRetries = 0;
do {
rc = sqlite3_step(pStmt); <--- this one
retry = NO;

this is after the binding happens successfully, i can provide you with a video capture of the stepping if needed.

I close the database and then open it right before i open it again to run the update statement..

i looked around the web, and people suggest that it is a sqlite issue with NFS drives file locking mechanism, i have a mac os 10.6.8, and drive is autofs, which is a type of nfs i believe.

i am not expecting a fix from you, but some comments if you have any off the top of your head, i will to try this on a different machine as soon as i get the chance to.

thanks!

isaac