Page MenuHomePhabricator
Create Task
Maniphest T337392

RevisionAccessException: Failed to load data blob (nowiki revision, DB://cluster20/0)
Closed, ResolvedPublicPRODUCTION ERROR
Actions

Description

Error
normalized_message
[{reqId}] {exception_url}   MediaWiki\Revision\RevisionAccessException: Failed to load data blob from {address} for revision {revision}. If this problem persist, use the findBadBlobs maintenance script to investigate the issue and mark bad blobs.
exception.trace
from /srv/mediawiki/php-1.41.0-wmf.9/includes/Revision/RevisionStore.php(1192)
#0 /srv/mediawiki/php-1.41.0-wmf.9/includes/Revision/RevisionStore.php(1506): 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.41.0-wmf.9/includes/Revision/SlotRecord.php(324): call_user_func(Closure, MediaWiki\Revision\SlotRecord)
#3 /srv/mediawiki/php-1.41.0-wmf.9/includes/Revision/RevisionRecord.php(158): MediaWiki\Revision\SlotRecord->getContent()
#4 /srv/mediawiki/php-1.41.0-wmf.9/includes/page/WikiPage.php(840): MediaWiki\Revision\RevisionRecord->getContent(string, integer, NULL)
#5 /srv/mediawiki/php-1.41.0-wmf.9/includes/page/WikiPage.php(1085): WikiPage->getContent()
#6 /srv/mediawiki/php-1.41.0-wmf.9/includes/page/WikiPage.php(1071): WikiPage->insertRedirect()
#7 /srv/mediawiki/php-1.41.0-wmf.9/includes/page/WikiPage.php(1156): WikiPage->getRedirectTarget()
#8 /srv/mediawiki/php-1.41.0-wmf.9/includes/MediaWiki.php(478): WikiPage->followRedirect()
#9 /srv/mediawiki/php-1.41.0-wmf.9/includes/MediaWiki.php(332): MediaWiki->initializeArticle()
#10 /srv/mediawiki/php-1.41.0-wmf.9/includes/MediaWiki.php(925): MediaWiki->performRequest()
#11 /srv/mediawiki/php-1.41.0-wmf.9/includes/MediaWiki.php(579): MediaWiki->main()
#12 /srv/mediawiki/php-1.41.0-wmf.9/index.php(50): MediaWiki->run()
#13 /srv/mediawiki/php-1.41.0-wmf.9/index.php(46): wfIndexMain()
#14 /srv/mediawiki/w/index.php(3): require(string)
#15 {main}
exception.previous.trace
from /srv/mediawiki/php-1.41.0-wmf.9/includes/Storage/SqlBlobStore.php(281)
#0 /srv/mediawiki/php-1.41.0-wmf.9/includes/Revision/RevisionStore.php(1188): MediaWiki\Storage\SqlBlobStore->getBlob(string, integer)
#1 /srv/mediawiki/php-1.41.0-wmf.9/includes/Revision/RevisionStore.php(1506): 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.41.0-wmf.9/includes/Revision/SlotRecord.php(324): call_user_func(Closure, MediaWiki\Revision\SlotRecord)
#4 /srv/mediawiki/php-1.41.0-wmf.9/includes/Revision/RevisionRecord.php(158): MediaWiki\Revision\SlotRecord->getContent()
#5 /srv/mediawiki/php-1.41.0-wmf.9/includes/page/WikiPage.php(840): MediaWiki\Revision\RevisionRecord->getContent(string, integer, NULL)
#6 /srv/mediawiki/php-1.41.0-wmf.9/includes/page/WikiPage.php(1085): WikiPage->getContent()
#7 /srv/mediawiki/php-1.41.0-wmf.9/includes/page/WikiPage.php(1071): WikiPage->insertRedirect()
#8 /srv/mediawiki/php-1.41.0-wmf.9/includes/page/WikiPage.php(1156): WikiPage->getRedirectTarget()
#9 /srv/mediawiki/php-1.41.0-wmf.9/includes/MediaWiki.php(478): WikiPage->followRedirect()
#10 /srv/mediawiki/php-1.41.0-wmf.9/includes/MediaWiki.php(332): MediaWiki->initializeArticle()
#11 /srv/mediawiki/php-1.41.0-wmf.9/includes/MediaWiki.php(925): MediaWiki->performRequest()
#12 /srv/mediawiki/php-1.41.0-wmf.9/includes/MediaWiki.php(579): MediaWiki->main()
#13 /srv/mediawiki/php-1.41.0-wmf.9/index.php(50): MediaWiki->run()
#14 /srv/mediawiki/php-1.41.0-wmf.9/index.php(46): wfIndexMain()
#15 /srv/mediawiki/w/index.php(3): require(string)
#16 {main}
Impact
Notes
  • > 500 in the last 30m

Details

Request URL
https://no.wikipedia.org/wiki/Bergen_klatreklubb

Related Objects
Search...

Event Timeline

TheresNoTime created this task.May 24 2023, 12:52 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 24 2023, 12:52 PM
Stashbot added a comment.May 24 2023, 12:55 PM

Mentioned in SAL (#wikimedia-operations) [2023-05-24T12:55:51Z] <TheresNoTime> [samtar@mwmaint1002 ~]$ mwscript findBadBlobs --wiki nowiki --revisions 5227369 --mark T337392 T337392

Umherirrender added a project: Wikimedia-database-issue (Bad data).May 25 2023, 7:03 PM
Krinkle subscribed.Aug 24 2023, 3:16 PM

The underlying revision points to ExternalStore cluster20, same as T281223.

wikiadmin2023@(nowiki)> SELECT * FROM slots WHERE slot_revision_id =5227369;
+------------------+--------------+-----------------+-------------+
| slot_revision_id | slot_role_id | slot_content_id | slot_origin |
+------------------+--------------+-----------------+-------------+
|          5227369 |            1 |         4918340 |     5227369 |
+------------------+--------------+-----------------+-------------+
1 row in set (0.002 sec)

wikiadmin2023@10.64.48.70(nowiki)> SELECT * FROM content WHERE content_id=4918340;
+------------+--------------+--------------+---------------+-----------------------------------------------------------------------------------------------------+
| content_id | content_size | content_sha1 | content_model | content_address                                                                                     |
+------------+--------------+--------------+---------------+-----------------------------------------------------------------------------------------------------+
|    4918340 |           32 |              |             1 | bad:tt%3A5190542?reason=T337392&error=Bad+data+in+text+row+5190542.+Use+findBadBlobs.php+to+remedy. |
+------------+--------------+--------------+---------------+-----------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)

wikiadmin2023@10.64.48.70(nowiki)> SELECT * FROM text WHERE old_id=5190542;
+---------+------------------+---------------------+
| old_id  | old_text         | old_flags           |
+---------+------------------+---------------------+
| 5190542 | DB://cluster20/0 | utf-8,gzip,external |
+---------+------------------+---------------------+
Krinkle added a parent task: T281325: Text rows containing DB://cluster20/0, causing RevisionAccessException when the affected pages are viewed.Aug 24 2023, 3:16 PM
Krinkle renamed this task from MediaWiki\Revision\RevisionAccessException: Failed to load data blob from {address} for revision {revision}. If this problem persist, use the findBadBlobs maintenance script to investigate the issue and mark bad blobs. to RevisionAccessException: Failed to load data blob (nowiki revision, DB://cluster20/0).Aug 24 2023, 3:23 PM
Krinkle closed this task as Resolved.
Krinkle claimed this task.
Krinkle moved this task from Untriaged to May 2023 on the Wikimedia-production-error board.
Krinkle added a project: MediaWiki-Core-Revision-backend.
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