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/mailman-us...@mailman3.org/thread/ZYDCUNAOZQDG2Y24ARRNUSNKHQ4JDEY7/
I don't yet know where these queries come from, but they cause an annoying
network load.
Stefan
