[Pkg-trac-devel] Bug#501338: upgrade to trac 0.11 from lenny needs sqlite2->3 conversion

[Wookey]

Package: trac
Version: 0.11.1-2~bpo40+1
Severity: important

We have just upgraded trac to the version in lenny on an etch system,
using the package from backports.org, which appears to exactly
correspond to the normal lenny version.

After installing it trac-admin just gave backtrace errors complaining
of 'file is not a database file or is encrypted', whien we did the
recommended
trac-admin /srv/tcl/trac upgrade

We tried looking in /usr/share/doc/trac/README.Debian.gz and on the
trac wiki, but they had nothing to say about this.

Turned out that the problem was that our db/trac.db was in sqlite v2
format (from trac v0.10) and that trac v0.11 needs sqlite v3. A simple
sqlite db/trac.db .dump | sqlite3 db/trac.db3
meant that things then worked as expected.

This package really needs to give users a clue about this problem, as
it is likely to afflict anyone upgrading from the etch version of
trac. The README.Debian file should say something about it and provide
the above upgrade rune. A debconf warning about it is probably a good
idea too.

Unfortunately I guess it cannot be automatic because the install knows
nothing of the paths at which trac instances are installed.

Maybe there is something about a full lenny upgrade, or the version in
lenny itself which will mean that trac databases get automatically
upgraded, but I doubt it, so some clues for users are important to
avoid a lot of trac users wondering what to do when it breaks.

We'll update the trac wiki upgrade about this problem, which should help.


-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-6-686
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)

Versions of packages trac depends on:
ii  libjs-jquery             1.2.6-1~bpo40+1 JavaScript library for dynamic web
ii  python                   2.4.4-2         An interactive high-level object-o
ii  python-central           0.5.12          register and build utility for Pyt
ii  python-genshi            0.5.0-1~bpo40+1 Python XML-based template engine
ii  python-pysqlite2         2.3.2-2         python interface to SQLite 3
ii  python-setuptools        0.6c3-3         Python Distutils Enhancements
ii  python-subversion        1.4.2dfsg1-2    Python bindings for Subversion
ii  subversion               1.4.2dfsg1-2    Advanced version control system

Versions of packages trac recommends:
ii  apache [httpd]          1.3.34-4.1+etch1 versatile, high-performance HTTP s
ii  apache2                 2.2.3-4+etch5    Next generation, scalable, extenda
ii  apache2-mpm-prefork [ht 2.2.3-4+etch5    Traditional model for Apache HTTPD
ii  enscript                1.6.4-11         Converts ASCII text to Postscript,
ii  python-tz               2006p-0.1        Python version of the Olson timezo

-- no debconf information

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________