[Rtir] Upgrading RTIR
jbrandt at bestpractical.com
Tue Nov 12 11:35:03 EST 2013
Did you apply the indexes mentioned here?
They help significantly with performance during the upgrade.
On 11/12/13 10:57 AM, Peter Bates wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> Hello all
> First post from me - so apologies if this is a dumb question.
> I've had RT 3.8.15 and RTIR 2.6.1 on a test system for some time.
> Trying to move things into production, I'm upgrading to RT 4.0.18
> and RTIR 3.0.0.
> I dumped my 'rt3' database (MySQL) as a backup with
> mysqldump --opt --skip-lock-tables --single-transaction --default-character-set=binary -u rt_user -pXX rt3 > rt3-backup
> I then imported that back into 'rt4' and installed RT, which all seemed to go fine.
> Trying to then install RTIR:
> perl Makefile.PL
> make install
> make upgrade-database
> Enter RT::IR version you're upgrading from: 2.6.1
> I get:
> Processing 2.6.2
> Now inserting data.
> Processing 2.9.0
> Now inserting data.
>  [Tue Nov 12 15:43:13 2013] [info]: Changed lifecycle of queue 'Incidents' to 'incidents' (./etc/upgrade/2.9.0/content:150)
>  [Tue Nov 12 15:43:13 2013] [info]: Changed lifecycle of queue 'Incident Reports' to 'incident_reports' (./etc/upgrade/2.9.0/content:150)
>  [Tue Nov 12 15:43:13 2013] [info]: Changed lifecycle of queue 'Investigations' to 'investigations' (./etc/upgrade/2.9.0/content:150)
>  [Tue Nov 12 15:43:13 2013] [info]: Changed lifecycle of queue 'Blocks' to 'blocks' (./etc/upgrade/2.9.0/content:150)
> And the process just seems to sit there.
> mysqladmin processlist shows:
> | 51 | rt_user | localhost | rt4 | Query | 621 | Sending data | DELETE FROM ObjectCustomFieldValues WHERE id IN (SELECT main.OldReference AS oldreference FROM Trans |
> After a couple of hours this morning I gave up.
> Before I throw out my data (users and configuration - there aren't really
> any active tickets in the DB) and just install RT 4.0.18 and then RTIR from scratch
> - - is there anything I'm missing?
> - --
> Peter Bates
> Senior Information Security Officer Phone: +44(0)2076792049
> Information Services Division Internal Ext: 32049
> University College London
> London WC1E 6BT
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.13 (MingW32)
> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
> -----END PGP SIGNATURE-----
More information about the Rtir