Re: Where is the journal file for locking_mode=EXCLUSIVE?
Olivier Mascia <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
> Le 30 janv. 2020 à 15:05, Peng Yu <[email protected]> a écrit : > > https://www.sqlite.org/tempfiles.html > > The above page says that there should be a journal file. > > "The PERSIST journal mode foregoes the deletion of the journal file > and instead overwrites the rollback journal header with zeros, which > prevents other processes from rolling back the journal and thus has > the same effect as deleting the journal file, though without the > expense of actually removing the file from disk." > > But I don't see it. Does anybody why I don't see the journal file? > What does "normal" printed mean? > > $ sqlite3 /tmp/dbfile -header -separator $'\t' <<EOF > pragma locking_mode=persist; Minor confusion between the pragma locking_mode and pragma journal_mode. You want pragma journal_mode=persist here, not pragma locking_mode=persist, which does not exists. ⏤ Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit freundlichen Grüßen, Olivier Mascia _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users