Page MenuHomePhabricator

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.
Open, MediumPublicPRODUCTION ERROR

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

Event Timeline

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.

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

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.

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}

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"