[rt-users] Help with mySQL query to prune RT3 database before upgrading to RT 4.2.5

[Alex Vandiver]

On 06/20/2014 07:16 PM, Lists wrote:
> When I run this against the database I am trying to upgrade, I get:
> 
> mysql> select count(*) from Attributes;
> +----------+
> | count(*) |
> +----------+
> |  1831962 |
> +----------+
> 1 row in set (2.50 sec)
> 
> mysql> select count(*) from Attributes where Name = 'DeferredRecipients'
> and Content IS NULL;
> +----------+
> | count(*) |
> +----------+
> |  1829169 |
> +----------+
> 1 row in set (10.32 sec)
> 
> What do these queries indicate?

RT 3.8.1 contained a bug that caused it to create an excess of
Attributes -- one for every transaction.  Upgrading attempts to load
these into memory.  You can safely remove them before upgrading:

    DELETE FROM Attributes
     WHERE Name = 'DeferredRecipients'
       AND Content IS NULL;

Your upgrade should then be able to complete.
 - Alex