[rt-users] rt4 database upgrade

[Delarosa, Adalberto]

I am in the mist of moving from RT 3.8.8 to 4.0.  I run the update database
script and I get the following error:

 

[warning]: DBD::mysql::st execute failed: Duplicate entry '0' for key
'PRIMARY' at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 509, <> line 1.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)

[warning]: RT::Handle=HASH(0xa10e3c0) couldn't execute the query 'INSERT
INTO ACL (PrincipalType, PrincipalId, RightName, ObjectType, ObjectId)
VALUES (?, ?, ?, ?, ?)' at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522

 
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xa10e3c0)',
'INSERT INTO ACL (PrincipalType, PrincipalId, RightName, Objec...', 'Owner',
6, 'ExecuteCode', 'RT::System', 1) called at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 357

 
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xa10e3c0)', 'ACL',
'PrincipalType', 'Owner', 'PrincipalId', 6, 'RightName', 'ExecuteCode',
'ObjectType', ...) called at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/mysql.pm line 36

 
DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0xa10e3c0)',
'ACL', 'PrincipalType', 'Owner', 'PrincipalId', 6, 'RightName',
'ExecuteCode', 'ObjectType', ...) called at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1292

 
DBIx::SearchBuilder::Record::Create('RT::ACE=HASH(0xba17398)',
'PrincipalType', 'Owner', 'PrincipalId', 6, 'RightName', 'ExecuteCode',
'ObjectId', 1, ...) called at /opt/rt4/sbin/../lib/RT/Record.pm line 304

                RT::Record::Create('RT::ACE=HASH(0xba17398)', 'PrincipalId',
6, 'PrincipalType', 'Owner', 'RightName', 'ExecuteCode', 'ObjectType',
'RT::System', ...) called at /opt/rt4/sbin/../lib/RT/ACE.pm line 291

                RT::ACE::Create('RT::ACE=HASH(0xba17398)', 'RightName',
'ExecuteCode', 'Object', 'RT::System=HASH(0xa1a35c4)', 'PrincipalType',
'Owner', 'PrincipalId', 6, ...) called at
/opt/rt4/sbin/../lib/RT/Principal.pm line 172

                RT::Principal::GrantRight('RT::Principal=HASH(0xba0a734)',
'Right', 'ExecuteCode', 'Object', 'RT::System=HASH(0xa1a35c4)') called at
./etc/upgrade/3.9.1/content line 56

                RT::Handle::__ANON__() called at
/opt/rt4/sbin/../lib/RT/Handle.pm line 767

                eval {...} called at /opt/rt4/sbin/../lib/RT/Handle.pm line
767

                RT::Handle::InsertData('RT::Handle=HASH(0xa10e3c0)',
'./etc/upgrade/3.9.1/content', 'undef') called at
/opt/rt4/sbin/rt-setup-database line 290

                main::action_insert('datafile', 'undef', 'action',
'upgrade', 'datadir', './etc/upgrade/3.9.1', 'backcompat',
'ARRAY(0x8975f98)', 'dba', ...) called at /opt/rt4/sbin/rt-setup-database
line 396

                main::action_upgrade('action', 'upgrade', 'dba', 'root')
called at /opt/rt4/sbin/rt-setup-database line 195
(/usr/lib/perl5/5.8.8/Carp.pm:272)

[warn]: Unable to grant ExecuteCode on principal 6: System error. Right not
granted. (./etc/upgrade/3.9.1/content:62)

 

Any thoughts or ideas would appreciated.   Attempting to repair the database
with rt-validator returns this error:

 

Couldn't load GM record #0 at ./rt-validator line 433 

 

Thanks in advance

 

 

===============

Alberto Dela Rosa

Director of Information Technology

School of Pharmacy and Pharmaceutical Sciences

351 Hochstetter Hall

Buffalo, NY 14260

 

Tel: 716-645-2259

Fax: 716-645-3688

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110615/1fd242e4/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5189 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110615/1fd242e4/attachment.bin>