2 files changed, 29 insertions, 2 deletions

diff --git a/src/mailman/database/alembic/versions/a46993b05703_increase_pendedkeyvalue_value_size.py b/src/mailman/database/alembic/versions/a46993b05703_increase_pendedkeyvalue_value_size.py
new file mode 100644
index 000000000..2fd934589
--- /dev/null
+++ b/src/mailman/database/alembic/versions/a46993b05703_increase_pendedkeyvalue_value_size.py
@@ -0,0 +1,27 @@
+"""increase pendedkeyvalue value size
+
+Revision ID: a46993b05703
+Revises: 448a93984c35
+Create Date: 2016-12-15 20:43:48.520837
+
+"""
+
+from alembic import op
+from mailman.database.types import SAUnicode, SAUnicodeLarge
+
+
+# revision identifiers, used by Alembic.
+revision = 'a46993b05703'
+down_revision = '448a93984c35'
+
+
+def upgrade():
+    # Adding another rule can make the rule Hits/Misses too long for MySQL
+    # SaUnicode.
+    with op.batch_alter_table('pendedkeyvalue') as batch_op:
+        batch_op.alter_column('value', type_=SAUnicodeLarge)
+
+
+def downgrade():
+    with op.batch_alter_table('pendedkeyvalue') as batch_op:
+        batch_op.alter_column('value', type_=SAUnicode)
diff --git a/src/mailman/model/pending.py b/src/mailman/model/pending.py
index 5889f9cc1..60be56e8f 100644
--- a/src/mailman/model/pending.py
+++ b/src/mailman/model/pending.py
@@ -23,7 +23,7 @@ from lazr.config import as_timedelta
 from mailman.config import config
 from mailman.database.model import Model
 from mailman.database.transaction import dbconnection
-from mailman.database.types import SAUnicode
+from mailman.database.types import SAUnicode, SAUnicodeLarge
 from mailman.interfaces.pending import (
     IPendable, IPended, IPendedKeyValue, IPendings)
 from mailman.utilities.datetime import now
@@ -47,7 +47,7 @@ class PendedKeyValue(Model):
 
     id = Column(Integer, primary_key=True)
     key = Column(SAUnicode, index=True)
-    value = Column(SAUnicode, index=True)
+    value = Column(SAUnicodeLarge, index=True)
     pended_id = Column(Integer, ForeignKey('pended.id'), index=True)
 
     def __init__(self, key, value):