Your message dated Wed, 23 Jan 2019 13:58:37 +0000 with message-id <[email protected]> and subject line Bug#914099: fixed in mailman-suite 0+20180916-4 has caused the Debian Bug report #914099, regarding hyperkitty: qcluster causes high database load to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 914099: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=914099 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: mailman3-full Version: 3.2.0-2 Severity: important Dear Maintainer, I installed the mailman3-full package from the buster repository. The qcluster component generates a high database load with these queries: [...] 2018-11-17 16:33:15.417 UTC [8304] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:15.385901+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:15.663 UTC [8305] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:15.621505+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:15.664 UTC [8306] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:15.624011+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:15.908 UTC [8308] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:15.870547+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:15.910 UTC [8307] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:15.871611+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:16.152 UTC [8310] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:16.116762+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:16.154 UTC [8309] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:16.114878+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:16.390 UTC [8311] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:16.358211+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:16.393 UTC [8312] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:16.359704+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:16.634 UTC [8313] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:16.596602+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:16.636 UTC [8314] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:16.598296+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:16.882 UTC [8315] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:16.842795+00:00'::timestamptz) LIMIT 1 2018-11-17 16:33:16.884 UTC [8316] mailman3web@mailman3web LOG: statement: SELECT "django_q_ormq"."id", "django_q_ormq"."key", "django_q_ormq"."payload", "django_q_ormq"."lock" FROM "django_q_ormq" WHERE ("django_q_ormq"."key" = 'default' AND "django_q_ormq"."lock" < '2018-11-17T16:32:16.841916+00:00'::timestamptz) LIMIT 1 [...] I have also reported the issue here: https://lists.mailman3.org/archives/list/[email protected]/thread/ZYDCUNAOZQDG2Y24ARRNUSNKHQ4JDEY7/ I don't yet know where these queries come from, but they cause an annoying network load. Stefan
--- End Message ---
--- Begin Message ---Source: mailman-suite Source-Version: 0+20180916-4 We believe that the bug you reported is fixed in the latest version of mailman-suite, which is due to be installed in the Debian FTP archive. A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [email protected], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Jonas Meurer <[email protected]> (supplier of updated mailman-suite package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Format: 1.8 Date: Wed, 23 Jan 2019 12:21:14 +0100 Source: mailman-suite Architecture: source Version: 0+20180916-4 Distribution: unstable Urgency: medium Maintainer: Debian Mailman Team <[email protected]> Changed-By: Jonas Meurer <[email protected]> Closes: 914099 Changes: mailman-suite (0+20180916-4) unstable; urgency=medium . * d/mailman3-web.cron.d: - Fix indention in mailman3-web cron.d file * d/p/0001_settings_py.patch: - Set queue polling inteval for django-q cluster to 5 seconds (defaults to 0.2 seconds) to decrease the database load. (Closes: #914099) * d/mailman3-web-mailman3-web-qcluster.service: - Remove superfluous systemd service file. The qcluster processes are already spawned automatically as children of mailman3-web.service. Checksums-Sha1: 1d2b1657f5d797d8535f83486fa0ceca1bae4c4f 2053 mailman-suite_0+20180916-4.dsc fd6d39597f22d9e782bb2aafdae0ffb261811a5c 25800 mailman-suite_0+20180916-4.debian.tar.xz 97e2430656b38632377fe680b9c02516c9ff109b 5693 mailman-suite_0+20180916-4_amd64.buildinfo Checksums-Sha256: 2327762e3c7e084c2bc9ade28f2a1bfa82bfd4063cc1d062ead8ce8c411a661d 2053 mailman-suite_0+20180916-4.dsc ec10f42b5875325660f42df34548c6dfa13938cbe64007683d10562848bd90b6 25800 mailman-suite_0+20180916-4.debian.tar.xz eb481032fcabaf8ca090e59636af3d863e9bff8dde79a8c42c8b614153b8253f 5693 mailman-suite_0+20180916-4_amd64.buildinfo Files: a7344612828cc8573c378b11077c8e04 2053 web optional mailman-suite_0+20180916-4.dsc bfb02c14567b896cd756d083dbe50404 25800 web optional mailman-suite_0+20180916-4.debian.tar.xz e483162dda22c61d5063fba3a8faa0c0 5693 web optional mailman-suite_0+20180916-4_amd64.buildinfo -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEELIzSg9Pv30M4kOeDUmLn/0kQSf4FAlxIavsACgkQUmLn/0kQ Sf6QpA//dRYiOdhQHEcjOl4rtOEilZhv09CgwKAjqIomTp5o0EJe6t/YtmYM0t9X meX6aGdL53y2USBVoWnA/4U3yvOQeylWcJ9VNpxZS+MwZ+NPq0cjT11XQm+W5NVN XYkrqhfJ7bjbkhSNa5X4guoLb3t5WHImI0SteikT7ApkLJhe8v6ITgn/L/CKWKUt bTHij91OmgUB8GHGjYFHRgV9Yu2cE0aX3HxvtR3+oXoOALc30vI2uwpGVW5eimmd wwwxki81Eok/951EO4wSL2pjlhtbKtLxVLy9bJx6XyrcFyMXSxYeaA8eeK429VQZ bmJYB+Zo4apSofdWCfihUqaEYLiCgjXYYsW1eNoHYtHQRNFrrv1zLyqFbGBG1atV dcUGgR8Z3Ctmxxto0kGaqJm5S55szuhsWR3WFFVcZ1/s2vYDOPgqkEEI4HbuzLCj RWewHyy+8oRi9eS6EDCsBa+KkNWhu/Z90tlj0+jI5MszY0LikoT7v1L4QSsPdTI9 1Rz29OpcmBte1McRV4zIMDhJ2gvrj7YHCL3Is4NrnO+F3CWahDgUd3KquP5a+0lv sqfvAhTh4fOSUtxGT7Jjqr7ktDHUOWE0koNEGGmjtklJGysE/2nmwdhecfT7Fd0u Ex4JbOwclapjWYOwQ+HXwRRWtPdwJGbUq+tJxk8vjExVoeX8S7o= =2Bko -----END PGP SIGNATURE-----
--- End Message ---
