What type of hardware are you using: Virtual machine
What YunoHost version are you running: 12.0.7
What app is this about: mailman3
Describe your issue
After (smooth) upgrade to yunhost 12, mailman3 service does not start.
systemctl status mailman3 output is (actual website name hidden) :
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: File “/usr/lib/python3/dist-packages/sqlalchemy/engine/url.py”, line 662, in _get_entrypoint
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: cls = registry.load(name)
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: ^^^^^^^^^^^^^^^^^^^
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: File “/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py”, line 343, in load
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: raise exc.NoSuchModuleError(
Nov 04 11:45:36 XXXXX.XXX mailman3[1205]: sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
Nov 04 11:45:36 XXXXX.XXX systemd[1]: mailman3.service: Control process exited, code=exited, status=1/FAILURE
Nov 04 11:45:36 XXXXX.XXX systemd[1]: mailman3.service: Failed with result ‘exit-code’.
Nov 04 11:45:36 XXXXX.XXX systemd[1]: Failed to start mailman3.service - Mailman3 server.
Nov 04 11:45:36 XXXXX.XXX systemd[1]: mailman3.service: Consumed 1.172s CPU time.
After googling the messages, the error seems to be related to a postgres/postgresql problem (Can’t load plugin: sqlalchemy.dialects:postgres) but I can’t find the origin of the problem.
Any help welcome
Thanks
Share relevant logs or error messages
LOGFILE: journalctl
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/click/core.py”, line 1130, in call
Nov 14 14:33:58 mailman3[780343]: return self.main(*args, **kwargs)
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/click/core.py”, line 1054, in main
Nov 14 14:33:58 mailman3[780343]: with self.make_context(prog_name, args, **extra) as ctx:
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/click/core.py”, line 920, in make_context
Nov 14 14:33:58 mailman3[780343]: self.parse_args(ctx, args)
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/click/core.py”, line 1613, in parse_args
Nov 14 14:33:58 mailman3[780343]: rest = super().parse_args(ctx, args)
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/click/core.py”, line 1378, in parse_args
Nov 14 14:33:58 mailman3[780343]: value, args = param.handle_parse_result(ctx, opts, args)
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/click/core.py”, line 2360, in handle_parse_result
Nov 14 14:33:58 mailman3[780343]: value = self.process_value(ctx, value)
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/click/core.py”, line 2322, in process_value
Nov 14 14:33:58 mailman3[780343]: value = self.callback(ctx, self, value)
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/mailman/bin/mailman.py”, line 95, in initialize_config
Nov 14 14:33:58 mailman3[780343]: initialize(value)
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/mailman/core/initialize.py”, line 229, in initialize
Nov 14 14:33:58 mailman3[780343]: initialize_2(propagate_logs=propagate_logs)
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/mailman/core/initialize.py”, line 187, in initialize_2
Nov 14 14:33:58 mailman3[780343]: config.db = getUtility(IDatabaseFactory, utility_name).create()
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/mailman/database/factory.py”, line 57, in create
Nov 14 14:33:58 mailman3[780343]: database.initialize()
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/mailman/database/base.py”, line 117, in initialize
Nov 14 14:33:58 mailman3[780343]: self.engine = create_engine(
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “”, line 2, in create_engine
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/sqlalchemy/util/deprecations.py”, line 375, in warned
Nov 14 14:33:58 mailman3[780343]: return fn(*args, **kwargs)
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/sqlalchemy/engine/create.py”, line 522, in create_engine
Nov 14 14:33:58 mailman3[780343]: entrypoint = u._get_entrypoint()
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/sqlalchemy/engine/url.py”, line 662, in _get_entrypoint
Nov 14 14:33:58 mailman3[780343]: cls = registry.load(name)
Nov 14 14:33:58 mailman3[780343]: ^^^^^^^^^^^^^^^^^^^
Nov 14 14:33:58 mailman3[780343]: File “/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py”, line 343, in load
Nov 14 14:33:58 mailman3[780343]: raise exc.NoSuchModuleError(
Nov 14 14:33:58 mailman3[780343]: sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
Nov 14 14:33:58 systemd[1]: mailman3.service: Control process exited, code=exited, status=1/FAILURE
Nov 14 14:33:58 systemd[1]: mailman3.service: Failed with result ‘exit-code’.
Nov 14 14:33:58 systemd[1]: Failed to start mailman3.service - Mailman3 server.
Nov 14 14:33:58 systemd[1]: mailman3.service: Consumed 1.173s CPU time.
LOGFILE: /var/log/mailman3/mailman.log
[04/Nov/2024:01:01:19 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:01:13:58 +0000] “GET /3.1/lists?advertised=true&count=0&page=1 HTTP/1.1” 200 90 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:01:13:58 +0000] “GET /3.1/lists?advertised=true&count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:01:13:58 +0000] “GET /3.1/domains HTTP/1.1” 200 370 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:01:13:58 +0000] “GET /3.1/domains/mailman.seismic-unix.org HTTP/1.1” 200 265 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:02:00:08 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:03:00:09 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:04:01:59 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:05:01:13 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:05:37:12 +0000] “GET /3.1/lists?advertised=true&count=0&page=1 HTTP/1.1” 200 90 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:05:37:13 +0000] “GET /3.1/lists?advertised=true&count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:05:37:13 +0000] “GET /3.1/lists?advertised=true&count=0&page=1 HTTP/1.1” 200 90 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:05:37:14 +0000] “GET /3.1/domains HTTP/1.1” 200 370 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:05:37:14 +0000] “GET /3.1/domains/mailman.seismic-unix.org HTTP/1.1” 200 265 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:05:37:14 +0000] “GET /3.1/lists?advertised=true&count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:05:37:14 +0000] “GET /3.1/domains HTTP/1.1” 200 370 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:05:37:15 +0000] “GET /3.1/domains/mailman.seismic-unix.org HTTP/1.1” 200 265 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:06:00:08 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:07:00:08 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:08:00:08 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:09:00:07 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[04/Nov/2024:10:00:20 +0000] “GET /3.1/lists?count=10&page=1 HTTP/1.1” 200 553 “-” “GNU Mailman REST client v3.3.2”
[2024-11-04 10:34:40 +0000] [3709554] [INFO] Worker exiting (pid: 3709554)
Nov 04 10:34:40 2024 (941061) in runner caught SIGTERM. Stopping.
Nov 04 10:34:40 2024 (941050) Master watcher caught SIGTERM. Exiting.
Nov 04 10:34:40 2024 (941076) retry runner caught SIGTERM. Stopping.
Nov 04 10:34:40 2024 (941079) virgin runner caught SIGTERM. Stopping.
Nov 04 10:34:40 2024 (941068) nntp runner caught SIGTERM. Stopping.
Nov 04 10:34:40 2024 (941056) archive runner caught SIGTERM. Stopping.
[2024-11-04 10:34:40 +0000] [941074] [INFO] Handling signal: term
Nov 04 10:34:40 2024 (941058) command runner caught SIGTERM. Stopping.
Nov 04 10:34:40 2024 (941081) digest runner caught SIGTERM. Stopping.
Nov 04 10:34:40 2024 (941073) pipeline runner caught SIGTERM. Stopping.
[2024-11-04 10:34:40 +0000] [3709553] [INFO] Worker exiting (pid: 3709553)
Nov 04 10:34:40 2024 (941062) lmtp runner caught SIGTERM. Stopping.
Nov 04 10:34:40 2024 (941069) out runner caught SIGTERM. Stopping.
Nov 04 10:34:41 2024 (941061) in runner exiting.
Nov 04 10:34:41 2024 (941081) digest runner exiting.
Nov 04 10:34:41 2024 (941058) command runner exiting.
Nov 04 10:34:41 2024 (941056) archive runner exiting.
Nov 04 10:34:41 2024 (941073) pipeline runner exiting.
Nov 04 10:34:41 2024 (941079) virgin runner exiting.
Nov 04 10:34:42 2024 (941062) lmtp runner exiting.
Nov 04 10:34:42 2024 (941069) out runner exiting.
Nov 04 10:34:42 2024 (941068) nntp runner exiting.
Nov 04 10:34:42 2024 (941076) retry runner exiting.
[2024-11-04 10:35:11 +0000] [941074] [WARNING] Worker with pid 3709553 was terminated due to signal 9
[2024-11-04 10:35:11 +0000] [941074] [WARNING] Worker with pid 3709554 was terminated due to signal 9
[2024-11-04 10:35:11 +0000] [941074] [INFO] Shutting down: Master
Nov 04 10:35:27 2024 (941050) Master stopped