Unable to hotcopy SQLite database on Windows if >1Gb
|Reported by:||Owned by:|
|Severity:||normal||Keywords:||hotcopy database sqlite|
Description (last modified by )
- Trac 0.12
- Windows XP 64bits SP2 (should be reproduceable on any version of Windows)
How To Reproduce:
Assuming your Trac env use a large (>1Gb) SQLite database, when you use "trac-admin hotcopy ENV" (while Trac is running), the copy of the database fails at 1Gb.
Why : On Windows, when a SQLite DB is locked (eg, during a transaction), database file has an exclusive lock between 1Gb and 1Gb + 512bytes (see http://email@example.com/msg08077.html), so hotcopy fails to read it.
Proposition : When SQLite backend is used, skip the database file during the hotcopy process and use something like "sqlite3 trac.db .backup trac.db.bak" instead.