> > I am starting to believe that WAL is not a viable choice on a QNXsystem. > >
> All Blackberry phones and tables use it. It may be so, all Blackberry devices may be using WAL, but on my QNX system I just could not make it work. I haven't made a absolute statement, about SQLite and QNX, I just wrote a personal thought. I noticed that when PRAGMA main.journal_mode=WAL; statement is executed, the database file is locked in EXCLUSIVE mode, most likely to prevent the access from other processes/threads while the journal_mode is persisted into the database file. Later this EXCLUSIVE lock is never released. The next locks requests will fail. Regards, Sandu Buraga _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
