fike at cs
Nov 23, 2006, 4:59 AM
Post #1 of 1
(669 views)
Permalink
|
|
database disk image is malformed
|
|
One Trac env ended up with this error;
DatabaseError: database disk image is malformed
I tried resync which generated the output;
Resyncing repository history...
Done.
But the error was still present, then tried;
sqlite3 trac.db.damaged .dump | sqlite3 trac.db
Which generated the output;
SQL error: no such table: main.wiki
SQL error: no such table: main.revision
SQL error: no such table: main.ticket
SQL error: no such table: main.ticket
SQL error: no such table: main.node_change
SQL error: no such table: main.session
SQL error: no such table: main.session
SQL error: no such table: main.ticket_change
SQL error: no such table: main.ticket_change
Database generated was 5K, the damaged db is 5M. I had a backup
db from my upgrade to .10.2 and it is now being used to keep the site
running but it is 1.3M smaller, and a week older then the damaged db.
Would still like to restore the damaged db if possible.
Any ideas?
Thanks,
-------------------------------------------------
Traceback (most recent call last):
File "/sw/apps/python/lib/python2.4/site-packages/trac/web/main.py",
line 387, in dispatch_request
dispatcher.dispatch(req)
File "/sw/apps/python/lib/python2.4/site-packages/trac/web/main.py",
line 191, in dispatch
req.perm = PermissionCache(self.env, req.authname)
File "/sw/apps/python/lib/python2.4/site-packages/trac/perm.py", line
267, in __init__
self.perms = PermissionSystem(env).get_user_permissions(username)
File "/sw/apps/python/lib/python2.4/site-packages/trac/perm.py", line
231, in get_user_permissions
for perm in self.store.get_user_permissions(username):
File "/sw/apps/python/lib/python2.4/site-packages/trac/perm.py", line
111, in get_user_permissions
cursor.execute("SELECT username,action FROM permission")
File "/sw/apps/python/lib/python2.4/site-packages/trac/db/util.py", line
51, in execute
return self.cursor.execute(sql)
File
"/sw/apps/python/lib/python2.4/site-packages/trac/db/sqlite_backend.py",
line 56, in execute
args or [])
File
"/sw/apps/python/lib/python2.4/site-packages/trac/db/sqlite_backend.py",
line 48, in _rollback_on_error
return function(self, *args, **kwargs)
DatabaseError: database disk image is malformed
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To post to this group, send email to trac-users[at]googlegroups.com
To unsubscribe from this group, send email to trac-users-unsubscribe[at]googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
|
