Upgrading RTIR

RTIR
1

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

2

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

3

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello allOn 12/11/2013 16:35, Jim Brandt wrote:

Did you apply the indexes mentioned here?

UPGRADING-3.0 - RTIR 3.0.4 Documentation - Best Practical

They help significantly with performance during the upgrade.

Apologies for missing this step - I think I had spotted
it during reading the different UPGRADING docs.

“Significantly” is an understatement - the upgrade then took
about a minute as opposed to spinning around for so many hours
I killed it off twice today.

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/

iQEcBAEBAgAGBQJSgmF8AAoJELhVoVpEMS6RkJsH/3h3ZtVTA/l9mnsTfEZ6QDyz
GUFfo0Ub0ZlTuVekqKwcOfM83pSydkKRYXW/JuEMX/tjEB5cYestQaj1VIYVTlwF
WguctgU2NBkhTYam725XcuwI9pyNtPIXQIDec6tsLLbpUCRteGCJIAL0cupPFtZn
qN88UO+eqZzBGjMsbnu83j6R78345dqOgiFtPC/rSI5eh60gYpzNrxyQVLDN+OJO
UV6OjRY4W8iLHfr/hfDim9zeSONChLxGQj/7BVx+LfBjZoaSCt7xXBnAaPwmuaci
uqLfnd5cmzcX/KBBzlL6kU0HfMrZ6++NJIkIY4+VfYbpWfCOtWpfrX5sO69lmNg=
=RtoK
-----END PGP SIGNATURE-----