Am I right expecting that such warnings are harmless and probably come from timeouts and/or unterminated connections to the DB?
Feb 19 14:15:18 localhost mariadbd[28859]: 2022-02-19 14:15:18 22154 [Warning] Aborted connection 22154 to db: 'mailman3' user: 'mailman3' host: 'localhost' (Got an error reading communication packets)
Thank you.
Sanyi
On 2/19/22 05:23, Sandor Dibuz wrote:
Am I right expecting that such warnings are harmless and probably come from timeouts and/or unterminated connections to the DB?
Feb 19 14:15:18 localhost mariadbd[28859]: 2022-02-19 14:15:18 22154 [Warning] Aborted connection 22154 to db: 'mailman3' user: 'mailman3' host: 'localhost' (Got an error reading communication packets)
You may be correct in your assumption that these are harmless. I would try to correlate them with access and error logs from the web/wsgi server to get more information.
Also see https://dba.stackexchange.com/questions/19135/mysql-error-reading-communicat...
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
On 2/19/22 20:46, Mark Sapiro wrote:
On 2/19/22 05:23, Sandor Dibuz wrote:
Feb 19 14:15:18 localhost mariadbd[28859]: 2022-02-19 14:15:18 22154 [Warning] Aborted connection 22154 to db: 'mailman3' user: 'mailman3' host: 'localhost' (Got an error reading communication packets)
You may be correct in your assumption that these are harmless. I would try to correlate them with access and error logs from the web/wsgi server to get more information.
It's the mailman quarterly cron job:
# Every 15 minutes, gate messages from usenet to those lists which have the gateway configured */15 * * * * list if [ -x /usr/bin/mailman ]; then /usr/bin/mailman gatenews; fi
And I have no gateway enabled for any of them. Will have to find out what mailman exactly does. And change MariaDB to verbose logging.
Sanyi
On 2/19/22 14:14, Sandor Dibuz wrote:
It's the mailman quarterly cron job:
# Every 15 minutes, gate messages from usenet to those lists which have the gateway configured */15 * * * * list if [ -x /usr/bin/mailman ]; then /usr/bin/mailman gatenews; fi
And I have no gateway enabled for any of them. Will have to find out what mailman exactly does. And change MariaDB to verbose logging.
First, If your Mailman core version is >= 3.3.5, you shouldn't be running gatenews via cron. Mailman's nntp runner runs it. See https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/docs/NEWS.h...
But, that probably isn't it because in Mailman >= 3.3.5, running gatenews via cron should produce this error
The gatenews command is run periodically by the nntp runner.
If you are running it via cron, you should remove it from the crontab.
If you want to run it manually, set _MAILMAN_GATENEWS_NNTP in the
environment.However, since you have no lists using a news->mail gateway, you don't need to run gatenews at all so just remove it from the crontab.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
On 2/20/22 01:56, Mark Sapiro wrote:
First, If your Mailman core version is >= 3.3.5, you shouldn't be running gatenews via cron. Mailman's nntp runner runs it. See https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/docs/NEWS.h...
But, that probably isn't it because in Mailman >= 3.3.5, running gatenews via cron should produce this error
The gatenews command is run periodically by the nntp runner. If you are running it via cron, you should remove it from the crontab. If you want to run it manually, set _MAILMAN_GATENEWS_NNTP in the environment.However, since you have no lists using a news->mail gateway, you don't need to run gatenews at all so just remove it from the crontab.
I installed Mm3 from Debian stable distro packages as one of the suggested installations methods in Mm3 docs. It's a bit of dated though I know but it was the easiest and fastest.
Mailman Core Version GNU Mailman 3.3.3 (Tom Sawyer) Mailman Core API Version 3.1 Mailman Core Python Version 3.9.2 (default, Feb 28 2021, 17:03:44) [GCC 10.2.1 20210110]
So I disabled gatenews cron job. Maybe later I bite the bullet and upgrade to a recent version (either venv or docker haven't decided yet) but will have to learn how to avoid conflicts with already installed deb packages first. So far so good and everything works, have to check changelogs if an upgrade is worth it.
Thank you all your help, Mark.
Sanyi
Teilnehmer (2)
-
Mark Sapiro -
Sandor Dibuz