Page MenuHomePhabricator

pagetriage_page_tags table missing rows
Closed, InvalidPublic

Description

I created https://en.wikipedia.org/w/index.php?title=West_Four_Wrestling_Alliance&action=info and its not in the table

Background:
I created a large number of redirects recently, and was expecting them to be patrolled by bot. However, they never were. After a lot of digging, I found that

SELECT *
FROM page
LEFT JOIN pagetriage_page ON ptrp_page_id = page_id
LEFT JOIN pagetriage_page_tags ON ptrpt_page_id = ptrp_page_id
WHERE page_id = 62933448;

returns null for pagetriage_page_tags, i.e. that there are no tags for the page. There should be rows for that page. Just an example, I can give more pages if needed

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

...now I got the notifications that they were patrolled. How long is it supposed to take for the data to be populated?

Marostegui subscribed.

From what I can see, the rows are, at least, consistent in all enwiki hosts, as in, the data is the same, so we have no drifts.
I guess this is something on the application/MW layer? I am going to remove the DBA tag as there is no actionable yet for us here (I am will stay subscribed to this task in case I can be of further help).
Btw, not long ago I created T243073: Add primary key to pagetriage_page_tags

From what I can see, the rows are, at least, consistent in all enwiki hosts, as in, the data is the same, so we have no drifts.
I guess this is something on the application/MW layer? I am going to remove the DBA tag as there is no actionable yet for us here (I am will stay subscribed to this task in case I can be of further help).
Btw, not long ago I created T243073: Add primary key to pagetriage_page_tags

Given that the rows appeared, and that there is now a primary key that should make this faster in the future, this can probably be closed (resolved or invalid)