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 -- [email protected] To unsubscribe send an email to [email protected]
