MCR schema migration stage 0: create tables
https://www.mediawiki.org/wiki/Multi-Content_Revisions/Content_Meta-Data#Phase_0:_Create_new_tables
https://www.mediawiki.org/wiki/Multi-Content_Revisions/Schema_Migration
Description
Description
Details
Details
| Project | Branch | Lines +/- | Subject | |
|---|---|---|---|---|
| mediawiki/core | master | +129 -129 | Correct recent schema changes for MSSQL, Oracle |
| Status | Subtype | Assigned | Task | |
|---|---|---|---|---|
| · · · | ||||
| Resolved | Anomie | T183489 MCR schema migration stage 1: Fix Legacy Archive Rows | ||
| Resolved | Anomie | T183486 MCR schema migration stage 0: create tables | ||
| · · · |
Event Timeline
Comment Actions
Change 378724 had a related patch set uploaded (by Daniel Kinzler; owner: Daniel Kinzler):
[mediawiki/core@master] MCR database schema
Comment Actions
DBA: Since creating tables isn't classified as a schema change actually needing DBA intervention, do you have any objection to me creating the four tables shown in the diff at https://gerrit.wikimedia.org/r/#/c/378724/35/maintenance/tables.sql on all wikis? Or, if you'd rather do it yourselves, feel free.
Comment Actions
Mentioned in SAL (#wikimedia-operations) [2018-01-09T15:07:14Z] <anomie> Creating MCR tables on all wikis (T183486)
Comment Actions
Re-opening: the tables where dropped again per T190153, and SAL does not indicate that they have been re-created since.
Comment Actions
Did you check if they are there? Because I can see them, maybe @Anomie forgot to !log them - so not sure if we are looking at the same thing:
for i in `cat /home/marostegui/git/mediawiki-config/dblists/s1.dblist `; do echo "===$i==="; mysql.py -hdb1052 $i -e "show tables like 'slots'" -BN;done ===enwiki=== slots for i in `cat /home/marostegui/git/mediawiki-config/dblists/s2.dblist `; do echo "===$i==="; mysql.py -hdb1066 $i -e "show tables like 'slots'" -BN;done ===bgwiki=== slots ===bgwiktionary=== slots ===cswiki=== slots ===enwikiquote=== slots ===enwiktionary=== slots ===eowiki=== slots ===fiwiki=== slots ===idwiki=== slots ===itwiki=== slots ===nlwiki=== slots ===nowiki=== slots ===plwiki=== slots ===ptwiki=== slots ===svwiki=== slots ===thwiki=== slots ===trwiki=== slots ===zhwiki=== slots for i in `cat /home/marostegui/git/mediawiki-config/dblists/s3.dblist `; do echo "===$i==="; mysql.py -hdb1075 $i -e "show tables like 'slots'" -BN;done ===aawiki=== slots ===aawikibooks=== slots ===aawiktionary=== slots ===abwiki=== slots ===abwiktionary=== slots ===acewiki=== slots ===advisorywiki=== <snip> for i in `cat /home/marostegui/git/mediawiki-config/dblists/s4.dblist `; do echo "===$i==="; mysql.py -hdb1068 $i -e "show tables like 'slots'" -BN;done ===commonswiki=== slots for i in `cat /home/marostegui/git/mediawiki-config/dblists/s5.dblist `; do echo "===$i==="; mysql.py -hdb1070 $i -e "show tables like 'slots'" -BN;done ===dewiki=== slots for i in `cat /home/marostegui/git/mediawiki-config/dblists/s6.dblist `; do echo "===$i==="; mysql.py -hdb1061 $i -e "show tables like 'slots'" -BN;done ===frwiki=== slots ===jawiki=== slots ===ruwiki=== slots for i in `cat /home/marostegui/git/mediawiki-config/dblists/s7.dblist `; do echo "===$i==="; mysql.py -hdb1062 $i -e "show tables like 'slots'" -BN;done ===arwiki=== slots ===cawiki=== slots ===eswiki=== slots ===fawiki=== slots ===frwiktionary=== slots ===hewiki=== slots ===huwiki=== slots ===kowiki=== slots ===metawiki=== slots ===rowiki=== slots ===ukwiki=== slots ===viwiki=== slots for i in `cat /home/marostegui/git/mediawiki-config/dblists/s8.dblist `; do echo "===$i==="; mysql.py -hdb1071 $i -e "show tables like 'slots'" -BN;done ===wikidatawiki=== slots
Comment Actions
Seems like i mistyped when checking the log or something. It's there https://tools.wmflabs.org/sal/log/AWLjRFZ_CdtJF089CawE. Closing again, sorry for the confusion.
Comment Actions
Change 419270 had a related patch set uploaded (by Daniel Kinzler; owner: Anomie):
[mediawiki/core@master] Correct recent schema changes for MSSQL, Oracle
Comment Actions
Change 419270 merged by jenkins-bot:
[mediawiki/core@master] Correct recent schema changes for MSSQL, Oracle