772480 - developer-new.mozilla.org: discover and fix docs without content

Status: RESOLVED FIXED

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

Description

[Luke Crouch [:groovecoder]]

Our MDN content migration to developer-new lost some docs' content. We need to diagnose the extent of the loss (some SQL queries), and then re-run the migration script on the subset of docs to restore their content.

Let's start with:

select count(*) from wiki_revision where is_mindtouch_migration=1 and reviewed IS NULL

and

select count(d.id) from wiki_document as d, wiki_revision as r where d.id = r.document_id and r.is_mindtouch_migration=1 and r.reviewed IS NULL group by d.id

on the kuma database.

Comment 1

[Brandon Burton [:solarce]]

Attachment: sql output

Attached is the queries and output