Page MenuHomePhabricator

Replication issue with Fa WP replica
Closed, ResolvedPublic

Description

I was querying Fa WP replica on labs today looking for article that are not in any categories, and noticed that the results included three articles which had been deleted on Fa WP on July 12, 2015 but the replica still treats them as if they were not deleted, i.e. the records are in the page and revision tables, not in the archive table. The pages are w:fa:محیط_عملیاتی , w:fa:محمدسجاد_بداغی , and w:fa:آمیتیس

Here is my SQL query, which is expected NOT to include those pages:

select page_title from page left join categorylinks on page_id = cl_from where page_namespace = 0 and page_is_redirect = 0 and cl_from is null

Reporting here to allow investigating for replication errors.

Event Timeline

Huji raised the priority of this task from to Lowest.
Huji updated the task description. (Show Details)
Huji added a project: Cloud-Services.
Huji subscribed.
Huji set Security to None.
jcrespo claimed this task.

This was indeed incorrect on labsdb1003 only, it how now been solved:

labsdb1003[fawiki_p]> select * from page WHERE page_namespace = 0 and page_title IN ('محیط_عملیاتی', 'محمدسجاد_بداغی', 'آمیتیس');
Empty set (0.00 sec)