Page MenuHomePhabricator

Wikimedia\Rdbms\DBQueryError: Inaccessible page in the Project_talk namespace on jawiki
Closed, ResolvedPublicPRODUCTION ERROR

Description

The page ja:Wikipedia‐ノート:カテゴリの方針 is currently inaccessible. Could someone with access to Logstash check the following error?

[cc0da9d0-bc52-4101-9aa8-5239a4442964] 2025-08-31 02:33:59: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Event Timeline

Restricted Application changed the subtype of this task from "Bug Report" to "Production Error". · View Herald TranscriptAug 31 2025, 2:40 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Dragoniez triaged this task as Unbreak Now! priority.Aug 31 2025, 8:09 PM

The page history is still accessible, but all revisions between 2025-08-24T06:58:44 and 2024-12-19T09:30:16 are unavailable. I was able to revert the page to the revision immediately preceding the oldest inaccessible revision, namely 2024-12-19T08:08:59, but protected the page just in case.

matmarex added subscribers: Ladsgroup, Zabe, matmarex.
[cc0da9d0-bc52-4101-9aa8-5239a4442964] /wiki/Wikipedia%E2%80%90%E3%83%8E%E3%83%BC%E3%83%88:%E3%82%AB%E3%83%86%E3%82%B4%E3%83%AA%E3%81%AE%E6%96%B9%E9%87%9D?uselang=1   Wikimedia\Rdbms\DBQueryError: Error 1054: Unknown column 'cl_to' in 'ON'
Function: MediaWiki\Extension\CategoryTree\CategoryTree::renderChildren
Query: SELECT  page_id,page_namespace,page_title,page_is_redirect,page_len,page_latest,cl_from,lt_title AS `cl_to`  FROM `categorylinks` JOIN `linktarget` ON ((lt_id=cl_target_id)) LEFT JOIN `page` ON ((cl_to = page_title) AND page_namespace = 14)   WHERE lt_namespace = 14 AND cl_from = 185298  ORDER BY cl_type,cl_sortkey LIMIT 200

Probably related to T299951: Normalize categorylinks table

Change #1183269 had a related patch set uploaded (by Ladsgroup; author: Zabe):

[mediawiki/extensions/CategoryTree@wmf/1.45.0-wmf.16] Drop support for categorylinks read old

https://gerrit.wikimedia.org/r/1183269

This would fix it ^ Not cherry picked yet.

I can try to deploy it early tomorrow. In a couple of hours.

Change #1183269 merged by jenkins-bot:

[mediawiki/extensions/CategoryTree@wmf/1.45.0-wmf.16] Drop support for categorylinks read old

https://gerrit.wikimedia.org/r/1183269

Mentioned in SAL (#wikimedia-operations) [2025-09-01T11:03:56Z] <ladsgroup@deploy1003> Started scap sync-world: Backport for [[gerrit:1183632|ParserTestRunner: Update category counts for articles (T365303)]], [[gerrit:1183633|CategoryCacheTest: Update category count]], [[gerrit:1183269|Drop support for categorylinks read old (T299951 T403147 T403337)]]

Mentioned in SAL (#wikimedia-operations) [2025-09-01T11:09:48Z] <ladsgroup@deploy1003> ladsgroup: Backport for [[gerrit:1183632|ParserTestRunner: Update category counts for articles (T365303)]], [[gerrit:1183633|CategoryCacheTest: Update category count]], [[gerrit:1183269|Drop support for categorylinks read old (T299951 T403147 T403337)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Mentioned in SAL (#wikimedia-operations) [2025-09-01T11:16:24Z] <ladsgroup@deploy1003> Finished scap sync-world: Backport for [[gerrit:1183632|ParserTestRunner: Update category counts for articles (T365303)]], [[gerrit:1183633|CategoryCacheTest: Update category count]], [[gerrit:1183269|Drop support for categorylinks read old (T299951 T403147 T403337)]] (duration: 12m 28s)

Ladsgroup claimed this task.
Ladsgroup edited projects, added DBA; removed Patch-For-Review.
Ladsgroup moved this task from Triage to Done on the DBA board.