Steps to reproduce:
- Take an XML generated using dumpBackup.php
- Import the XML dump using importDump.php --no-updates
- Run rebuildall.php
(This doesn't always happen but sometimes it does)
MW Version: 1.37.1 (c3cf978)
PHP: 7.3.31-1~deb10u1 (fpm-fcgi)
MariaDB: 10.4.21-MariaDB-1:10.4.21+maria~buster-log
Error
Wikimedia\Rdbms\DBQueryError from line 1809 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: Error 1406: Data too long for column 'si_title' at row 1 (db13)
Function: SearchMySQL::update
Query: REPLACE INTO `searchindex` (si_page,si_title,si_text) VALUES ('4270','u8e38090u8e382a4u8e382b1u8e3839cu8e381a7u8e383a9u8e38383u8e38397u8efbda4u8e5928cu8e6a5bdu8e599a8u8e38182u8e3828au8e38091u8e5889du8e99fb3u8e3839fu8e382af kaitou8e3808eu8e5a4a7u8e6b19fu8e688b8u8e382b8u8e383a5u8e383aau8e382a2u8e3838au8e382a4u8e38388u8e3808fmv',' description description description mitchie mu8e381a7u8e38199u8e38082u8e382a4u8e382b1u8e3839cu8e381aakaitou8e381aeu8e8aabfu8e5a3b0u8e381abu8e68c91u8e688a6u8e38197u8e3819fu8e5889du8e99fb3u8e3839fu8e382afu8e381a8u8e381aeu8e38387u8e383a5u8e382a8u8e38383u8e38388u8e69bb2u8e38292u8e4bd9cu8e3828au8e381beu8e38197u8e3819fu8e38082u8e6b19fu8e688b8u8e69982u8e4bba3u8e58583u8e7a684u8e38390u8e38396u8e383abu8e69c9fu8e38292u8e8889eu8e58fb0u8e381abu8e38081u8e5b9b3u8e68890u8e38390u8e38396u8e383abu8e381aeu8e8b1a1u8e5beb4u8e3808eu8e382b8u8e383a5u8e383aau8e382a2u8e3838au8e69db1u8e4baacu8e3808fu8e38292u8e8a1a8u8e78fbeu8e38197u8e3819fu8e38380u8e383b3u8e382b9u8e38381u8e383a5u8e383bcu8e383b3u8e381a7u8e38199u8e38082u8e296b6u8efb88e u8e5898du8e4bd9c u8e29786u8e58b95u8e794bbu8e4b8adu8e381aeu8e3838du8e382bfu8e381aeu8e8a7a3u8e8aaacu8e8a898u8e4ba8bu8e38292u8e69bb8u8e3818du8e381beu8e38197u8e3819fu8e38082 u8e28792 u8e29786 u8e382a4u8e383b3u8e382b9u8e38388u8e99fb3u8e6ba90u8e9858du8e5b883 u8e28792 u8e29786 u8e382abu8e383a9u8e382aau8e382b1u8e99fb3u8e6ba90u8e9858du8e5b883 u8e28792 u8e29786 u8e6ad8cu8e8a99eu8e38386u8e382adu8e382b9u8e38388 u8e28792 u8e99fb3u8e6a5bdu8efbc9amitchie mu800 u8e28792 u8e7b5b5u8efbc9au8e7ab9cu8e5aeaeu8e38384u8e382abu8e382b5 u8e28792 u8e58b95u8e794bbu8efbc9anot-116u800 u8e28792 u8e29786 u8e38193u8e381aeu8e69bb2u8e381afu8e5889du8e99fb3u8e3839fu8e382af10u8e591a8u8e5b9b4u8e8a898u8e5bfb5u8e382a2u8e383abu8e38390u8e383a0u8e3808ere startu8e3808fu8e381abu8e58f8eu8e98cb2u8e38195u8e3828cu8e381a6u8e381beu8e38199u8e38082 u8e28792 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - mitchie mu800 u8e38090official siteu8e38091 u8e38090twitteru8e38091 u8e38090facebooku8e38091 u8e38090google u8e38091 u8e38090soundcloudu8e38091 category videos ')
#0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1793): Wikimedia\Rdbms\Database->getQueryException('Data too long f...', 1406, 'REPLACE INTO `s...', 'SearchMySQL::up...')
#1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1768): Wikimedia\Rdbms\Database->getQueryExceptionAndLog('Data too long f...', 1406, 'REPLACE INTO `s...', 'SearchMySQL::up...')
#2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1327): Wikimedia\Rdbms\Database->reportQueryError('Data too long f...', 1406, 'REPLACE INTO `s...', 'SearchMySQL::up...', false)
#3 /srv/mediawiki/w/includes/libs/rdbms/database/DatabaseMysqlBase.php(1210): Wikimedia\Rdbms\Database->query('REPLACE INTO `s...', 'SearchMySQL::up...', 128)
#4 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(3459): Wikimedia\Rdbms\DatabaseMysqlBase->doReplace('searchindex', Array, Array, 'SearchMySQL::up...')
#5 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->replace('searchindex', 'si_page', Array, 'SearchMySQL::up...')
#6 /srv/mediawiki/w/includes/libs/rdbms/database/DBConnRef.php(513): Wikimedia\Rdbms\DBConnRef->__call('replace', Array)
#7 /srv/mediawiki/w/includes/search/SearchMySQL.php(357): Wikimedia\Rdbms\DBConnRef->replace('searchindex', 'si_page', Array, 'SearchMySQL::up...')
#8 /srv/mediawiki/w/includes/deferred/SearchUpdate.php(101): SearchMySQL->update('4270', 'u8e38090u8e382a...', ' description de...')
#9 /srv/mediawiki/w/maintenance/rebuildtextindex.php(120): SearchUpdate->doUpdate()
#10 /srv/mediawiki/w/maintenance/rebuildtextindex.php(68): RebuildTextIndex->populateSearchIndex()
#11 /srv/mediawiki/w/maintenance/rebuildall.php(48): RebuildTextIndex->execute()
#12 /srv/mediawiki/w/maintenance/doMaintenance.php(108): RebuildAll->execute()
#13 /srv/mediawiki/w/maintenance/rebuildall.php(67): require_once('/srv/mediawiki/...')
#14 {main}