제타위키 미디어위키 업그레이드 1.32 → 1.33

1 개요

제타위키 미디어위키 업그레이드 1.32 → 1.33

제타위키 미디어위키 업그레이드 1.32.3 → 1.33.0

• 사전 DB백업 필수 ★★★

2 확인

• 미디어위키 버전 확인

root@localhost:/var/www/html# ls RELEASE-NOTES-*
RELEASE-NOTES-1.33

• LocalSettings.php 확인 ( 미디어위키 1.33 LocalSettings.php 샘플 참고 )

root@localhost:/var/www/html# cat LocalSettings.php | grep wgDB
$wgDBtype = "mysql";
$wgDBserver = "testdb";
$wgDBname = "my_wiki";
$wgDBuser = "root";
$wgDBpassword = "P@ssw0rd";
$wgDBprefix = "";
$wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=binary";

3 DB스키마 업그레이드

MediaWiki 1.33.0 Updater 로그 문서를 참고하십시오.

root@localhost:/var/www/html# php maintenance/update.php 
MediaWiki 1.33.0 Updater

Your composer.lock file is up to date with current dependencies!
Going to run database updates for my_wiki
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick) ...
... (생략)
... rev_id=534620
... rev_id=534720
... rev_id=534778
Completed migration, updated 509013 row(s) with 1532 new actor(s), 4044 error(s)
Beginning migration of archive.ar_user and archive.ar_user_text to archive.ar_actor
... ar_id=100
... ar_id=200
... ar_id=300
... ar_id=400
... ar_id=500
... ar_id=600
... ar_id=720
... ar_id=857
User name "UseModWiki Importer" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

... ar_id=1009
... ar_id=1109
... ar_id=1210
... ar_id=1310
... ar_id=1441
... ar_id=1580
... ar_id=1719
... ar_id=1851
... ar_id=1951
... ar_id=2051
User name "Krinkle" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

... ar_id=2409
User name "MSGJ" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

... ar_id=2555
... ar_id=2697
... ar_id=2856
... ar_id=2978
... ar_id=3081
... ar_id=3186
... ar_id=3296
... ar_id=3439
... ar_id=3571
[8d17137f563bdccd4f30535b] [no req]   Wikimedia\Rdbms\DBQueryError from line 1587 of /var/www/html/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: INSERT  INTO `actor` (actor_name) VALUES ('113.57.92.46'),('93.57.91.35'),('testuser'),('224.68.103.57')
Function: MigrateActors::addActorsForRows
Error: 1062 Duplicate entry 'testuser' for key 'actor_name' (testdb)

Backtrace:
#0 /var/www/html/includes/libs/rdbms/database/Database.php(1556): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#1 /var/www/html/includes/libs/rdbms/database/Database.php(1274): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /var/www/html/includes/libs/rdbms/database/Database.php(2149): Wikimedia\Rdbms\Database->query(string, string)
#3 /var/www/html/maintenance/includes/MigrateActors.php(226): Wikimedia\Rdbms\Database->insert(string, array, string)
#4 /var/www/html/maintenance/includes/MigrateActors.php(306): MigrateActors->addActorsForRows(Wikimedia\Rdbms\DatabaseMysqli, string, array, array, integer)
#5 /var/www/html/maintenance/includes/MigrateActors.php(114): MigrateActors->migrate(string, array, string, string, string)
#6 /var/www/html/maintenance/Maintenance.php(1719): MigrateActors->doDBUpdates()
#7 /var/www/html/includes/installer/DatabaseUpdater.php(1318): LoggedUpdateMaintenance->execute()
#8 /var/www/html/includes/installer/DatabaseUpdater.php(489): DatabaseUpdater->migrateActors()
#9 /var/www/html/includes/installer/DatabaseUpdater.php(453): DatabaseUpdater->runUpdates(array, boolean)
#10 /var/www/html/maintenance/update.php(203): DatabaseUpdater->doUpdates(array)
#11 /var/www/html/maintenance/doMaintenance.php(96): UpdateMediaWiki->execute()
#12 /var/www/html/maintenance/update.php(266): require_once(string)
#13 {main}

4 (Optional) 트러블슈팅

• User name "John" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.
• Error: 1062 Duplicate entry 'testuser' for key 'actor_name'

5 같이 보기

• MediaWiki 1.33.0 Updater 로그
• 제타위키 미디어위키 업그레이드 1.31 → 1.32