> Are you using a shared cache? You can get also get SQLITE_LOCKED when > using a shared cache. See section 2.2 of > <http://www.sqlite.org/sharedcache.html>. > > I've not used a shared cache myself. One day I was wondering if I > needed to worry about handling SQLITE_LOCKED errors and I came across > that page. Are these the only times you can get SQLITE_LOCKED errors? Ah-ha! We are in fact using the shared cache, which probably explains this. Any reason why SQLITE_LOCKED is returned instead of SQLITE_BUSY? With SQLITE_BUSY you can keep retrying until you decide to give up, or until it works, but you can't do that with SQLITE_LOCKED.
Cheers, Shawn _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users