CODEWITHSUNDEEP
sqlite
James Raitsev
James Raitsev

Reputation: 96481

.journal files in SQLite

Quick google search revealed that

The rollback journal is always located in the same directory as the database file and has the same name as the database file except with the 8 characters "-journal" appended. The rollback journal is usually created when a transaction is first started and is usually deleted when a transaction commits or rolls back.

That's a lot of "usually" in one sentence.

If at the end of the day, one is left with multiple journal files, what is it a symptom of?

This seems to happen intermittently, i can't reliably reproduce the problem.

How would you troubleshoot an intermittent issue like this please? Would would be a likely culprit?

Update: I am running on OSX 10.8.2, SQLite version 3.7.14.1

Upvotes: 2

Views: 6081

Answers (1)

CL.
CL.

Reputation: 180182

The "usually"s are there because SQLite can be configured to use a persistent rollback journal.

It is not possible to have multiple journals for one database, because it is not possible to have multiple files with the same name.

Upvotes: 1

Related Questions