[Rtir] Upgrading RTIR

[Jim Brandt]

Did you apply the indexes mentioned here?

http://bestpractical.com/docs/rtir/3.0/UPGRADING-3.0.html#MySQL

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.
> [31599] [Tue Nov 12 15:43:13 2013] [info]: Changed lifecycle of queue 'Incidents' to 'incidents' (./etc/upgrade/2.9.0/content:150)
> [31599] [Tue Nov 12 15:43:13 2013] [info]: Changed lifecycle of queue 'Incident Reports' to 'incident_reports' (./etc/upgrade/2.9.0/content:150)
> [31599] [Tue Nov 12 15:43:13 2013] [info]: Changed lifecycle of queue 'Investigations' to 'investigations' (./etc/upgrade/2.9.0/content:150)
> [31599] [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?
>
> Thanks.
>
> - --
> 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/
>
> iQEcBAEBAgAGBQJSgk/5AAoJELhVoVpEMS6RDlIIAJ9Wj3+tvy5452VHvrEyDyBa
> Cn9KND6gXUGST70SF2Q7WQepHpgzwPm8acND0jMIrJUES+u8ePH1fM6PeXpo1KZO
> UewcxHngY74HFBUKNRtQFeCYAytsp7yy+2mCoiclufGAJxXBS1iGyuDBk3wBp7bg
> mUsYRvsrDSl28NYitN6ugiG2Odc4wLnr8OPAwdpe6fWT+PWmbQxZzx2wtft7yefj
> RASb4IIir2jKvzCIBXMs0biGUa3mt0SOtPagfWURHUkhLHDTPVSe+iQCfMgoCJhG
> KyKhFpsNmjoUfMNoRz7yvEzKbLWud/EJkaDOwYk7HNKC4p7WpfpTrAfCAPfDxGY=
> =bEGE
> -----END PGP SIGNATURE-----
>

--