Jump to content

Topic on Project:Support desk/Flow

Unable to Import Wikipedia Dumps

5
Dyecast (talkcontribs)

MediaWiki Version: 1.34.2

PHP: v.7.4

Database: MySQL v.8.0.20-0ubuntu0.20.04.1


Method:

php importDump.php --conf ../LocalSettings.php  --username-prefix="" enwiki-20200701-pages-articles.xml.bz2


Error:

2300 (2.36 pages/sec 2.36 revs/sec)

2400 (2.36 pages/sec 2.36 revs/sec)

2500 (2.35 pages/sec 2.35 revs/sec)

2600 (2.33 pages/sec 2.33 revs/sec)

2700 (2.31 pages/sec 2.31 revs/sec)


CannotCreateActorException from line 2323 of /var/lib/mediawiki/includes/user/User.php: Cannot create an actor for a usable name that is not an existing user: user_id=0 user_name="Იაკობ მახარაძე"

#0 /var/lib/mediawiki/includes/ActorMigration.php(303): User->getActorId()

#1 /var/lib/mediawiki/includes/Revision/RevisionStore.php(753): ActorMigration->getInsertValuesWithTempTable()

#2 /var/lib/mediawiki/includes/Revision/RevisionStore.php(552): MediaWiki\Revision\RevisionStore->insertRevisionRowOn()

#3 /var/lib/mediawiki/includes/Revision/RevisionStore.php(490): MediaWiki\Revision\RevisionStore->insertRevisionInternal()

#4 /var/lib/mediawiki/includes/libs/rdbms/database/Database.php(3967): MediaWiki\Revision\RevisionStore->MediaWiki\Revision\{closure}()

#5 /var/lib/mediawiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->doAtomicSection()

#6 /var/lib/mediawiki/includes/libs/rdbms/database/DBConnRef.php(635): Wikimedia\Rdbms\DBConnRef->__call()

#7 /var/lib/mediawiki/includes/Revision/RevisionStore.php(498): Wikimedia\Rdbms\DBConnRef->doAtomicSection()

#8 /var/lib/mediawiki/includes/Revision.php(968): MediaWiki\Revision\RevisionStore->insertRevisionOn()

#9 /var/lib/mediawiki/includes/import/ImportableOldRevisionImporter.php(129): Revision->insertOn()

#10 /var/lib/mediawiki/includes/import/WikiRevision.php(616): ImportableOldRevisionImporter->import()

#11 /var/lib/mediawiki/includes/import/WikiImporter.php(366): WikiRevision->importOldRevision()

#12 /var/lib/mediawiki/maintenance/importDump.php(209): WikiImporter->importRevision()

#13 /var/lib/mediawiki/includes/import/WikiImporter.php(501): BackupReader->handleRevision()

#14 /var/lib/mediawiki/includes/import/WikiImporter.php(941): WikiImporter->revisionCallback()

#15 /var/lib/mediawiki/includes/import/WikiImporter.php(860): WikiImporter->processRevision()

#16 /var/lib/mediawiki/includes/import/WikiImporter.php(802): WikiImporter->handleRevision()

#17 /var/lib/mediawiki/includes/import/WikiImporter.php(606): WikiImporter->handlePage()

#18 /var/lib/mediawiki/maintenance/importDump.php(359): WikiImporter->doImport()

#19 /var/lib/mediawiki/maintenance/importDump.php(292): BackupReader->importFromHandle()

#20 /var/lib/mediawiki/maintenance/importDump.php(127): BackupReader->importFromFile()

#21 /var/lib/mediawiki/maintenance/doMaintenance.php(99): BackupReader->execute()

#22 /var/lib/mediawiki/maintenance/importDump.php(364): require_once('/var/lib/mediaw...')

#23 {main}

[18a8bc8d20890d2db71b04b7] [no req]   Wikimedia\Rdbms\DBTransactionError from line 1680 of /var/lib/mediawiki/includes/libs/rdbms/loadbalancer/LoadBalancer.php: BackupReader: Commit failed on server(s) localhost: Cannot execute query from BackupReader while transaction status is ERROR

Backtrace:

#0 /var/lib/mediawiki/includes/libs/rdbms/lbfactory/LBFactory.php(208): Wikimedia\Rdbms\LoadBalancer->commitMasterChanges()

#1 /var/lib/mediawiki/includes/libs/rdbms/lbfactory/LBFactorySimple.php(134): Wikimedia\Rdbms\LBFactory->Wikimedia\Rdbms\{closure}()

#2 /var/lib/mediawiki/includes/libs/rdbms/lbfactory/LBFactory.php(210): Wikimedia\Rdbms\LBFactorySimple->forEachLB()

#3 /var/lib/mediawiki/includes/libs/rdbms/lbfactory/LBFactory.php(273): Wikimedia\Rdbms\LBFactory->forEachLBCallMethod()

#4 /var/lib/mediawiki/maintenance/doMaintenance.php(127): Wikimedia\Rdbms\LBFactory->commitMasterChanges()

#5 /var/lib/mediawiki/maintenance/importDump.php(364): require_once(string)

#6 {main}

Malyacko (talkcontribs)

Yet another issue with Georgian capitalization. See phab:T254470.

Dyecast (talkcontribs)

Is there a fix?

Dyecast (talkcontribs)

Or do you have another better way of importing these?

Dyecast (talkcontribs)

The April build, so far (3000 pages in), doesn't have this issue.