On 07/25/2018 09:43 AM, Kamran Soomro wrote:
Hi,
Recently I’ve started seeing some weird exceptions when trying to send emails to a list with mailman 3 running in docker:
From mailman core logs:
sqlalchemy.exc.DataError: (pymysql.err.DataError) (1406, "Data too long for column 'value' at row 1") [SQL: 'INSERT INTO pendedkeyvalue (
key, value, pended_id) VALUES (%(key)s, %(value)s, %(pended_id)s)'] [parameters: {'key': '_pck_rule_misses', 'value': '"\\u0080\\u0003]q\\u0000(X\\u0010\\u0000\\u0000\\u0000dmarc-mitigationq\\u0001X\\n\\u0000\\u0000\\u0000no-sendersq\\u0002X\\b\\u0000\\u0000\\u0000app ... (382 characters truncated) ... \\u000bX\\b\\u0000\\u0000\\u0000max-sizeq\\fX\\u000f\\u0000\\u0000\\u0000news-moderationq\\rX\\u0011\\u0000\\u0000\\u0000suspicious-headerq\\u000ee."', 'pended_id': 12}] (Background on this error at: http://sqlalche.me/e/9h9h) Jul 25 07:33:28 2018 (32) SHUNTING: 1532504008.7233553+2ca45fec09fa01b9dd31ed584a06b04302ea155b This seems to be the following issue https://gitlab.com/mailman/mailman/issues/301 https://gitlab.com/mailman/mailman/issues/385
What version of core are you running?
From mailman web logs:
TypeError: ord() expected a character, but string of length 0 found ERROR 2018-07-25 07:42:41,098 22515 hyperkitty.lib.utils Failed to update the fulltext index: ord() expected a character, but string of length 0 found
Could anybody guide me as to what’s wrong? This was attributed to a change of Python versions in the past. Can you delete the fulltext_index and rebuild the cache? Also what version of Hyperkitty are you running. The latest release is Python3 only and the traces are using Python2. Be sure to also fix your cron jobs that might still be using Python2