Okay, that helped identify possible culprits. Three of our lists are hitting/over the max BLOB length (65,535 bytes) for accept_these_nonmembers. I executed this SQL command for each of the BLOB cols you referenced and only accept_these_nonmembers is borked:
MySQL [mailman]> SELECT list_name, OCTET_LENGTH(accept_these_nonmembers) as howManyBytes from mailinglist where OCTET_LENGTH(accept_these_nonmembers) > 64000; +---------------+--------------+ | list_name | howManyBytes | +---------------+--------------+ | <snip> | 65535 | | <snip> | 65535 | | <snip> | 65535 | +---------------+--------------+ 3 rows in set (0.01 sec)
So, putting aside *why* these lists are so large wrt that column, can or should I alter the col type(s) to MEDIUMBLOB? If yes, would that remain on suite upgrades? If no, is there a better alternative? Or some recommendation in between?
Bryan Loniewski Rutgers University OIT:EAS:Messaging and Collaboration Services System Administrator
From: Mark Sapiro <mark@msapiro.net> Sent: Tuesday, August 3, 2021 12:15 AM To: mailman-users@mailman3.org Subject: [MM3-users] Re: UnpicklingError on mailman lists command
On 8/2/21 7:35 PM, Bryan Loniewski wrote:
$ /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?
The traceback indicates sqlalchemy is unpickling data whose type is PickleType. The only mailinglist columns which are PickleType are the legacy *these_nonmembers and topics.
You could try invoking mysql on Mailman's database and doing
SELECT list_name, accept_these_nonmembers, hold_these_nonmembers, reject_these_nonmembers, discard_these_nonmembers, topics FROM mailinglist;
and look for the longest values to possibly identify the problem list and attribute.
-- 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...