Hi, some time ago I made a migration from MySQL to PostgreSQL to be ready for Weblate 4.0. The process was very painful because it took several hours and ate about 26 GiB in RAM. Awesome django, awesome python :(
Since then, I have noticed that every time a new translation is created or a new PO file is loaded, PostgreSQL reports a constrains duplicity error and hangs a process that consumes 100% of one CPU core. There always repeats: constraint "checks_check_unit_id_check_f2985d9b_uniq". I have no idea what this is about, what should I do? I tried the managemnet command "updatechecks", but it didn't bring a change. Please some ideas? Is it a bug that I should report as issue or is there a problem specific for my instance? Cheers -- Slávek 2020-03-26 17:15:29.327 UTC [8090] weblate@weblate ERROR: duplicate key value violates unique constraint "checks_check_unit_id_check_f2985d9b_uniq" 2020-03-26 17:15:29.327 UTC [8090] weblate@weblate DETAIL: Key (unit_id, "check")=(5323886, translated) already exists. 2020-03-26 17:15:29.327 UTC [8090] weblate@weblate STATEMENT: INSERT INTO "checks_check" ("unit_id", "check", "ignore") VALUES (5323886, 'translated', false), (137598, 'translated', false), (6623554, 'translated', false) RETURNING "checks_check"."id" 2020-03-26 17:15:29.330 UTC [8090] weblate@weblate ERROR: duplicate key value violates unique constraint "checks_check_unit_id_check_f2985d9b_uniq" 2020-03-26 17:15:29.330 UTC [8090] weblate@weblate DETAIL: Key (unit_id, "check")=(5323886, translated) already exists. 2020-03-26 17:15:29.330 UTC [8090] weblate@weblate STATEMENT: INSERT INTO "checks_check" ("unit_id", "check", "ignore") VALUES (5323886, 'translated', false) RETURNING "checks_check"."id" 2020-03-26 17:15:29.331 UTC [8090] weblate@weblate ERROR: duplicate key value violates unique constraint "checks_check_unit_id_check_f2985d9b_uniq" 2020-03-26 17:15:29.331 UTC [8090] weblate@weblate DETAIL: Key (unit_id, "check")=(137598, translated) already exists. 2020-03-26 17:15:29.331 UTC [8090] weblate@weblate STATEMENT: INSERT INTO "checks_check" ("unit_id", "check", "ignore") VALUES (137598, 'translated', false) RETURNING "checks_check"."id" 2020-03-26 17:15:29.333 UTC [8090] weblate@weblate ERROR: duplicate key value violates unique constraint "checks_check_unit_id_check_f2985d9b_uniq" 2020-03-26 17:15:29.333 UTC [8090] weblate@weblate DETAIL: Key (unit_id, "check")=(6623554, translated) already exists. 2020-03-26 17:15:29.333 UTC [8090] weblate@weblate STATEMENT: INSERT INTO "checks_check" ("unit_id", "check", "ignore") VALUES (6623554, 'translated', false) RETURNING "checks_check"."id"
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ Weblate mailing list -- weblate@lists.cihar.com To unsubscribe send an email to weblate-le...@lists.cihar.com