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
--
RT Training - Boston, September 9-10
http://bestpractical.com/training
