Below is my screenlog from upgrade-database. The Oracle CREATE INDEX's are possibly worth the effort to DROP and then CREATE, but the failed calls to RT's API are worrisome.
John groenv...@acm.org # 4.0.16 Going to apply following upgrades: * 4.1.0 * 4.1.1 * 4.1.4 * 4.1.5 * 4.1.6 * 4.1.7 * 4.1.8 * 4.1.9 * 4.1.10 * 4.1.11 * 4.1.12 * 4.1.13 * 4.1.14 * 4.1.15 * 4.1.16 * 4.1.17 * 4.1.18 * 4.1.19 * 4.1.20 * 4.1.21 * 4.1.22 * 4.1.23 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 4.1.0 Now inserting data. Processing 4.1.1 Now populating database schema. Now inserting data. Processing 4.1.4 Now populating database schema. Now inserting data. [4562] [Sat Oct 5 19:59:21 2013] [error]: Can't load role group AdminCc: Couldn't find row (./etc/upgrade/4.1.4/content:18) [4562] [Sat Oct 5 19:59:21 2013] [error]: Can't load role group Cc: Couldn't find row (./etc/upgrade/4.1.4/content:18) [4562] [Sat Oct 5 19:59:21 2013] [error]: Can't load role group Owner: Couldn't find row (./etc/upgrade/4.1.4/content:18) [4562] [Sat Oct 5 19:59:21 2013] [error]: Can't load role group Requestor: Couldn't find row (./etc/upgrade/4.1.4/content:18) Processing 4.1.5 Now populating database schema. Now inserting data. Processing 4.1.6 Now inserting data. Processing 4.1.7 Now populating database schema. Processing 4.1.8 Now populating database schema. Processing 4.1.9 Now inserting data. Processing 4.1.10 Now populating database schema. Processing 4.1.11 Now populating database schema. Processing 4.1.12 Now inserting data. [4562] [Sat Oct 5 19:59:51 2013] [warning]: Use of uninitialized value in concatenation (.) or string at /tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm line 1052, <> line 7. (/tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm:1052) [4562] [Sat Oct 5 19:59:51 2013] [warning]: Use of uninitialized value in concatenation (.) or string at /tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm line 1052, <> line 7. (/tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm:1052) [4562] [Sat Oct 5 19:59:51 2013] [error]: Unable to load Group: GroupDomain => SystemInternal, GroupId => , Queue => (/tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm:1052) Processing 4.1.13 Now populating database schema. Processing 4.1.14 Now populating database schema. Processing 4.1.15 Now inserting data. Processing 4.1.16 Now inserting data. Processing 4.1.17 Now inserting data. Processing 4.1.18 Now inserting data. Processing 4.1.19 Now populating database schema. Processing 4.1.20 Now inserting data. Processing 4.1.21 Now inserting data. Processing 4.1.22 Now populating database schema. Now inserting data. [4562] [Sat Oct 5 20:00:53 2013] [info]: Going to delete all SMIMEKeyNotAfter attributes (./etc/upgrade/4.1.22/content:61) Processing 4.1.23 Now inserting database indexes. [4562] [Sat Oct 5 20:00:54 2013] [warning]: Failed to create index (Domain, Type, Instance) on Groups (sql: CREATE INDEX groups1 ON Groups(LOWER(Domain), LOWER(Type), Instance)): ORA-00955: name is already used by an existing object (DBD ERROR: error possibly near <*> indicator at char 13 in 'CREATE INDEX <*>groups1 ON Groups(LOWER(Domain), LOWER(Type), Instance)') (etc/upgrade/4.1.23/indexes:20) [4562] [Sat Oct 5 20:00:54 2013] [warning]: Failed to create index (Domain, Name, Instance) on Groups (sql: CREATE INDEX groups1 ON Groups(LOWER(Domain), LOWER(Name), Instance)): ORA-00955: name is already used by an existing object (DBD ERROR: error possibly near <*> indicator at char 13 in 'CREATE INDEX <*>groups1 ON Groups(LOWER(Domain), LOWER(Name), Instance)') (etc/upgrade/4.1.23/indexes:28) [4562] [Sat Oct 5 20:00:54 2013] [warning]: Failed to create index (Instance) on Groups (sql: CREATE INDEX groups1 ON Groups(Instance)): ORA-00955: name is already used by an existing object (DBD ERROR: error possibly near <*> indicator at char 13 in 'CREATE INDEX <*>groups1 ON Groups(Instance)') (etc/upgrade/4.1.23/indexes:35) [4562] [Sat Oct 5 20:00:54 2013] [warning]: Failed to create unique index (Name) on Queues (sql: CREATE UNIQUE INDEX queues1 ON Queues(LOWER(Name))): ORA-00955: name is already used by an existing object (DBD ERROR: error possibly near <*> indicator at char 20 in 'CREATE UNIQUE INDEX <*>queues1 ON Queues(LOWER(Name))') (etc/upgrade/4.1.23/indexes:124) [4562] [Sat Oct 5 20:00:54 2013] [warning]: Failed to create unique index (Name) on Users (sql: CREATE UNIQUE INDEX users1 ON Users(LOWER(Name))): ORA-01408: such column list already indexed (DBD ERROR: error possibly near <*> indicator at char 36 in 'CREATE UNIQUE INDEX users1 ON Users(<*>LOWER(Name))') (etc/upgrade/4.1.23/indexes:124) [4562] [Sat Oct 5 20:00:54 2013] [warning]: Failed to create index (MemberId, ImmediateParentId) on CachedGroupMembers (sql: CREATE INDEX cachedgroupmembers1 ON CachedGroupMembers(MemberId, ImmediateParentId)): ORA-01408: such column list already indexed (DBD ERROR: error possibly near <*> indicator at char 55 in 'CREATE INDEX cachedgroupmembers1 ON CachedGroupMembers(<*>MemberId, ImmediateParentId)') (/tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm:1596) [4562] [Sat Oct 5 20:00:54 2013] [warning]: Failed to create index (GroupId, MemberId, Disabled) on CachedGroupMembers (sql: CREATE INDEX cachedgroupmembers1 ON CachedGroupMembers(GroupId, MemberId, Disabled)): ORA-00955: name is already used by an existing object (DBD ERROR: error possibly near <*> indicator at char 13 in 'CREATE INDEX <*>cachedgroupmembers1 ON CachedGroupMembers(GroupId, MemberId, Disabled)') (/tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm:1596) Done. # -- RT Training in New York, October 8th and 9th: http://bestpractical.com/training
