Is there a way to skip indexes during upgrade?

1

When I upgrade the database, I get this:

Processing 3.7.81
Now inserting database indexes.
Couldn’t finish ‘upgrade’ step.
ERROR: Couldn’t execute ‘etc/upgrade/3.7.81/indexes’: etc/upgrade/3.7.81/indexes did not return a true value at /usr/local/rt/core/rt-4.4.0/sbin/…/lib/RT/Handle.pm line 591, line 4.
make: *** [upgrade-database] Error 255

I was wondering how to get past this stage, with or without those indexes.

2

the error: etc/upgrade/3.7.81/indexes did not return a true

from the file:

use strict;
use warnings;

$RT::Handle->MakeSureIndexExists(
Table => ‘CachedGroupMembers’,
Columns => [‘MemberId’, ‘ImmediateParentId’],
);

1;

Looks like you missed an index?

3

Is there any way around it? Maybe discard some indexes?

4

Try to add the index. at my install it’s called CachedGroupMembers3 (not sure when it was added)

CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId);

5

From which version you try to upgrade?

I’ve just looked through the schema updates etc. and found this index first in 3.8 releases.

Question to @bestpractical: why i can’t find this Index creation inside etc/upgrade at latest release?

from rt.4.0.19:

[root@dehamsl34 upgrade]# grep -R ImmediateParentId *
3.7.81/schema.Oracle:CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId);
3.7.81/schema.mysql:CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId);

from rt 4.4.1:
[root@rtdevwww1 upgrade]# grep -R ImmediateParentId *
3.7.81/indexes: Columns => [‘MemberId’, ‘ImmediateParentId’],
4.1.23/indexes: Columns => [‘MemberId’, ‘ImmediateParentId’],

6

@Torsten_Brumm2 upgrading from 3.8.7 to 4.4.0

7

Thats strange. in my 3.8.7 install mysql schema i can find this index. possibly you deleted it somehow?