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;
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.
Does the problem happen on hfs drives?