View Ticket
Not logged in
Ticket UUID: 34cbc91257922ed6226714e29899dacd5017dd0d
Title: problem serving fossil repos with old db schema from subdirectory
Status: Open Type: Code_Defect
Severity: Severe Priority:
Subsystem: Resolution: Open
Last Modified: 2011-03-19 11:51:09
Version Found In: [d04fa1e1438ec7] and after
Description & Comments:
While checking recent fossil ability to serve repos from subdirectory as implemented in [d04fa1e1438ec7] I encountered problem with serving repository with old db schema (repository test.fossil with config.aux-schema="2006-12-23" in my case served locally on win XP).

Steps to replicate:

1. copy old fossil repository into some subdirectory of directory, where fossil repos are served ("_qqq" in my case)

2.attempt to see it on http://localhost:8080/_qqq/test/timeline show following error:

Server Configuration Error

The database schema on the server is out-of-date. Please ask the administrator to run fossil rebuild.

3. rebuilding repo fails with test.fossil-journal file left in place:

c:\soft\bin\_qqq>fossil rebu -R .\test.fossil
C:\soft\bin\fossil.exe: out of memory
C:\soft\bin\fossil.exe: SQLITE_BUSY: statement aborts at 2: [ROLLBACK] cannot rollback transaction - SQL statements in progress

Serving repositories from "_qqq" subdir with uptodate db schema (config.aux-schema="2011-02-25 14:52") works fine. e.g.: http://localhost:8080/_qqq/myfossilclone/timeline

Now, I am unable to rebuild my old repo with newest fossil executable even in its original location.


drh added on 2011-03-19 11:51:09 UTC:
Please do this:

  1. Run "fossil sql -R old-repo.fossil" - followed by "vacuum" in order to clean up and recover the SQLite database which is the repository.
  1. Send me instructions on how I can download the repository file so that I can debug the problem. drh@sqlite.org