On Fri, Mar 1, 2019 at 4:09 PM Simon Slavin <slav...@bigfraud.org> wrote:
> On 1 Mar 2019, at 10:27am, Lloyd <lloydkl.t...@gmail.com> wrote: > > > I am able to serialize, deserialize and prepare a SQL query against the > rollback database. When I do the same against the WAL database file, the > 'prepare' statement fails with code '1'. > > It's possible that some of the data for the WAL database is in the journal > and hasn't been written back to the database properly. Was that database > correctly closed when last used ? > > Using the SQLite command-line tool, > open the database > run "PRAGMA integrity_check;" on it > close the database > > Then try serializing it again. If still fails, do the above again but > "VACUUM;" it instead of the integrity_check. > > Simon. > I forgot to mention that the database is in a good state. No temp WAL/SHM files exist in the directory. I tried the steps you suggested. Integrity check returned 'ok'. Executed vacuum command also. Still, the prepare statement fails with 1. This is a small test database created. I closed the database from shell using '.quit' command. I believe that it closes the connection properly. > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
