Error when upgrading database from 3.8.9 to 3.9.1

We’re long time RT users and are in the process of upgrading from 3.6.3 to
4.0.8 and are following the instructions on
UPGRADING.mysql - RT 4.0.25 Documentation - Best Practical and
README - RT 4.0.25 Documentation - Best Practical. I upgraded to 3.7.87,
ran the extra queries and continued the upgrade however it failed at the
step of upgrading to 3.9.1.

make upgrade-database
/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database
–action upgrade --prompt-for-dba-password
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: rt4
User: root
DBA: root
Enter RT version you’re upgrading from: 3.8.9

Going to apply following upgrades:

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

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

[snip]
[Mon Nov 5 17:15:24 2012] [warning]: DBD::mysql::st execute failed: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ‘AND (Groups.Type =
‘AdminCc’) AND ((Groups.Domain = ‘RT::System-Role’ AND Groups’ at line 1 at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)
[Mon Nov 5 17:15:24 2012] [warning]: RT::Handle=HASH(0x23f02a8) couldn’t
execute the query ‘SELECT Groups.id FROM Groups, Principals,
CachedGroupMembers WHERE Principals.Disabled = 0 AND
CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND
Principals.PrincipalType = ‘Group’ AND Principals.id =
CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = AND
(Groups.Type = ‘AdminCc’) AND ((Groups.Domain = ‘RT::System-Role’ AND
Groups.Instance = ‘1’) OR (Groups.Domain = ‘RT::System-Role’ AND
Groups.Instance = ‘1’)) LIMIT 1’ at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.

DBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x23f02a8)’,
‘SELECT Groups.id FROM Groups, Principals, CachedGroupMembers…’) called
at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 632

DBIx::SearchBuilder::Handle::FetchResult(‘RT::Handle=HASH(0x23f02a8)’,
‘SELECT Groups.id FROM Groups, Principals, CachedGroupMembers…’) called
at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 538
RT::Principal::_HasRoleRight(‘RT::Principal=HASH(0x3095198)’,
‘Right’, ‘ExecuteCode’, ‘EquivObjects’, ‘ARRAY(0x3095528)’, ‘Object’,
‘RT::System=HASH(0x2f062b0)’) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 447
RT::Principal::_HasRight(‘RT::Principal=HASH(0x3095198)’, ‘Right’,
‘ExecuteCode’, ‘EquivObjects’, ‘ARRAY(0x3095528)’, ‘Object’,
‘RT::System=HASH(0x2f062b0)’) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 330
RT::Principal::HasRight(‘RT::Principal=HASH(0x3095198)’, ‘Right’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’) called at
./etc/upgrade/3.9.1/content line 52
RT::Handle::ANON() called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line
769
RT::Handle::InsertData(‘RT::Handle=HASH(0x23f02a8)’,
‘./etc/upgrade/3.9.1/content’, undef) called at sbin/rt-setup-database line
293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef,
‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.1’, ‘backcompat’, …)
called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/local/share/perl5/Carp.pm:103)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in string
eq at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 704.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:704)
[Mon Nov 5 17:15:24 2012] [critical]: at
/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm line 231.
RT::ACE::Create(‘RT::ACE=HASH(0x3095528)’, ‘RightName’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’, ‘PrincipalType’,
undef, ‘PrincipalId’, undef, …) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 172
RT::Principal::GrantRight(‘RT::Principal=HASH(0x3095198)’, ‘Right’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’) called at
./etc/upgrade/3.9.1/content line 57
RT::Handle::ANON() called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line
769
RT::Handle::InsertData(‘RT::Handle=HASH(0x23f02a8)’,
‘./etc/upgrade/3.9.1/content’, undef) called at sbin/rt-setup-database line
293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef,
‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.1’, ‘backcompat’, …)
called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:536)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value $princ_id
in concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm
line 537. (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [critical]: Can’t load a principal for id
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [warning]: Unable to grant ExecuteCode on
principal : Principal not found. (./etc/upgrade/3.9.1/content:63)
[Mon Nov 5 17:15:24 2012] [error]: ACE 24605 couldn’t load its principal
object (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:478)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in numeric
eq (==) at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 262.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:262)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm
line 295. (/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:295)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 315.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:315)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in string
eq at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 704.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:704)
[Mon Nov 5 17:15:24 2012] [critical]: at
/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm line 231.
RT::ACE::Create(‘RT::ACE=HASH(0x30960b0)’, ‘RightName’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’, ‘PrincipalType’,
undef, ‘PrincipalId’, undef, …) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 172
RT::Principal::GrantRight(‘RT::Principal=HASH(0x3096a10)’, ‘Right’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’) called at
./etc/upgrade/3.9.1/content line 57
RT::Handle::ANON() called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line
769
RT::Handle::InsertData(‘RT::Handle=HASH(0x23f02a8)’,
‘./etc/upgrade/3.9.1/content’, undef) called at sbin/rt-setup-database line
293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef,
‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.1’, ‘backcompat’, …)
called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:536)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value $princ_id
in concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm
line 537. (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [critical]: Can’t load a principal for id
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [warning]: Unable to grant ExecuteCode on
principal : Principal not found. (./etc/upgrade/3.9.1/content:63)
[Mon Nov 5 17:15:24 2012] [error]: ACE 22605 couldn’t load its principal
object (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:478)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in numeric
eq (==) at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 262.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:262)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm
line 295. (/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:295)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 315.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:315)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in string
eq at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 704.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:704)
[Mon Nov 5 17:15:24 2012] [critical]: at
/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm line 231.
RT::ACE::Create(‘RT::ACE=HASH(0x30962c0)’, ‘RightName’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’, ‘PrincipalType’,
undef, ‘PrincipalId’, undef, …) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 172
RT::Principal::GrantRight(‘RT::Principal=HASH(0x3096ab8)’, ‘Right’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’) called at
./etc/upgrade/3.9.1/content line 57
RT::Handle::ANON() called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line
769
RT::Handle::InsertData(‘RT::Handle=HASH(0x23f02a8)’,
‘./etc/upgrade/3.9.1/content’, undef) called at sbin/rt-setup-database line
293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef,
‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.1’, ‘backcompat’, …)
called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:536)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value $princ_id
in concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm
line 537. (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [critical]: Can’t load a principal for id
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [warning]: Unable to grant ExecuteCode on
principal : Principal not found. (./etc/upgrade/3.9.1/content:63)
[Mon Nov 5 17:15:24 2012] [error]: ACE 25655 couldn’t load its principal
object (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:478)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in numeric
eq (==) at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 262.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:262)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm
line 295. (/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:295)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 315.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:315)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in string
eq at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 704.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:704)
[Mon Nov 5 17:15:24 2012] [critical]: at
/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm line 231.
RT::ACE::Create(‘RT::ACE=HASH(0x30957b0)’, ‘RightName’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’, ‘PrincipalType’,
undef, ‘PrincipalId’, undef, …) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 172
RT::Principal::GrantRight(‘RT::Principal=HASH(0x3096788)’, ‘Right’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’) called at
./etc/upgrade/3.9.1/content line 57
RT::Handle::ANON() called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line
769
RT::Handle::InsertData(‘RT::Handle=HASH(0x23f02a8)’,
‘./etc/upgrade/3.9.1/content’, undef) called at sbin/rt-setup-database line
293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef,
‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.1’, ‘backcompat’, …)
called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:536)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value $princ_id
in concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm
line 537. (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [critical]: Can’t load a principal for id
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [warning]: Unable to grant ExecuteCode on
principal : Principal not found. (./etc/upgrade/3.9.1/content:63)
[Mon Nov 5 17:15:24 2012] [error]: ACE 21605 couldn’t load its principal
object (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:478)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in numeric
eq (==) at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 262.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:262)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm
line 295. (/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:295)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 315.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:315)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in string
eq at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 704.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:704)
[Mon Nov 5 17:15:24 2012] [critical]: at
/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm line 231.
RT::ACE::Create(‘RT::ACE=HASH(0x30977f0)’, ‘RightName’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’, ‘PrincipalType’,
undef, ‘PrincipalId’, undef, …) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 172
RT::Principal::GrantRight(‘RT::Principal=HASH(0x3097340)’, ‘Right’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’) called at
./etc/upgrade/3.9.1/content line 57
RT::Handle::ANON() called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line
769
RT::Handle::InsertData(‘RT::Handle=HASH(0x23f02a8)’,
‘./etc/upgrade/3.9.1/content’, undef) called at sbin/rt-setup-database line
293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef,
‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.1’, ‘backcompat’, …)
called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:536)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value $princ_id
in concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm
line 537. (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [critical]: Can’t load a principal for id
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [warning]: Unable to grant ExecuteCode on
principal : Principal not found. (./etc/upgrade/3.9.1/content:63)
[Mon Nov 5 17:15:24 2012] [error]: ACE 24655 couldn’t load its principal
object (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:478)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in numeric
eq (==) at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 262.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:262)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm
line 295. (/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:295)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 315.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:315)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in string
eq at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 704.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:704)
[Mon Nov 5 17:15:24 2012] [critical]: at
/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm line 231.
RT::ACE::Create(‘RT::ACE=HASH(0x30957b0)’, ‘RightName’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’, ‘PrincipalType’,
undef, ‘PrincipalId’, undef, …) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 172
RT::Principal::GrantRight(‘RT::Principal=HASH(0x3097400)’, ‘Right’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’) called at
./etc/upgrade/3.9.1/content line 57
RT::Handle::ANON() called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line
769
RT::Handle::InsertData(‘RT::Handle=HASH(0x23f02a8)’,
‘./etc/upgrade/3.9.1/content’, undef) called at sbin/rt-setup-database line
293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef,
‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.1’, ‘backcompat’, …)
called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:536)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value $princ_id
in concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm
line 537. (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [critical]: Can’t load a principal for id
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [warning]: Unable to grant ExecuteCode on
principal : Principal not found. (./etc/upgrade/3.9.1/content:63)
[Mon Nov 5 17:15:24 2012] [error]: ACE 22655 couldn’t load its principal
object (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:478)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in numeric
eq (==) at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 262.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:262)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm
line 295. (/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:295)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 315.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:315)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in string
eq at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 704.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:704)
[Mon Nov 5 17:15:24 2012] [critical]: at
/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm line 231.
RT::ACE::Create(‘RT::ACE=HASH(0x30977c0)’, ‘RightName’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’, ‘PrincipalType’,
undef, ‘PrincipalId’, undef, …) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 172
RT::Principal::GrantRight(‘RT::Principal=HASH(0x1c6ee70)’, ‘Right’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’) called at
./etc/upgrade/3.9.1/content line 57
RT::Handle::ANON() called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line
769
RT::Handle::InsertData(‘RT::Handle=HASH(0x23f02a8)’,
‘./etc/upgrade/3.9.1/content’, undef) called at sbin/rt-setup-database line
293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef,
‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.1’, ‘backcompat’, …)
called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:536)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value $princ_id
in concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm
line 537. (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [critical]: Can’t load a principal for id
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [warning]: Unable to grant ExecuteCode on
principal : Principal not found. (./etc/upgrade/3.9.1/content:63)
[Mon Nov 5 17:15:24 2012] [error]: ACE 25705 couldn’t load its principal
object (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:478)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in numeric
eq (==) at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 262.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:262)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in
concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm
line 295. (/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:295)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 315.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:315)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in join or
string at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 320.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:320)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value in string
eq at /usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 704.
(/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm:704)
[Mon Nov 5 17:15:24 2012] [critical]: at
/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm line 231.
RT::ACE::Create(‘RT::ACE=HASH(0x3097370)’, ‘RightName’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’, ‘PrincipalType’,
undef, ‘PrincipalId’, undef, …) called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Principal.pm line 172
RT::Principal::GrantRight(‘RT::Principal=HASH(0x3097610)’, ‘Right’,
‘ExecuteCode’, ‘Object’, ‘RT::System=HASH(0x2f062b0)’) called at
./etc/upgrade/3.9.1/content line 57
RT::Handle::ANON() called at
/usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line 769
eval {…} called at /usr/src/rt-4.0.8/sbin/…/lib/RT/Handle.pm line
769
RT::Handle::InsertData(‘RT::Handle=HASH(0x23f02a8)’,
‘./etc/upgrade/3.9.1/content’, undef) called at sbin/rt-setup-database line
293
main::action_insert(‘prompt-for-dba-password’, 1, ‘datafile’, undef,
‘action’, ‘upgrade’, ‘datadir’, ‘./etc/upgrade/3.9.1’, ‘backcompat’, …)
called at sbin/rt-setup-database line 399
main::action_upgrade(‘prompt-for-dba-password’, 1, ‘action’,
‘upgrade’, ‘dba’, ‘root’) called at sbin/rt-setup-database line 198
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:536)
[Mon Nov 5 17:15:24 2012] [warning]: Use of uninitialized value $princ_id
in concatenation (.) or string at /usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm
line 537. (/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [critical]: Can’t load a principal for id
(/usr/src/rt-4.0.8/sbin/…/lib/RT/ACE.pm:537)
[Mon Nov 5 17:15:24 2012] [warning]: Unable to grant ExecuteCode on
principal : Principal not found. (./etc/upgrade/3.9.1/content:63)
Done.

Any suggestions appreciated.

We’re long time RT users and are in the process of upgrading from 3.6.3 to
4.0.8 and are following the instructions on
UPGRADING.mysql - RT 4.0.25 Documentation - Best Practical and
README - RT 4.0.25 Documentation - Best Practical. I upgraded to 3.7.87,
ran the extra queries and continued the upgrade however it failed at the
step of upgrading to 3.9.1.

Be sure to read the other UPGRADING documentation as well, for all
versions between 3.6.3 and 4.0.8.

Your database contains rows in the ACL table which point to Principals
that no longer exist. Grep for the [error] lines “ACE NNNN couldn’t
load it’s principal object”. This indicates that records were manually
deleted from the database at some point, and done so incorrectly (as is
almost always the case with manual deletes by folks not understanding
the whole of the database).

The code doesn’t handle this error case and blows up. The ACL rows in
question are:

21605
22605
22655
24605
24655
25655
25705

You may want to take a look and see what happened to the Principals
referred to. To proceed with the upgrade, add the following line to
etc/upgrade/3.9.1/content after the line reading “my $principal =
$ace->PrincipalObj;”:

next unless $principal->id;

After you’ve upgraded to 4.0.8, you’ll want to run rt-validator to check
the integrity of your database and clean it up.

Thomas

We’re long time RT users and are in the process of upgrading from
3.6.3 to
4.0.8 and are following the instructions on
UPGRADING.mysql - RT 4.0.25 Documentation - Best Practical and
README - RT 4.0.25 Documentation - Best Practical. I upgraded to
3.7.87, ran the extra queries and continued the upgrade however it
failed at the step of upgrading to 3.9.1.

Be sure to read the other UPGRADING documentation as well, for all
versions between 3.6.3 and 4.0.8.

Your database contains rows in the ACL table which point to Principals
that no longer exist. Grep for the [error] lines “ACE NNNN couldn’t
load it’s principal object”. This indicates that records were manually
deleted from the database at some point, and done so incorrectly (as is
almost always the case with manual deletes by folks not understanding
the whole of the database).

Turns out the data extract was incomplete.

Thanks for the help.