Page MenuHomePhabricator
Create Task
Maniphest T281223

MediaWiki\Revision\RevisionAccessException: Failed to load data blob from tt:9375723: Bad data in text row 9375723. Use findBadBlobs.php to remedy.. If this problem persist, use the findBadBlobs maintenance script to investigate the issue and mark bad blobs.
Closed, DuplicatePublicPRODUCTION ERROR
Actions

Description

Error
normalized_message
[{reqId}] {exception_url}   MediaWiki\Revision\RevisionAccessException: Failed to load data blob from tt:9375723: Bad data in text row 9375723. Use findBadBlobs.php to remedy.. If this problem persist, use the findBadBlobs maintenance script to investigat
exception.trace
from /srv/mediawiki/php-1.37.0-wmf.1/includes/Revision/RevisionStore.php(1193)
#0 /srv/mediawiki/php-1.37.0-wmf.1/includes/Revision/RevisionStore.php(1463): MediaWiki\Revision\RevisionStore->loadSlotContent(MediaWiki\Revision\SlotRecord, NULL, NULL, NULL, integer)
#1 [internal function]: MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}(MediaWiki\Revision\SlotRecord)
#2 /srv/mediawiki/php-1.37.0-wmf.1/includes/Revision/SlotRecord.php(324): call_user_func(Closure, MediaWiki\Revision\SlotRecord)
#3 /srv/mediawiki/php-1.37.0-wmf.1/includes/Revision/RevisionRecord.php(164): MediaWiki\Revision\SlotRecord->getContent()
#4 /srv/mediawiki/php-1.37.0-wmf.1/includes/page/WikiPage.php(931): MediaWiki\Revision\RevisionRecord->getContent(string, integer, NULL)
#5 /srv/mediawiki/php-1.37.0-wmf.1/includes/page/WikiPage.php(1168): WikiPage->getContent()
#6 /srv/mediawiki/php-1.37.0-wmf.1/includes/page/WikiPage.php(1154): WikiPage->insertRedirect()
#7 /srv/mediawiki/php-1.37.0-wmf.1/includes/page/WikiPage.php(1239): WikiPage->getRedirectTarget()
#8 /srv/mediawiki/php-1.37.0-wmf.1/includes/MediaWiki.php(464): WikiPage->followRedirect()
#9 /srv/mediawiki/php-1.37.0-wmf.1/includes/MediaWiki.php(317): MediaWiki->initializeArticle()
#10 /srv/mediawiki/php-1.37.0-wmf.1/includes/MediaWiki.php(916): MediaWiki->performRequest()
#11 /srv/mediawiki/php-1.37.0-wmf.1/includes/MediaWiki.php(550): MediaWiki->main()
#12 /srv/mediawiki/php-1.37.0-wmf.1/index.php(53): MediaWiki->run()
#13 /srv/mediawiki/php-1.37.0-wmf.1/index.php(46): wfIndexMain()
#14 /srv/mediawiki/w/index.php(3): require(string)
#15 {main}
exception.previous.trace
from /srv/mediawiki/php-1.37.0-wmf.1/includes/Storage/SqlBlobStore.php(295)
#0 /srv/mediawiki/php-1.37.0-wmf.1/includes/Revision/RevisionStore.php(1191): MediaWiki\Storage\SqlBlobStore->getBlob(string, integer)
#1 /srv/mediawiki/php-1.37.0-wmf.1/includes/Revision/RevisionStore.php(1463): MediaWiki\Revision\RevisionStore->loadSlotContent(MediaWiki\Revision\SlotRecord, NULL, NULL, NULL, integer)
#2 [internal function]: MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}(MediaWiki\Revision\SlotRecord)
#3 /srv/mediawiki/php-1.37.0-wmf.1/includes/Revision/SlotRecord.php(324): call_user_func(Closure, MediaWiki\Revision\SlotRecord)
#4 /srv/mediawiki/php-1.37.0-wmf.1/includes/Revision/RevisionRecord.php(164): MediaWiki\Revision\SlotRecord->getContent()
#5 /srv/mediawiki/php-1.37.0-wmf.1/includes/page/WikiPage.php(931): MediaWiki\Revision\RevisionRecord->getContent(string, integer, NULL)
#6 /srv/mediawiki/php-1.37.0-wmf.1/includes/page/WikiPage.php(1168): WikiPage->getContent()
#7 /srv/mediawiki/php-1.37.0-wmf.1/includes/page/WikiPage.php(1154): WikiPage->insertRedirect()
#8 /srv/mediawiki/php-1.37.0-wmf.1/includes/page/WikiPage.php(1239): WikiPage->getRedirectTarget()
#9 /srv/mediawiki/php-1.37.0-wmf.1/includes/MediaWiki.php(464): WikiPage->followRedirect()
#10 /srv/mediawiki/php-1.37.0-wmf.1/includes/MediaWiki.php(317): MediaWiki->initializeArticle()
#11 /srv/mediawiki/php-1.37.0-wmf.1/includes/MediaWiki.php(916): MediaWiki->performRequest()
#12 /srv/mediawiki/php-1.37.0-wmf.1/includes/MediaWiki.php(550): MediaWiki->main()
#13 /srv/mediawiki/php-1.37.0-wmf.1/index.php(53): MediaWiki->run()
#14 /srv/mediawiki/php-1.37.0-wmf.1/index.php(46): wfIndexMain()
#15 /srv/mediawiki/w/index.php(3): require(string)
#16 {main}
Impact

Low, at this point only five instances. But it looks worrying.

Notes

This from a previous version so not blocking this week's train.

Details

Request URL
https://zh.wikipedia.org/zh-sg/Delon_Thamrin

Related Objects
Search...

Event Timeline

• LarsWirzenius created this task.Apr 27 2021, 8:32 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 27 2021, 8:32 AM
• LarsWirzenius mentioned this in T278347: 1.37.0-wmf.3 deployment blockers.Apr 27 2021, 8:33 AM
• AMooney triaged this task as Medium priority.Apr 27 2021, 9:11 PM
• AMooney edited projects, added Platform Team Workboards (Clinic Duty Team); removed Platform Engineering.
• AMooney moved this task from Inbox to Later on the Platform Team Workboards (Clinic Duty Team) board.
daniel subscribed.Apr 27 2021, 9:12 PM

Another example of a similar problem, probably due to DB corruption: https://hr.wikipedia.org/wiki/Franjeva%C4%8Dki_samostan_Sv._Antuna_Padovanskog_u_Koprivnici

tstarling subscribed.Apr 28 2021, 12:01 AM

The page was created in March 2009 and was corrupted from the outset. old_text contains "DB://cluster20/0". This is the bug that was fixed by a462904fbfab892fe61eecb8ff740445ad7615d0. There is no bug number linked from the patch -- I don't think I filed any at the time, I just noticed the issue and fixed it. Searching Phabricator for cluster20/0 just shows various things hitting these rows in later years.

tstarling mentioned this in T281325: Text rows containing DB://cluster20/0, causing RevisionAccessException when the affected pages are viewed.Apr 28 2021, 12:20 AM
tstarling added a parent task: T281325: Text rows containing DB://cluster20/0, causing RevisionAccessException when the affected pages are viewed.
Krinkle moved this task from Untriaged to Older on the Wikimedia-production-error board.Apr 28 2021, 6:10 PM
Umherirrender subscribed.May 7 2021, 8:47 PM

The same blob number on zhwiki also mention under T212428#4886442, possible a duplicate

hashar subscribed.May 20 2021, 7:30 PM

There are some other in T265989. It gives us a PHP Warning: gzinflate(): data error then followed by Use findBadBlobs.php to remedy. I am guessing all three tasks have the same root cause.

hashar mentioned this in T265989: nl.wiktionary.org edits from May 2004 corrupt "PHP Warning: gzinflate(): data error" (fatal RevisionAccessException).May 20 2021, 7:31 PM
• LarsWirzenius unsubscribed.Jun 15 2021, 5:05 AM
brennen subscribed.Oct 6 2021, 6:25 PM

Still seeing in 1.38.0-wmf.2:

Error
normalized_message
[{reqId}] {exception_url}   MediaWiki\Revision\RevisionAccessException: Failed to load data blob from {address}If this problem persist, use the findBadBlobs maintenance script to investigate the issue and mark bad blobs.
exception.trace
from /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionStore.php(1184)
#0 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionStore.php(1456): MediaWiki\Revision\RevisionStore->loadSlotContent(MediaWiki\Revision\SlotRecord, NULL, NULL, NULL, integer)
#1 [internal function]: MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}(MediaWiki\Revision\SlotRecord)
#2 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/SlotRecord.php(322): call_user_func(Closure, MediaWiki\Revision\SlotRecord)
#3 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionRecord.php(164): MediaWiki\Revision\SlotRecord->getContent()
#4 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/WikiPage.php(840): MediaWiki\Revision\RevisionRecord->getContent(string, integer, NULL)
#5 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/WikiPage.php(1077): WikiPage->getContent()
#6 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/WikiPage.php(1063): WikiPage->insertRedirect()
#7 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/WikiPage.php(1148): WikiPage->getRedirectTarget()
#8 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(465): WikiPage->followRedirect()
#9 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(318): MediaWiki->initializeArticle()
#10 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(925): MediaWiki->performRequest()
#11 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(559): MediaWiki->main()
#12 /srv/mediawiki/php-1.38.0-wmf.2/index.php(53): MediaWiki->run()
#13 /srv/mediawiki/php-1.38.0-wmf.2/index.php(46): wfIndexMain()
#14 /srv/mediawiki/w/index.php(3): require(string)
#15 {main}
exception.previous.trace
from /srv/mediawiki/php-1.38.0-wmf.2/includes/Storage/SqlBlobStore.php(290)
#0 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionStore.php(1182): MediaWiki\Storage\SqlBlobStore->getBlob(string, integer)
#1 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionStore.php(1456): MediaWiki\Revision\RevisionStore->loadSlotContent(MediaWiki\Revision\SlotRecord, NULL, NULL, NULL, integer)
#2 [internal function]: MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}(MediaWiki\Revision\SlotRecord)
#3 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/SlotRecord.php(322): call_user_func(Closure, MediaWiki\Revision\SlotRecord)
#4 /srv/mediawiki/php-1.38.0-wmf.2/includes/Revision/RevisionRecord.php(164): MediaWiki\Revision\SlotRecord->getContent()
#5 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/WikiPage.php(840): MediaWiki\Revision\RevisionRecord->getContent(string, integer, NULL)
#6 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/WikiPage.php(1077): WikiPage->getContent()
#7 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/WikiPage.php(1063): WikiPage->insertRedirect()
#8 /srv/mediawiki/php-1.38.0-wmf.2/includes/page/WikiPage.php(1148): WikiPage->getRedirectTarget()
#9 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(465): WikiPage->followRedirect()
#10 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(318): MediaWiki->initializeArticle()
#11 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(925): MediaWiki->performRequest()
#12 /srv/mediawiki/php-1.38.0-wmf.2/includes/MediaWiki.php(559): MediaWiki->main()
#13 /srv/mediawiki/php-1.38.0-wmf.2/index.php(53): MediaWiki->run()
#14 /srv/mediawiki/php-1.38.0-wmf.2/index.php(46): wfIndexMain()
#15 /srv/mediawiki/w/index.php(3): require(string)
#16 {main}
Umherirrender unsubscribed.Nov 24 2021, 7:47 PM
hashar unsubscribed.Apr 20 2022, 10:19 AM
Aklapper added a project: MediaWiki-Core-Revision-backend.May 9 2022, 6:04 PM
Aklapper merged a task: T307934: MediaWiki\Revision\RevisionAccessException: Failed to load data blob from {address}.
Aklapper added a subscriber: AlexisJazz.
AlexisJazz added a comment.May 9 2022, 10:41 PM

https://nl.wiktionary.org/w/index.php?oldid=22&uselang=en
[79d39db3-ed1e-440d-b472-e0453f2bad40] 2022-05-09 22:41:06: Fatal exception of type "MediaWiki\Revision\RevisionAccessException"

Krinkle subscribed.Jul 29 2022, 9:31 PM
In T281223#7915801, @AlexisJazz wrote:

https://nl.wiktionary.org/w/index.php?oldid=22&uselang=en
[79d39db3-ed1e-440d-b472-e0453f2bad40] 2022-05-09 22:41:06: Fatal exception of type "MediaWiki\Revision\RevisionAccessException"

This is not a revision lost due to DB://cluster20/0 (parent task) but rather due to the blob being in invalid as gzip, which is tracked at T265989.

Umherirrender added a project: Wikimedia-database-issue (Bad data).Aug 5 2022, 11:43 PM
Krinkle added a project: Unstewarded-production-error.Aug 18 2023, 7:32 PM
Krinkle mentioned this in T337392: RevisionAccessException: Failed to load data blob (nowiki revision, DB://cluster20/0).Aug 24 2023, 3:16 PM
Krinkle removed a project: Platform Team Workboards (Clinic Duty Team).Aug 24 2023, 3:25 PM
matmarex mentioned this in T346290: Remove database insertion code from WikiPage::getRedirectTarget() / WikiPage::insertRedirect().Sep 13 2023, 10:34 PM
matmarex closed this task as a duplicate of T281325: Text rows containing DB://cluster20/0, causing RevisionAccessException when the affected pages are viewed.Sep 15 2023, 7:14 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits