1727322 - Pontoon database includes about 300k rejected translations with no rejected_date

Status: RESOLVED MOVED

(Webtools Graveyard :: Pontoon, defect, P3)

Description

[Eemeli Aro [:eemeli]]

Discovered while building historical data for Project Insights, these almost certainly have no effect on normal operations, but make it a bit difficult to generate some of the statistics correctly. Visible with e.g. this query:

SELECT pro.id, pro.name, count(*)
FROM
  base_translation AS tra,
  base_entity AS ent,
  base_resource AS res,
  base_project AS pro
WHERE
  tra.rejected AND tra.rejected_date IS NULL AND
  tra.entity_id = ent.id AND
  ent.resource_id = res.id AND
  res.project_id = pro.id
GROUP BY pro.id
ORDER BY pro.name;

As the creation dates of these translations are rather spread out, it looks like there's some process that updates the rejected field without a corresponding rejected_date change.

Comment 1

[Eemeli Aro [:eemeli]]

Dropping the block of 1725648, as the scope of the parent issue was clarified not to include the affected data.

Comment 2

[BMO Automation]

*This bug has been moved to GitHub.*

*Please check it out on https://github.com/mozilla/pontoon/issues.*