Hi all --
I'm getting the error below when trying to exec the "mailman lists" command. I've turned debugging on within my test mailman.cfg like so...
[database]
class: mailman.database.mysql.MySQLDatabase
<snip>
debug: yes
[logging.database]
level: debug
path: dbmailman.log
and can see a lot of info including the row(s) with each lists data returned in dbmailman.log. Any guidance on further troubleshooting/debugging? Note that listing the members returns fine (at least for the handful of lists I just tested, i.e., /opt/mailman/mm/bin/mailman members bry_test(a)lists-test.rutgers.edu)
$ /opt/mailman/mm/bin/mailman lists
Traceback (most recent call last):
File "/opt/mailman/venv/bin/mailman", line 8, in <module>
sys.exit(main())
File "/opt/mailman/venv/lib/python3.6/site-packages/click/core.py", line 829, in __call__
return self.main(*args, **kwargs)
File "/opt/mailman/venv/lib/python3.6/site-packages/click/core.py", line 782, in main
rv = self.invoke(ctx)
File "/opt/mailman/venv/lib/python3.6/site-packages/mailman/bin/mailman.py", line 68, in invoke
return super().invoke(ctx)
File "/opt/mailman/venv/lib/python3.6/site-packages/click/core.py", line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/opt/mailman/venv/lib/python3.6/site-packages/click/core.py", line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/opt/mailman/venv/lib/python3.6/site-packages/click/core.py", line 610, in invoke
return callback(*args, **kwargs)
File "/opt/mailman/venv/lib/python3.6/site-packages/click/decorators.py", line 21, in new_func
return f(get_current_context(), *args, **kwargs)
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
________________________
Bryan Loniewski
Rutgers University
OIT:EAS:Messaging and Collaboration Services
System Administrator
