$ /opt/mailman/mm/bin/mailman version GNU Mailman 3.3.2 (Tom Sawyer)
So, I'm running > 3.2. Any other advice on debugging the truncated data?
Bryan Loniewski Rutgers University OIT:EAS:Messaging and Collaboration Services System Administrator
From: Mark Sapiro <mark@msapiro.net> Sent: Monday, August 2, 2021 10:06 PM To: mailman-users@mailman3.org Subject: [MM3-users] Re: UnpicklingError on mailman lists command
On 8/2/21 4:15 PM, Bryan Loniewski wrote:
Hi all --
$ /opt/mailman/mm/bin/mailman lists Traceback (most recent call last): ... File "/opt/mailman/venv/lib/python3.6/site-packages/mailman/commands/cli_lists.py", line 78, in lists for mlist in list_manager.mailing_lists: File "/opt/mailman/venv/lib/python3.6/site-packages/mailman/model/listmanager.py", line 100, in mailing_lists MailingList._list_id).all() File "/opt/mailman/venv/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3246, in all return list(self) File "/opt/mailman/venv/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", line 101, in instances cursor.close() File "/opt/mailman/venv/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__ exc_value, with_traceback=exc_tb, File "/opt/mailman/venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise_ raise exception File "/opt/mailman/venv/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", line 81, in instances rows = [proc(row) for row in fetch] File "/opt/mailman/venv/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", line 81, in <listcomp> rows = [proc(row) for row in fetch] File "/opt/mailman/venv/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", line 589, in _instance populators, File "/opt/mailman/venv/lib/python3.6/site-packages/sqlalchemy/orm/loading.py", line 726, in _populate_full dict_[key] = getter(row) File "/opt/mailman/venv/lib/python3.6/site-packages/sqlalchemy/sql/sqltypes.py", line 1708, in process return loads(value) _pickle.UnpicklingError: pickle data was truncated
This is probably https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.com... which was fixed in Mailman 3.2.0 by https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.com....
What version are you running? If your version is 3.2.0 or greater, it could be one of the other issues with MySQL/MariaDB truncating data.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.mail...