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

[Lists]

Thanks for the info Alex, I appreciate it and will give it a try.

Dave

On 6/23/2014 11:29 AM, Alex Vandiver wrote:
> 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
>
>
>