On Tue, Jun 12, 2012 at 7:23 PM, FrankOh <[email protected]> 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
