id summary reporter owner description type status priority milestone component version severity resolution keywords cc branch changelog apichanges internalchanges 11013 Unable to hotcopy SQLite database on Windows if >1Gb pdecourcel@… "System Information: - 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://www.mail-archive.com/sqlite-users@sqlite.org/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." defect new low next-major-releases admin/console 0.12 normal hotcopy database sqlite