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