Upgrade from 3.6.11 to 4.0.4 More Errors

Here’s the entire situation.
I have been tasked with migrating and upgrading our rt system to a new
system, complete with MySQL 5, CentOS 6, and all the latest and greatest.
At this point I have followed the README and the UPGRADING.mysql
documentation and followed everything there. When running make
upgrade-database the first time, and only upgrading to 3.7.87 after of
course changing the MySQL default character set, I did not receive any
errors. Once I completed that, then ran the upgrade-mysql-schema.pl part,
I came back to run the make upgrade-database again, and upon doing so got
the following errors:
DB Upgrade Errors:
make upgrade-database
/usr/bin/perl -I/storage/www/rt3/local/lib -I/storage/www/rt3/lib
sbin/rt-setup-database --action upgrade --prompt-for-dba-password
Odd number of elements in anonymous hash at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1071.
Use of uninitialized value $[8] in anonymous hash ({}) at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1071.
Odd number of elements in hash assignment at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1072.
Use of uninitialized value within @
in list assignment at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1072.
Subroutine _InitSQL redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 63.
Subroutine _SQLLimit redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 87.
Subroutine _SQLJoin redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 106.
Subroutine _OpenParen redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 116.
Subroutine _CloseParen redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 119.
Subroutine _close_bundle redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 170.
Subroutine _parser redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 201.
Subroutine ClausesToSQL redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 377.
Subroutine FromSQL redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 477.
Subroutine Query redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 543.
In order to create or update your RT database, this script needs to connect
to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt3
User: rt_user
DBA: root
Enter RT version you’re upgrading from: 3.7.87

Going to apply following upgrades:

  • 3.8.0
  • 3.8.1
  • 3.8.2
  • 3.8.3
  • 3.8.4
  • 3.8.6
  • 3.8.8
  • 3.8.9
  • 3.9.1
  • 3.9.2
  • 3.9.3
  • 3.9.5
  • 3.9.6
  • 3.9.7
  • 3.9.8
  • 4.0.0rc2
  • 4.0.0rc4
  • 4.0.0rc7
  • 4.0.1
  • 4.0.3
  • 4.0.4

Enter RT version if you want to stop upgrade at some point,
or leave it blank if you want apply above upgrades:

IT’S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
Processing 3.8.0
Now inserting data.
Processing 3.8.1
Now inserting data.
Processing 3.8.2
Now inserting data.
[Fri Nov 18 18:26:20 2011] [warning]: Going to add [OLD] prefix to all
templates in approvals queue. If you have never used approvals, you can
safely delete all the templates with the [OLD] prefix. Leave the new
Approval templates because you may eventually want to start using
approvals. (./etc/upgrade/3.8.2/content:3)
[Fri Nov 18 18:26:21 2011] [warning]: IMPORTANT: We’re going to delete all
scrips in Approvals queue and save them in ‘rt-approvals-scrips-KyRb’ file.
(./etc/upgrade/3.8.2/content:165)
Processing 3.8.3
Now inserting data.
[Fri Nov 18 18:26:27 2011] [error]: Template not found
(/home/jared/rt-4.0.4/sbin/…/lib/RT/Handle.pm:1037)
Processing 3.8.4
Now inserting data.
Processing 3.8.6
Now inserting data.
Processing 3.8.8
Now inserting data.
[Fri Nov 18 18:26:44 2011] [warning]: Couldn’t set SortOrder: That is
already the current value (./etc/upgrade/3.8.8/content:32)
Processing 3.8.9
Now inserting data.
[Fri Nov 18 18:26:50 2011] [warning]: Resolver RT::URI::fsck_com_rt could
not parse fsck.com-rt://gdmxchange.com/ticket/, maybe Organization config
was changed? (/home/jared/rt-4.0.4/sbin/…/lib/RT/URI.pm:146)
[Fri Nov 18 18:26:50 2011] [warning]: Use of uninitialized value in string
eq at /home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm line 627, <> line 1.
(/home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm:627)
[Fri Nov 18 18:26:50 2011] [warning]: Use of uninitialized value in string
eq at /home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm line 627, <> line 1.
(/home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm:627)
[Fri Nov 18 18:26:50 2011] [warning]: Use of uninitialized value in string
eq at /home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm line 627, <> line 1.
(/home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm:627)
Processing 3.9.1
Now inserting data.
Processing 3.9.2
Now inserting data.
Processing 3.9.3
Now populating database schema.
Processing 3.9.5
Now populating database schema.
Processing 3.9.6
Now populating database schema.
Processing 3.9.7
Now populating database schema.
Now inserting data.
Processing 3.9.8
Now populating database schema.
Now inserting data.
Processing 4.0.0rc2
Now populating database schema.
Processing 4.0.0rc4
Now populating database schema.
Processing 4.0.0rc7
Now inserting data.
Processing 4.0.1
Now inserting data.
Processing 4.0.3
Now inserting data.
Processing 4.0.4
Now inserting data.
Done.

Is that normal to see those errors?

Also, when restarting the Apache server, I am getting the following errors
from that:
HTTPD Restart
Starting httpd: Odd number of elements in anonymous hash at
/storage/www/rt3/sbin/…/lib/RT/Config.pm line 1071.
Use of uninitialized value $[8] in anonymous hash ({}) at
/storage/www/rt3/sbin/…/lib/RT/Config.pm line 1071.
Odd number of elements in hash assignment at
/storage/www/rt3/sbin/…/lib/RT/Config.pm line 1072.
Use of uninitialized value within @
in list assignment at
/storage/www/rt3/sbin/…/lib/RT/Config.pm line 1072.

Is that normal as well?

Another fun fact is that I also moved the install from the default /opt to
the /storage location in the error messages. Would this be causing the
issues even though when I ran the configure I made sure to specify the new
location?

When we recently upgraded from 3.8.4 to 4.0.2 we also received:
[warning]: Couldn’t set SortOrder: That is already the current value (./etc/upgrade/3.8.8/content:32)
and
[warning]: Use of uninitialized value in string eq at /home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm

With these, our RT instance runs fine.

I do not have any errors when trying to restart Apache though. Just my $0.02 worth.From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jared Griffith
Sent: Friday, November 18, 2011 12:46 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Upgrade from 3.6.11 to 4.0.4 More Errors

Here’s the entire situation.
I have been tasked with migrating and upgrading our rt system to a new system, complete with MySQL 5, CentOS 6, and all the latest and greatest. At this point I have followed the README and the UPGRADING.mysql documentation and followed everything there. When running make upgrade-database the first time, and only upgrading to 3.7.87 after of course changing the MySQL default character set, I did not receive any errors. Once I completed that, then ran the upgrade-mysql-schema.plhttp://upgrade-mysql-schema.pl part, I came back to run the make upgrade-database again, and upon doing so got the following errors:
DB Upgrade Errors:
make upgrade-database
/usr/bin/perl -I/storage/www/rt3/local/lib -I/storage/www/rt3/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password
Odd number of elements in anonymous hash at /home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1071.
Use of uninitialized value $[8] in anonymous hash ({}) at /home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1071.
Odd number of elements in hash assignment at /home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1072.
Use of uninitialized value within @
in list assignment at /home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1072.
Subroutine _InitSQL redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 63.
Subroutine _SQLLimit redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 87.
Subroutine _SQLJoin redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 106.
Subroutine _OpenParen redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 116.
Subroutine _CloseParen redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 119.
Subroutine _close_bundle redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 170.
Subroutine _parser redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 201.
Subroutine ClausesToSQL redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 377.
Subroutine FromSQL redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 477.
Subroutine Query redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 543.
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt3
User: rt_user
DBA: root
Enter RT version you’re upgrading from: 3.7.87

Going to apply following upgrades:

  • 3.8.0
  • 3.8.1
  • 3.8.2
  • 3.8.3
  • 3.8.4
  • 3.8.6
  • 3.8.8
  • 3.8.9
  • 3.9.1
  • 3.9.2
  • 3.9.3
  • 3.9.5
  • 3.9.6
  • 3.9.7
  • 3.9.8
  • 4.0.0rc2
  • 4.0.0rc4
  • 4.0.0rc7
  • 4.0.1
  • 4.0.3
  • 4.0.4

Enter RT version if you want to stop upgrade at some point,
or leave it blank if you want apply above upgrades:

IT’S VERY IMPORTANT TO BACK UP BEFORE THIS STEP

Proceed [y/N]:y
Processing 3.8.0
Now inserting data.
Processing 3.8.1
Now inserting data.
Processing 3.8.2
Now inserting data.
[Fri Nov 18 18:26:20 2011] [warning]: Going to add [OLD] prefix to all templates in approvals queue. If you have never used approvals, you can safely delete all the templates with the [OLD] prefix. Leave the new Approval templates because you may eventually want to start using approvals. (./etc/upgrade/3.8.2/content:3)
[Fri Nov 18 18:26:21 2011] [warning]: IMPORTANT: We’re going to delete all scrips in Approvals queue and save them in ‘rt-approvals-scrips-KyRb’ file. (./etc/upgrade/3.8.2/content:165)
Processing 3.8.3
Now inserting data.
[Fri Nov 18 18:26:27 2011] [error]: Template not found (/home/jared/rt-4.0.4/sbin/…/lib/RT/Handle.pm:1037)
Processing 3.8.4
Now inserting data.
Processing 3.8.6
Now inserting data.
Processing 3.8.8
Now inserting data.
[Fri Nov 18 18:26:44 2011] [warning]: Couldn’t set SortOrder: That is already the current value (./etc/upgrade/3.8.8/content:32)
Processing 3.8.9
Now inserting data.
[Fri Nov 18 18:26:50 2011] [warning]: Resolver RT::URI::fsck_com_rt could not parse fsck.com-rt://gdmxchange.com/ticket/http://gdmxchange.com/ticket/, maybe Organization config was changed? (/home/jared/rt-4.0.4/sbin/…/lib/RT/URI.pm:146)
[Fri Nov 18 18:26:50 2011] [warning]: Use of uninitialized value in string eq at /home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm line 627, <> line 1. (/home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm:627)
[Fri Nov 18 18:26:50 2011] [warning]: Use of uninitialized value in string eq at /home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm line 627, <> line 1. (/home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm:627)
[Fri Nov 18 18:26:50 2011] [warning]: Use of uninitialized value in string eq at /home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm line 627, <> line 1. (/home/jared/rt-4.0.4/sbin/…/lib/RT/Template.pm:627)
Processing 3.9.1
Now inserting data.
Processing 3.9.2
Now inserting data.
Processing 3.9.3
Now populating database schema.
Processing 3.9.5
Now populating database schema.
Processing 3.9.6
Now populating database schema.
Processing 3.9.7
Now populating database schema.
Now inserting data.
Processing 3.9.8
Now populating database schema.
Now inserting data.
Processing 4.0.0rc2
Now populating database schema.
Processing 4.0.0rc4
Now populating database schema.
Processing 4.0.0rc7
Now inserting data.
Processing 4.0.1
Now inserting data.
Processing 4.0.3
Now inserting data.
Processing 4.0.4
Now inserting data.
Done.

Is that normal to see those errors?

Also, when restarting the Apache server, I am getting the following errors from that:
HTTPD Restart
Starting httpd: Odd number of elements in anonymous hash at /storage/www/rt3/sbin/…/lib/RT/Config.pm line 1071.
Use of uninitialized value $[8] in anonymous hash ({}) at /storage/www/rt3/sbin/…/lib/RT/Config.pm line 1071.
Odd number of elements in hash assignment at /storage/www/rt3/sbin/…/lib/RT/Config.pm line 1072.
Use of uninitialized value within @
in list assignment at /storage/www/rt3/sbin/…/lib/RT/Config.pm line 1072.

Is that normal as well?

Another fun fact is that I also moved the install from the default /opt to the /storage location in the error messages. Would this be causing the issues even though when I ran the configure I made sure to specify the new location?

Odd number of elements in anonymous hash at /home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line
1071.
Use of uninitialized value $[8] in anonymous hash ({}) at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1071.
Odd number of elements in hash assignment at /home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm
line 1072.
Use of uninitialized value within @
in list assignment at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1072.
Subroutine _InitSQL redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 63.
Subroutine _SQLLimit redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 87.
Subroutine _SQLJoin redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 106.
Subroutine _OpenParen redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 116.
Subroutine _CloseParen redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 119.
Subroutine _close_bundle redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 170.
Subroutine _parser redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 201.
Subroutine ClausesToSQL redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 377.
Subroutine FromSQL redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 477.
Subroutine Query redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 543.

Another fun fact is that I also moved the install from the default /opt to the /storage
location in the error messages. Would this be causing the issues even though when I ran the
configure I made sure to specify the new location?

You appear to have installed RT4 on top of an existing RT3 install

This is warned against pretty vigorously in the first part of
docs/UPGRADING-4.0

-kevin

Can I use the same RT_SiteConfig.pm from the 3 install?On Fri, Nov 18, 2011 at 11:03 AM, Kevin Falcone falcone@bestpractical.comwrote:

On Fri, Nov 18, 2011 at 10:46:04AM -0800, Jared Griffith wrote:

Odd number of elements in anonymous hash at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line
1071.
Use of uninitialized value $[8] in anonymous hash ({}) at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1071.
Odd number of elements in hash assignment at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm
line 1072.
Use of uninitialized value within @
in list assignment at
/home/jared/rt-4.0.4/sbin/…/lib/RT/Config.pm line 1072.
Subroutine _InitSQL redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 63.
Subroutine _SQLLimit redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 87.
Subroutine _SQLJoin redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 106.
Subroutine _OpenParen redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 116.
Subroutine _CloseParen redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 119.
Subroutine _close_bundle redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 170.
Subroutine _parser redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 201.
Subroutine ClausesToSQL redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 377.
Subroutine FromSQL redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 477.
Subroutine Query redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 543.

Another fun fact is that I also moved the install from the default
/opt to the /storage
location in the error messages. Would this be causing the issues even
though when I ran the
configure I made sure to specify the new location?

You appear to have installed RT4 on top of an existing RT3 install

This is warned against pretty vigorously in the first part of
docs/UPGRADING-4.0

-kevin


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Barcelona, Spain — November 28 & 29, 2011

Can I use the same RT_SiteConfig.pm from the 3 install?

Yes, though you will want to skim through the new RT_Config.pm to ensure
that there are no new configuration variables that you should be
setting.

  • Alex

I have switched over to the rt4 install that was not installed over rt3,
and I am still getting those errors when restarting apache with a so far,
slightly modified RT_SiteConfig.pmOn Fri, Nov 18, 2011 at 11:17 AM, Alex Vandiver alexmv@bestpractical.comwrote:

On Fri, 2011-11-18 at 11:07 -0800, Jared Griffith wrote:

Can I use the same RT_SiteConfig.pm from the 3 install?

Yes, though you will want to skim through the new RT_Config.pm to ensure
that there are no new configuration variables that you should be
setting.

  • Alex

I have switched over to the rt4 install that was not installed over rt3, and I am still
getting those errors when restarting apache with a so far, slightly modified RT_SiteConfig.pm

Show your apache config and the errors when running from /opt/rt4. Also,
if your apache is using mod_perl and is running rt3 in addition to rt4
you’ll run into similar problems.

-kevin> On Fri, Nov 18, 2011 at 11:17 AM, Alex Vandiver <[1]alexmv@bestpractical.com> wrote:

 On Fri, 2011-11-18 at 11:07 -0800, Jared Griffith wrote:
 > Can I use the same RT_SiteConfig.pm from the 3 install?

 Yes, though you will want to skim through the new RT_Config.pm to ensure
 that there are no new configuration variables that you should be
 setting.
 - Alex

I am running mod_perl 2. rt3 is not running. It’s something from the old
RT_SiteConfig.pm. It’s probably from some options that are not enabled or
are now deprecated. Once I just did that, I restarted the server and the
errors went away. So I guess the real answer is that you can use the
RT_SiteConfig.pm from rt3, but you probably shouldn’t.On Fri, Nov 18, 2011 at 1:29 PM, Kevin Falcone falcone@bestpractical.comwrote:

On Fri, Nov 18, 2011 at 01:15:49PM -0800, Jared Griffith wrote:

I have switched over to the rt4 install that was not installed over
rt3, and I am still
getting those errors when restarting apache with a so far, slightly
modified RT_SiteConfig.pm

Show your apache config and the errors when running from /opt/rt4. Also,
if your apache is using mod_perl and is running rt3 in addition to rt4
you’ll run into similar problems.

-kevin

On Fri, Nov 18, 2011 at 11:17 AM, Alex Vandiver <[1] alexmv@bestpractical.com> wrote:

 On Fri, 2011-11-18 at 11:07 -0800, Jared Griffith wrote:
 > Can I use the same RT_SiteConfig.pm from the 3 install?

 Yes, though you will want to skim through the new RT_Config.pm to

ensure

 that there are no new configuration variables that you should be
 setting.
 - Alex

RT Training Sessions (http://bestpractical.com/services/training.html)

  • Barcelona, Spain — November 28 & 29, 2011