Problems after update to mailman 3.3.7
I've getting the most strange behaviour after update to last releases. In one of my mailman3 servers, the messages doesnt reach for some lists (the five last ones)
the update have not showed any error but in the var/data for the lmtp and vmap postfix files mailman does not create aliases for that last 5 lists. Any message addressed to them is returned with a "no such user" error.
If I create a new list the system or restart mailman runners it shows this error:
Generating MTA alias maps /usr/local/lib/python3.9/site-packages/pymysql/connections.py:799: UserWarning: Previous unbuffered result was left incomplete warnings.warn("Previous unbuffered result was left incomplete")
I did a CHECK TABLE on mailinglists table but all seems ok.
I tried reinstalling PyMySQL, but has no effect. (well, I tried reinstalling all)
It seems to me that something is preventing creation of that aliases, an then the that last five lists are unreachable.
I have no clue of what to do now and I'm driving crazy.
Some direction to look for will be much apreciated.
Thanks in advance.
P.S.: I can access via postorius/hyperkitty to the archives of the lists that are unreacheable.
--
Mailman's content filtering has removed the following MIME parts from this message.
Content-Type: image/png Name: firma-GHP-emails.png
Replaced multipart/alternative part with first alternative.
Hi Guillermo,
We've faced the same issue and already reported it: https://gitlab.com/mailman/mailman/-/issues/1044
I would not recommend anyone using MySQL/MariaDB database engine upgrade to the latest version yet.
With my best regards, Danil Smirnov Mailman3.com
On Tue, Dec 6, 2022 at 4:32 PM Guillermo Hernandez (Oldno7) via Mailman-users <mailman-users@mailman3.org> wrote:
I've getting the most strange behaviour after update to last releases. In one of my mailman3 servers, the messages doesnt reach for some lists (the five last ones)
the update have not showed any error but in the var/data for the lmtp and vmap postfix files mailman does not create aliases for that last 5 lists. Any message addressed to them is returned with a "no such user" error.
If I create a new list the system or restart mailman runners it shows this error:
Generating MTA alias maps /usr/local/lib/python3.9/site-packages/pymysql/connections.py:799: UserWarning: Previous unbuffered result was left incomplete warnings.warn("Previous unbuffered result was left incomplete")
I did a CHECK TABLE on mailinglists table but all seems ok.
I tried reinstalling PyMySQL, but has no effect. (well, I tried reinstalling all)
It seems to me that something is preventing creation of that aliases, an then the that last five lists are unreachable.
I have no clue of what to do now and I'm driving crazy.
Some direction to look for will be much apreciated.
Thanks in advance.
P.S.: I can access via postorius/hyperkitty to the archives of the lists that are unreacheable.
--
Mailman's content filtering has removed the following MIME parts from this message.
Content-Type: image/png Name: firma-GHP-emails.png
Replaced multipart/alternative part with first alternative.
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/ Archived at: https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/...
This message sent to danil@smirnov.la
El 6/12/22 a las 15:59, Danil Smirnov escribió:
Hi Guillermo,
We've faced the same issue and already reported it: https://gitlab.com/mailman/mailman/-/issues/1044
I see. Thanks, Danil, for the confirmation that I'm not alone in this..
I would not recommend anyone using MySQL/MariaDB database engine upgrade to the latest version yet.
Too late for that... Doy you know what components could I downgrade to avoid this? SQLAlchemy? Which versions of which packages could I downgrade to work prpoerly?
Again, thanks a lot
With my best regards, Danil Smirnov Mailman3.com
On Tue, Dec 6, 2022 at 4:32 PM Guillermo Hernandez (Oldno7) via Mailman-users<mailman-users@mailman3.org> wrote:
I've getting the most strange behaviour after update to last releases. In one of my mailman3 servers, the messages doesnt reach for some lists (the five last ones)
the update have not showed any error but in the var/data for the lmtp and vmap postfix files mailman does not create aliases for that last 5 lists. Any message addressed to them is returned with a "no such user" error.
If I create a new list the system or restart mailman runners it shows this error:
Generating MTA alias maps /usr/local/lib/python3.9/site-packages/pymysql/connections.py:799: UserWarning: Previous unbuffered result was left incomplete warnings.warn("Previous unbuffered result was left incomplete")
I did a CHECK TABLE on mailinglists table but all seems ok.
I tried reinstalling PyMySQL, but has no effect. (well, I tried reinstalling all)
It seems to me that something is preventing creation of that aliases, an then the that last five lists are unreachable.
I have no clue of what to do now and I'm driving crazy.
Some direction to look for will be much apreciated.
Thanks in advance.
P.S.: I can access via postorius/hyperkitty to the archives of the lists that are unreacheable.
--
Mailman's content filtering has removed the following MIME parts from this message.
Content-Type: image/png Name: firma-GHP-emails.png
Replaced multipart/alternative part with first alternative.
Mailman-users mailing list --mailman-users@mailman3.org To unsubscribe send an email tomailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at: https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/...
This message sent todanil@smirnov.la
Mailman-users mailing list --mailman-users@mailman3.org To unsubscribe send an email tomailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at:https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/...
This message sent toguillermo@querysoft.es
--
Mailman's content filtering has removed the following MIME parts from this message.
Content-Type: image/png Name: firma-GHP-emails.png
Replaced multipart/alternative part with first alternative.
On Tue, Dec 6, 2022 at 5:12 PM Guillermo Hernandez (Oldno7) via Mailman-users <mailman-users@mailman3.org> wrote:
Too late for that... Doy you know what components could I downgrade to avoid this? SQLAlchemy? Which versions of which packages could I downgrade to work prpoerly?
I suppose you can downgrade the mailman package to version 3.3.6 which should also downgrade SQLAlchemy to the 1.3.x version. (However I haven't tested this path by myself, so please do a backup first.)
Danil
El 6/12/22 a las 16:34, Danil Smirnov escribió:
On Tue, Dec 6, 2022 at 5:12 PM Guillermo Hernandez (Oldno7) via Mailman-users<mailman-users@mailman3.org> wrote:
Too late for that... Doy you know what components could I downgrade to avoid this? SQLAlchemy? Which versions of which packages could I downgrade to work prpoerly?
I suppose you can downgrade the mailman package to version 3.3.6 which should also downgrade SQLAlchemy to the 1.3.x version. (However I haven't tested this path by myself, so please do a backup first.)
I was doing that myself when I received your message.
Yes, it worked. This morning (I'm in Spain) I tried to do that, but all the fuss in my head didn't help much.
Now it's working again in 3.3.6 and the lists beyond the 10th are reachable.
Thanks a lot for your help.
Danil
Mailman-users mailing list --mailman-users@mailman3.org To unsubscribe send an email tomailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at:https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/...
This message sent toguillermo@querysoft.es
--
Mailman's content filtering has removed the following MIME parts from this message.
Content-Type: image/png Name: firma-GHP-emails.png
Replaced multipart/alternative part with first alternative.
At least one person reports that this patch ``` --- a/src/mailman/mta/postfix.py +++ b/src/mailman/mta/postfix.py @@ -144,7 +144,7 @@ class LMTP: utility = getUtility(IMailTransportAgentAliases) by_domain = {} sort_key = attrgetter('list_name') - for list_name, mail_host in list_manager.name_components: + for list_name, mail_host in list(list_manager.name_components): mlist = _FakeList(list_name, mail_host) by_domain.setdefault(mlist.mail_host, []).append(mlist) print("""\ ``` Works around the issue with SQLAlchemy 1.4.x and MariaDB that causes truncation of postfix_lmtp with Mailman 3.3.7 and MariaDB. -- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (3)
-
Danil Smirnov -
Guillermo Hernandez (Oldno7) -
Mark Sapiro