RT 3.4.0 rc1 Database Schema

I am currently using RT 3.2.2 in production and have taken a database
snapshot to use on a test system with the 3.4 RC1 package. It has so far
taken care of a number of issues we’ve been having (unlimited rows per
page, SeeQueue and SeeConfigTab rights, as well as custom fields, plus
others). One problem I did have during installation was with the upgrade
of the database to the 3.3.0 schema. I got a bunch of different error
messages (as a result of partially completing the import, then starting
with a different data set, etc), and eventually traced it down to the
following two lines in the etc/upgrade/3.3.0/schema.mysql file:

alter table ObjectCustomFieldValues drop index ticketcustomfieldvalues1;
alter table ObjectCustomFieldValues drop index ticketcustomfieldvalues2;

As I looked into it, the database I am running does not have either of
those indexes on my TicketCustomFieldValues tables (original name of
ObjectCustomFieldValues), and so attempting to drop these gives an
error, which stops rt-setup-database, which doesn’t allow
ObjectCustomFields to get created…

Are these indexes (or indices if you like) standard and just missing on
my schema, or will it be a more wide-spread issue that should be
addressed in the schema (check if index exists before dropping)?

Joel Johnson
Information School
University of Washington

As I looked into it, the database I am running does not have either of
those indexes on my TicketCustomFieldValues tables (original name of
ObjectCustomFieldValues), and so attempting to drop these gives an
error, which stops rt-setup-database, which doesn’t allow
ObjectCustomFields to get created…

Are these indexes (or indices if you like) standard and just missing on
my schema, or will it be a more wide-spread issue that should be
addressed in the schema (check if index exists before dropping)?

I think the latter is a distinct possibility. I’ currently triaging some
knotty oracle issues, but will attempt to remedy this for the next RC.
I’m tentatively aiming to have the final release out this year. But that
depends a lot on how much snow I need to shovel this week. :wink:

Thanks for bringing this to my attention.

Jesse