[Rtir] Upgrading RTIR

[Peter Bates]

-----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-----