[rt-devel] rt-validator --check on upgrade from 4.8.14 to 4.0.7
trs at bestpractical.com
Tue Oct 2 12:11:38 EDT 2012
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
More information about the rt-devel