I did see some persistent database locks in WAL mode in SQLite 3.7.4 and previous versions (I don't test 3.7.5 yet ) and all queries are failed with message about database locked by write query. So we need vacuum database, try change to "delete" mode and vacuum again... In "delete" mode these applications work fine a lot of time. But I can't write tests for reproducing the problem. My hosts are using 32bit and 64bit debian linux (squeeze) with ext3 filesystem. So WAL may be dangerous for some projects now.
2011/2/3 Dustin Sallings <[email protected]> > > On Feb 2, 2011, at 8:14, Duquette, William H (318K) wrote: > > > In SQLite 3.7.4/3.7.5, does WAL seem to be stable enough for production > use? > > > I'm using it very, very heavily right now. > > -- > dustin sallings > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
