[rt-users] RT 3.8.0 DB migrate to 4.0.5 - Errors Please help!

[Kristian Davies]

On Tue, Jun 12, 2012 at 7:23 PM, FrankOh <frank.oh at red.com> wrote:
>
> OK i've searched all over the Internet and I can't seem to fix the problem.
> Currently in production we have RHEL (kernel 2.6.18-238.9.1.el5) with
> RT3.8.0 installed on mySQL 5.0.77. We want to move RT off of this physical
> box and put it on VM. At the same time upgrade to the latest RT 4.0.5.

I'm about to go on holiday so I can't respond fully but I went through
a similar process recently and had similar issues.

I treated the DB and the code separate.  Upgraded the database but the
code I installed new and migrated everything to make sure it all
worked.

With the DB I did some test with just the schema so 3.8.0 (mysqldump
-d mydb) to 3.8.11 then 3.8.11 to 4.0.0, then each step
(4.0.1/4.0.2/4.0.3/4.0.4/4.0.5), I was being quite careful :-)   I
then ran a tests with data.  I also ran at stage 4.0.0
etc/upgrade/upgrade-articles, etc/upgrade/vulnerable-passwords --fix,
etc/upgrade/shrink_transactions_table.pl,
etc/upgrade/shrink_cgm_table.pl, at 4.0.1 sbin/rt-validator --fix,
4.0.2 sbin/rt-validator --resolve

Sorry for the dump, but that seemed to work for me on our 11GB DB.

-Kristian