[request-tracker-maintainers] Bug#603247: Bug#603247: request-tracker3.8: loading 3.6 database in 3.8 fails with "namespace error : Failed to parse QName 'Pref-RT:'"

[Dominic Hargreaves]

On Fri, Nov 12, 2010 at 03:42:43PM +0800, James Andrewartha wrote:
> I've installed request-tracker3.8 and it's working, now I'm trying to import
> the db from 3.6. I dumped it with 'rt-dump-database-3.6 0 > rt-db-3.6.dump' 
> then tried to load it with
> 'rt-setup-database-3.8 --action insert --datafile rt-db-3.6.dump'
> which gives the following output:
> 
> In order to create or update your RT database, this script needs to connect to your  mysql instance on localhost as request-tracker3
> Please specify that user's database password below. If the user has no database
> password, just press return.

..

> Now inserting data
> Couldn't finish 'insert' step.
> 
> ERROR: Couldn't load data from 'rt-db-3.6.dump' for import:
> 
> ERROR::122461: namespace error : Failed to parse QName 'Pref-RT:'
>       <Pref-RT::Attribute-1>

I've no idea if the rt-dump-database from 3.6 is intended to work with
3.8. The name of that utility, as well as the manpage (provided by
Debian, so we should probably improve it) are misleading as to the
purpose of the utility.

For dumping and loading a database you almost certainly just need to
use mysql's own dump and load commands, paying close attention to
/usr/share/doc/request-tracker3.8/UPGRADING.mysql as Stefan (below)
suggests. Note that the referenced upgrade script is at
/usr/share/request-tracker3.8/etc/upgrade/upgrade-mysql-schema.pl
on Debian systems.

This bug report can probably serve as a valid documentation bug,
noting that the manpage can be improved; and also that the
UPGRADING.mysql file could be tweaked slightly for MySQL upgrades.

On Fri, Nov 12, 2010 at 09:55:59AM +0100, Stefan Hornburg (Racke) wrote:

> I recommend to be very careful when upgrading RT database to 3.8. Please make sure that you read and understand UPGRADING.myql.
> Otherwise you end up with broken data which cannot fixed in a sane way in retrospect.

-- 
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)