thumbs.db-journal

[jcldl]

I am compacting my database. I have now a third file I never noticed before:" idimager.thumbsdb-journal" It's a very large file: more than 10 go, and backup after 2 hours is not yet finished. What is this file? The two others are cat.db and thumbs.db.
AND Now after more than two hours this file disappeared and compacting stopped.

[Hert]

A Journal file is a temporary file that holds "undo" information (a rollback file).

From the SQLite documentation:

2.1 Rollback Journals

A rollback journal is a temporary file used to implement atomic commit and rollback capabilities in SQLite. (For a detailed discussion of how this works, see the separate document titled Atomic Commit In SQLite.) 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. The rollback journal file is essential for implementing the atomic commit and rollback capabilities of SQLite. Without a rollback journal, SQLite would be unable to rollback an incomplete transaction, and if a crash or power loss occurred in the middle of a transaction the entire database would likely go corrupt without a rollback journal.

The rollback journal is usually created and destroyed at the start and end of a transaction, respectively. But there are exceptions to this rule.

[jcldl]

Thank You, now I understand.