Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] At regular intervals, connections to MySQL database fail #710

Open
raph-topo opened this issue Jul 2, 2024 · 1 comment
Open

[BUG] At regular intervals, connections to MySQL database fail #710

raph-topo opened this issue Jul 2, 2024 · 1 comment
Labels

Comments

@raph-topo
Copy link
Contributor

Bug

A recurring [Warning] Aborted connection appears in the logs.

Containers

services:
 mailman-core:
    image: maxking/mailman-core:0.5
  mailman-web:
    image: maxking/mailman-web:0.5
  database:
    image: mariadb:10.5

Database configured as in:

database:
environment:
MYSQL_DATABASE: mailmandb
MYSQL_USER: mailman
MYSQL_PASSWORD: mailmanpass
MYSQL_RANDOM_ROOT_PASSWORD: "yes"
image: mariadb:10.5
command: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
volumes:
- /opt/mailman/database:/var/lib/mysql
networks:
mailman:

Logs

From container database

Host 172.24.0.24 is container mailman-core

2024-07-02 12:15:52 10484 [Warning] Aborted connection 10484 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 12:20:52 10487 [Warning] Aborted connection 10487 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 12:25:52 10494 [Warning] Aborted connection 10494 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 12:30:53 10497 [Warning] Aborted connection 10497 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 12:35:53 10504 [Warning] Aborted connection 10504 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 12:40:53 10508 [Warning] Aborted connection 10508 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 12:45:55 10512 [Warning] Aborted connection 10512 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 12:50:54 10517 [Warning] Aborted connection 10517 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 12:55:55 10522 [Warning] Aborted connection 10522 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:00:55 10526 [Warning] Aborted connection 10526 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:05:56 10532 [Warning] Aborted connection 10532 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:10:56 10537 [Warning] Aborted connection 10537 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:15:57 10542 [Warning] Aborted connection 10542 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:20:58 10547 [Warning] Aborted connection 10547 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:25:57 10553 [Warning] Aborted connection 10553 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:30:58 10556 [Warning] Aborted connection 10556 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:35:58 10563 [Warning] Aborted connection 10563 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:40:59 10567 [Warning] Aborted connection 10567 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)
2024-07-02 13:46:01 10571 [Warning] Aborted connection 10571 to db: 'mailman' user: 'mailman' host: '172.24.0.24' (Got an error reading communication packets)

It strikes me that the warning appears at 5 minute intervals (+- few seconds), with no such line created by interacting with Postorius or Hyperkitty.

Is there a cron job configured in mailman-core at a 5 minute interval?

@raph-topo raph-topo added the bug label Jul 2, 2024
@barats
Copy link

barats commented Jul 29, 2024

Same here.

Is there any upgrade for this?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants