Mayank Kumar (mayankum) wrote: > Sometimes we see the journal file not present on the system although > active transactions are ongoing. How is that possible since the > documentation says the journal file is always created in exclusive > mode ?
The journal file is created only when it is needed. The journal file is not needed for the locking itself; the exclusive lock is on the database file. > sometimes on our customers setup, we have seen a journal file of size > 10-20MB. Does that mean that the journal is still hot and has not been > used to recover or rollback ? That depends on the PRAGMA journal_mode setting. In the default DELETE mode, the journal file would be deleted on the COMMIT, so it being there implies that it's hot. Regards, Clemens
