Thanks Mark,
We are indeed running mailman core 3.3.2 and using mysql. The data appears indeed to be truncated judging from the missing closing curly bracket (see below).
Would it be OK to already extend the data column to VARCHAR(510) before upgrading to mailman core 3.3.3, or will this cause problems with upgrading to a newer version?
+---------------------------------------------------------------------------
------------------------------+ | data | +---------------------------------------------------------------------------
------------------------------+ | {"pre_approved": false, "pre_confirmed": false, "pre_verified": false, "invitation": false, "address_key": "******************@************", "subscriber_key": 1, "user_key": "a44e8b9a34c64775b712f383d438ce1d", "token_owner_key": 1, "send_welcome_message" | +---------------------------------------------------------------------------
------------------------------+
Best Regards, Eric
-----Original Message----- From: Mark Sapiro [mailto:mark@msapiro.net] Sent: donderdag 29 april 2021 18:43 To: mailman-users@mailman3.org Subject: [MM3-users] Re: Exception with processing subscription confirmation email
On 4/29/21 7:56 AM, Eric Broens wrote:
Hi,
A new user tried to subscribe to a mailinglist, received the confirmation mail, and replied to it.
The subscriber is however not subscribed and remains listed in the "pending confirmation" list.
The following exception appears in the error.log.
Does anyone knows how to resolve this? In the past we didn't experience any issues and no changes but security updates have been installed.
Apr 29 16:15:55 2021 (1581) deque: do_confirm_verify
Traceback (most recent call last):
File "/opt/mailman/venv/lib64/python3.6/site-packages/mailman/app/workflow.py", line 69, in __next__
return step()File
"/opt/mailman/venv/lib64/python3.6/site-packages/mailman/app/subscriptions.p
y", line 356, in _step_send_confirmation
raise StopIterationStopIteration
Tracebacks like the above are normal and probably shouldn't be logged at all.
Apr 29 16:16:28 2021 (1490) Uncaught runner exception: Expecting ':' delimiter: line 1 column 256 (char 255)
Apr 29 16:16:28 2021 (1490) Traceback (most recent call last):
File "/opt/mailman/venv/lib64/python3.6/site-packages/mailman/core/runner.py", line 173, in _one_iteration
self._process_one_file(msg, msgdata)File "/opt/mailman/venv/lib64/python3.6/site-packages/mailman/core/runner.py", line 266, in _process_one_file
keepqueued = self._dispose(mlist, msg, msgdata)File
"/opt/mailman/venv/lib64/python3.6/site-packages/mailman/runners/command.py"
, line 208, in _dispose
mlist, msg, msgdata, parts, results)File
"/opt/mailman/venv/lib64/python3.6/site-packages/mailman/commands/eml_confir
m.py", line 54, in process
mlist).confirm(token)File
"/opt/mailman/venv/lib64/python3.6/site-packages/mailman/app/subscriptions.p
y", line 578, in confirm
workflow.restore()File "/opt/mailman/venv/lib64/python3.6/site-packages/mailman/app/workflow.py", line 146, in restore
data = json.loads(state.data)File "/usr/lib64/python3.6/json/__init__.py", line 354, in loads
return _default_decoder.decode(s)File "/usr/lib64/python3.6/json/decoder.py", line 339, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())File "/usr/lib64/python3.6/json/decoder.py", line 355, in raw_decode
obj, end = self.scan_once(s, idx)json.decoder.JSONDecodeError: Expecting ':' delimiter: line 1 column 256 (char 255)
Apr 29 16:16:28 2021 (1490) SHUNTING: 1619705788.5856323+57a1a759275c59b732cfa8e2985f76cfcc27dda5
This one is the issue. There was some problem with the user's confirmation reply.
View the shunted message with the command
mailman qfile
path/to/var/queue/shunt/1619705788.5856323+57a1a759275c59b732cfa8e2985f76cfc
c27dda5.pck
although that probably won't show anything wrong as it appears that the issue is with the saved workflow. You can get the token from the shunted message and then look at the database with something like
SELECT data FROM workflowstate WHERE token = '<the token>'
but I suspect the issue is because the database is MySQL or MariaDB, your Mailman core is older than 3.3.3 and your database server mode is such that data too long for column results in truncation, and the data in this case is truncated to 255 bytes. In Mailman 3.3.3, this column was changed from VARCHAR(255) to VARCHAR(510) for MySQL.
As far as subscribing the user is concerned, you can in Postorius view
the subscriptions waiting user confirmation and delete this one and then
mass subscribe the user.
-- 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://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/