[rt-users] Problems upgrading from 3.9.3

[Gary Mason]

HI,

I am in the process of migrating my current RT to a brand new separate 
server running Debian/Postgresql and RT 4.0.7 installed via backports.

I have managed to import the dump of the database into the new system, 
and have set about upgrading the database.  I already have RT4.0.7 
working fine with some test data I put into the initial system - just 
need to get the historical ticket information in now.

I started out at version 3.6.7 using the following command :-

# rt-setup-database-4 --action upgrade --dba postgres 
--prompt-for-dba-password

That was fine for a couple of the versions, but it fell over a couple of 
times at various points, and I had to resort to forcing through those 
upgrades manually, usually with a command like the following :-

# rt-setup-database-4 --action insert  --datadir 
/usr/share/request-tracker4/etc/upgrade/3.8.3 --dba postgres

That worked fine up to version 3.9.3.  When I try to upgrade from that 
version, I get the following errors :-

root at rta-01:/etc/request-tracker4# rt-setup-database-4 --action upgrade 
--dba postgres --prompt-for-dba-password
In order to create or update your RT database, this script needs to 
connect to your  Pg instance on localhost as postgres
Please specify that user's database password below. If the user has no 
database
password, just press return.

Password:
Working with:
Type:    Pg
Host:    localhost
Name:    rtdb
User:    rtuser
DBA:    postgres
Enter RT version you're upgrading from: 3.9.2

Going to apply following upgrades:
* 3.9.3
* 3.9.5
* 3.9.6
* 3.9.7
* 3.9.8
* 4.0.0rc2
* 4.0.0rc4
* 4.0.0rc7
* 4.0.1
* 4.0.3
* 4.0.4
* 4.0.6

Enter RT version if you want to stop upgrade at some point,
   or leave it blank if you want apply above upgrades:

IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
Processing 3.9.3
Now populating database schema.
DBD::Pg::st execute failed: ERROR:  column "delegatedby" of relation 
"acl" does not exist at /usr/share/request-tracker4/lib/RT/Handle.pm 
line 515.

I tried manually upgrading that version, but that failed too, with a 
different message :-

# rt-setup-database-4 --action insert  --datadir 
/usr/share/request-tracker4/etc/upgrade/3.9.3 --dba postgres
In order to create or update your RT database, this script needs to 
connect to your  Pg instance on localhost as postgres
Please specify that user's database password below. If the user has no 
database
password, just press return.

Password:
Working with:
Type:    Pg
Host:    localhost
Name:    rtdb
User:    rtuser
DBA:    postgres
Now inserting data.
Couldn't finish 'insert' step.

ERROR: Couldn't load data from 
'/usr/share/request-tracker4/etc/upgrade/3.9.3/content' for import:

ERROR:Can't locate /usr/share/request-tracker4/etc/upgrade/3.9.3/content 
in @INC (@INC contains: /usr/local/share/request-tracker4/lib 
/usr/share/request-tracker4/lib /etc/perl /usr/local/lib/perl/5.10.1 
/usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 
/usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at 
/usr/share/request-tracker4/lib/RT/Handle.pm line 762.


Anyone have any idea how I can get the upgrade through this particular 
version ?

Thanks,
Gary