Trac database failing?

[larceny-trac-import]

_Reported by: psellers on Fri Feb 8 15:53:53 2008 _ When searching or on certain links, TRAC responds with

Trac detected an internal error:

DatabaseError: database disk image is malformed

This might be a serious hint, that disks are failing or the DB is corrupt.

[larceny-trac-import]

Author: pnkfelix On the morning of February 26th 2008, PnkFelix attempted to fix this by generating a dump of the database (in the form of a sequence of SQL commands) and then restoring it from the dump.

Based on his readings of:

http://trac.edgewall.org/wiki/TracBackup

http://trac.edgewall.org/wiki/TracMigrate

Felix took the following steps (on uighur.ccs.neu.edu, our trac host):

% cd /proj/will/tov/
% source etc/profile 
% cd var/tracs/
% tracctl stop
tracd killed (29528)
% trac-admin larceny-trac hotcopy /scratch/pnkfelix/larceny-trac
Hotcopying /proj/will/tov/var/tracs/larceny-trac to /scratch/pnkfelix/larceny-trac ... Hotcopy done.
% sqlite3 /proj/will/tov/var/tracs/larceny-trac/db/trac.db ".dump" >> /scratch/pnkfelix/sqlite_larceny_trac.sql
% cp -p larceny-trac/db/trac.db larceny-trac/db/trac.db.pre-felix-attempt-export-import-fix
% rm larceny-trac/db/trac.db
% cat /scratch/pnkfelix/sqlite_larceny_trac.sql | sqlite3 /tmp/trac.db
% mv /tmp/trac.db larceny-trac/db/trac.db
% tracctl start
% pwd
/proj/will/tov/var/tracs
% tracctl stop
tracd killed (2260)
% cd larceny-trac/
% tracctl start

If you see an error that puts the blame on database malformation again, please put a comment on this ticket saying so, and if possible, give the steps to recreate the error.

[larceny-trac-import]

Author: pnkfelix We have moved to a CCIS hosted Trac. So we may want to close this ticket.