Fix remaining page records with page_latest == 0 in database.
Open, Needs TriagePublic
Actions

Assigned To

Authored By

	• holger.knust
	Sep 1 2020, 9:45 PM

Description

This is the follow-up ticket to T115081 There is maintenance script in Core (attachLatest.php) that fixes the references for pages with existing revisions. Pages that have no revisions can obviously not be corrected and should probably be deleted.

Related Objects
Search...

Status	Subtype	Assigned	Task
Open		None	T115081 Determine root cause of inaccessible pages having `page_latest = 0`
Duplicate	PRODUCTION ERROR	None	T258321 Fatal exception of type "MWException" on arzwiki when renaming articles
Open		TheresNoTime	T261797 Fix remaining page records with page_latest == 0 in database.

Event Timeline

• holger.knust created this task.Sep 1 2020, 9:45 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 1 2020, 9:45 PM

• holger.knust added a parent task: T115081: Determine root cause of inaccessible pages having `page_latest = 0`.Sep 1 2020, 9:45 PM

• holger.knust moved this task from Inbox to Tracking/Watching on the Platform Engineering board.

Removing the DBA tag here as there's nothing for us to do, as we don't really run maintenance scripts.
I will kept subscribed to this task in case I'm needed for something else!
As long as the script has wait for replication and isn't issuing big deletes, it should be fine tu be run anytime. But a heads-up on this task would be useful

Thanks!

This appears to be blocking resolution of a production error (T258321), and is pending action by PE. Politely asking for re-triage as it appears to be moved to Tracking without an obvious reason or by accident.

Krinkle moved this task from Untriaged to Bad data & Corruption on the Wikimedia-database-issue board.Mar 7 2022, 8:19 PM

Krinkle mentioned this in T157670: Periodically run refreshLinks.php on production sites.Mar 24 2022, 6:05 PM

Krinkle edited projects, added Wikimedia-database-issue (Bad data); removed Wikimedia-database-issue.Apr 9 2022, 6:06 PM

Frostly added a project: Wikimedia-maintenance-script-run.Mar 3 2024, 2:16 AM

There are just 16 of these; I call them the "Sweet Sixteen". They've been in the database "forever". Why do you need a script to deal with just 16 items? Why can't someone just manually delete them?

Peachey88 moved this task from Backlog to WMF Prod on the Wikimedia-maintenance-script-run board.May 11 2024, 11:04 PM

T281921 looks similar, so it's likely the bug also prevents creation of the pages. T46199 also looks similar, and was fixed by deleting the page - has that been attempted? If there are no revisions, nothing would be lost.

TheresNoTime subscribed.Mar 19 2025, 4:25 PM

TheresNoTime mentioned this in T281921: Error trying to create page on bnwiki: "The revision #0 of the page named "টেমপ্লেট:Arguments" does not exist.".Mar 19 2025, 4:55 PM

Given

[samtar@deploy2002 ~]$ mwscript-k8s -f -- attachLatest.php --wiki=enwiki
⏳ Starting attachLatest.php on Kubernetes as job mw-script.eqiad.m0m6vos4 ...
⏳ Waiting for the container to start...
🚀 Job is running.
📜 Streaming logs:
Looking for pages with page_latest set to 0...
enwiki 19113987 [[User talk:1r3gr37n0n]] can't find latest rev time?!
enwiki 19399178 [[User talk:Vd437]] can't find latest rev time?!
enwiki 20513897 [[User talk:Heelo1]] can't find latest rev time?!
enwiki 22427194 [[User talk:HOTPOCKETSG]] can't find latest rev time?!
enwiki 22427202 [[User talk:Jaeh0317]] can't find latest rev time?!
enwiki 24090446 [[User talk:Mightym53821]] can't find latest rev time?!
enwiki 33750317 [[User talk:68.148.238.76]] can't find latest rev time?!
enwiki 35711061 [[User talk:Lilyonthevalley]] can't find latest rev time?!
enwiki 36111672 [[Wikipedia:Articles for deletion/2009 Sulu kidnapping crisis]] can't find latest rev time?!
enwiki 36111674 [[Wikipedia:Articles for deletion/3 Libras (song)]] can't find latest rev time?!
enwiki 36111680 [[User talk:Ttylxox1000]] can't find latest rev time?!
enwiki 36111682 [[Wikipedia:Articles for deletion/333: A Bibliography of the Science-Fantasy Novel]] can't find latest rev time?!
enwiki 36111687 [[Wikipedia:Articles for deletion/2009 Sulu kidnapping crisis (2nd nomination)]] can't find latest rev time?!
enwiki 36111692 [[Wikipedia:Articles for deletion/2009 Sulu kidnapping crisis (3rd nomination)]] can't find latest rev time?!
enwiki 36111727 [[User talk:Vishal.gkamath]] can't find latest rev time?!
enwiki 41990041 [[User talk:71.129.57.41]] can't find latest rev time?!
Done! Processed 0 pages.
This was a dry run; rerun with --fix to update page_latest.

I've gone through and deleted some of these (the User talk pages, for now) after confirming there are no revisions nor logging table entries for them:

P74263 enwiki: (ns=3) page deletes for T261797

1	User talk:1r3gr37n0n - (id=19113987) (ns=3)
2	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 19113987 limit 2;
3	page_id page_touched page_namespace page_title page_latest
4	19113987 20220324080028 3 1r3gr37n0n 0
5
6	Running query: select * from revision where rev_page = 19113987 limit 2;
7	[✓] No revisions found for this page
8	Running query: select * from logging where log_namespace = 3 and log_title = "1r3gr37n0n" limit 2;
9	[✓] No logs found for this page
10	Running query: delete from page where page_id = 19113987 and page_namespace = 3 limit 1;
11	[✓] Deleted User talk:1r3gr37n0n (id=19113987)
12
13
14
15	User talk:Vd437 - (id=19399178) (ns=3)
16	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 19399178 limit 2;
17	page_id page_touched page_namespace page_title page_latest
18	19399178 20220324081347 3 Vd437 0
19
20	Running query: select * from revision where rev_page = 19399178 limit 2;
21	[✓] No revisions found for this page
22	Running query: select * from logging where log_namespace = 3 and log_title = "Vd437" limit 2;
23	[✓] No logs found for this page
24	Running query: delete from page where page_id = 19399178 and page_namespace = 3 limit 1;
25	[✓] Deleted User talk:Vd437 (id=19399178)
26
27
28
29	User talk:Heelo1 - (id=20513897) (ns=3)
30	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 20513897 limit 2;
31	page_id page_touched page_namespace page_title page_latest
32	20513897 20231104232017 3 Heelo1 0
33
34	Running query: select * from revision where rev_page = 20513897 limit 2;
35	[✓] No revisions found for this page
36	Running query: select * from logging where log_namespace = 3 and log_title = "Heelo1" limit 2;
37	[✓] No logs found for this page
38	Running query: delete from page where page_id = 20513897 and page_namespace = 3 limit 1;
39	[✓] Deleted User talk:Heelo1 (id=20513897)
40
41
42
43	User talk:HOTPOCKETSG - (id=22427194) (ns=3)
44	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 22427194 limit 2;
45	page_id page_touched page_namespace page_title page_latest
46	22427194 20220324080028 3 HOTPOCKETSG 0
47
48	Running query: select * from revision where rev_page = 22427194 limit 2;
49	[✓] No revisions found for this page
50	Running query: select * from logging where log_namespace = 3 and log_title = "HOTPOCKETSG" limit 2;
51	[✓] No logs found for this page
52	Running query: delete from page where page_id = 22427194 and page_namespace = 3 limit 1;
53	[✓] Deleted User talk:HOTPOCKETSG (id=22427194)
54
55
56
57	User talk:Jaeh0317 - (id=22427202) (ns=3)
58	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 22427202 limit 2;
59	page_id page_touched page_namespace page_title page_latest
60	22427202 20220324080028 3 Jaeh0317 0
61
62	Running query: select * from revision where rev_page = 22427202 limit 2;
63	[✓] No revisions found for this page
64	Running query: select * from logging where log_namespace = 3 and log_title = "Jaeh0317" limit 2;
65	[✓] No logs found for this page
66	Running query: delete from page where page_id = 22427202 and page_namespace = 3 limit 1;
67	[✓] Deleted User talk:Jaeh0317 (id=22427202)
68
69
70
71	User talk:Mightym53821 - (id=24090446) (ns=3)
72	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 24090446 limit 2;
73	page_id page_touched page_namespace page_title page_latest
74	24090446 20220324080028 3 Mightym53821 0
75
76	Running query: select * from revision where rev_page = 24090446 limit 2;
77	[✓] No revisions found for this page
78	Running query: select * from logging where log_namespace = 3 and log_title = "Mightym53821" limit 2;
79	[✓] No logs found for this page
80	Running query: delete from page where page_id = 24090446 and page_namespace = 3 limit 1;
81	[✓] Deleted User talk:Mightym53821 (id=24090446)
82
83
84
85	User talk:68.148.238.76 - (id=33750317) (ns=3)
86	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 33750317 limit 2;
87	page_id page_touched page_namespace page_title page_latest
88	33750317 20220324080028 3 68.148.238.76 0
89
90	Running query: select * from revision where rev_page = 33750317 limit 2;
91	[✓] No revisions found for this page
92	Running query: select * from logging where log_namespace = 3 and log_title = "68.148.238.76" limit 2;
93	[✓] No logs found for this page
94	Running query: delete from page where page_id = 33750317 and page_namespace = 3 limit 1;
95	[✓] Deleted User talk:68.148.238.76 (id=33750317)
96
97
98
99	User talk:Lilyonthevalley - (id=35711061) (ns=3)
100	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 35711061 limit 2;
101	page_id page_touched page_namespace page_title page_latest
102	35711061 20220324080028 3 Lilyonthevalley 0
103
104	Running query: select * from revision where rev_page = 35711061 limit 2;
105	[✓] No revisions found for this page
106	Running query: select * from logging where log_namespace = 3 and log_title = "Lilyonthevalley" limit 2;
107	[✓] No logs found for this page
108	Running query: delete from page where page_id = 35711061 and page_namespace = 3 limit 1;
109	[✓] Deleted User talk:Lilyonthevalley (id=35711061)
110
111
112
113	User talk:Ttylxox1000 - (id=36111680) (ns=3)
114	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 36111680 limit 2;
115	page_id page_touched page_namespace page_title page_latest
116	36111680 20220324080028 3 Ttylxox1000 0
117
118	Running query: select * from revision where rev_page = 36111680 limit 2;
119	[✓] No revisions found for this page
120	Running query: select * from logging where log_namespace = 3 and log_title = "Ttylxox1000" limit 2;
121	[✓] No logs found for this page
122	Running query: delete from page where page_id = 36111680 and page_namespace = 3 limit 1;
123	[✓] Deleted User talk:Ttylxox1000 (id=36111680)
124
125
126
127	User talk:Vishal.gkamath - (id=36111727) (ns=3)
128	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 36111727 limit 2;
129	page_id page_touched page_namespace page_title page_latest
130	36111727 20220324082013 3 Vishal.gkamath 0
131
132	Running query: select * from revision where rev_page = 36111727 limit 2;
133	[✓] No revisions found for this page
134	Running query: select * from logging where log_namespace = 3 and log_title = "Vishal.gkamath" limit 2;
135	[✓] No logs found for this page
136	Running query: delete from page where page_id = 36111727 and page_namespace = 3 limit 1;
137	[✓] Deleted User talk:Vishal.gkamath (id=36111727)
138
139
140
141	User talk:71.129.57.41 - (id=41990041) (ns=3)
142	Running query: select page_id, page_touched, page_namespace, page_title, page_latest from page where page_id = 41990041 limit 2;
143	page_id page_touched page_namespace page_title page_latest
144	41990041 20250319202707 3 71.129.57.41 0
145
146	Running query: select * from revision where rev_page = 41990041 limit 2;
147	[✓] No revisions found for this page
148	Running query: select * from logging where log_namespace = 3 and log_title = "71.129.57.41" limit 2;
149	[✓] No logs found for this page
150	Running query: delete from page where page_id = 41990041 and page_namespace = 3 limit 1;
151	[✓] Deleted User talk:71.129.57.41 (id=41990041)

Novem_Linguae subscribed.Aug 22 2025, 2:15 AM

Fix remaining page records with page_latest == 0 in database.Open, Needs TriagePublicActions

Description

Related ObjectsSearch...

Event Timeline

Fix remaining page records with page_latest == 0 in database.
Open, Needs TriagePublic
Actions

Related Objects
Search...