[rt-devel] rt-validator --check on upgrade from 4.8.14 to 4.0.7

[Thomas Sibley]

On 10/02/2012 02:06 AM, Henti Smith wrote:
> The query "SELECT s.id, s.id FROM Tickets s LEFT JOIN Groups t ON
> (s.id = t.Instance) AND ( t.Domain = 'RT::Ticket-Role' ) WHERE t.id IS
> NULL AND s.id IS NOT NULL" has now been running for 424101 seconds
> (117 hours) and still going.

Note that this query is for other integrity checks, not the unique group
names.  rt-validator is a general purpose database integrity checker and
fixer; unique group name checking is just part of it that was added in 4.0.

You can safely skip running rt-validator if you're not concerned about
database integrity, and simply verify your group names manually in Tools
→ Configuration → Groups.

> The question is where to from here.
> 
> * Is there a way to archive tickets but still have them accessible and
> searchable to speed this up? extension maybe ?

That should be an unnecessary approach if the DB gets tuned appropriately.

> * Is there a way to speed up the query ?

You don't mention what database you're using.  Can you run EXPLAIN on
that SELECT?