Page MenuHomePhabricator
Paste P12749

s1 table schema comparison
ActivePublic

Authored by ArielGlenn on Sep 23 2020, 9:17 AM.
Tags
None
Referenced Files
F32360653: s1 table schema comparison
Sep 23 2020, 9:17 AM
Subscribers
None
I have looked at the db schema for the following tables:
page,revision,comment,actor,slot,content,user,text,revision_comment_temp,revision_actor_temp,recentchanges,watchlist
Presumably that is good enough :-)
I ran my checker on both eqiad and codfw:
python3 check_table_structures.py.new --sections s1 --tables page,revision,comment,actor,slot,content,user,text,revision_comment_temp,revision_actor_temp,recentchanges,watchlist --sett
ings {eqiad or codfw}.conf --verbose
The following settings are (mostly) ignored in the diff: AUTO_INCREMENT,DEFAULT,ROW_FORMAT,AVG_ROW_LENGTH
All diffs are against the master for s1 in either dc. Mariadb versions are printed out first in case those turn out to be relevant.
eqiad:
dbhost: db1084 version: 10.4.13-MariaDB-log
dbhost: db1106 version: 10.1.43-MariaDB
dbhost: db1118 version: 10.4.14-MariaDB-log
dbhost: db1119 version: 10.4.13-MariaDB-log
dbhost: db1083 version: 10.1.43-MariaDB
dbhost: db1135 version: 10.4.14-MariaDB-log
dbhost: db1099:3311 version: 10.4.13-MariaDB-log
dbhost: db1134 version: 10.1.44-MariaDB
dbhost: db1105:3311 version: 10.4.12-MariaDB-log
dbhost: db1091 version: 10.4.14-MariaDB-log
dbhost: db1089 version: 10.1.43-MariaDB
master: db1083
wiki: enwiki
DIFFS ****
common results for hosts: ['db1091', 'db1105:3311', 'db1084', 'db1135']
repl table comment column comment_data mismatch blob DEFAULT NULL
common results for hosts: ['db1083', 'db1089', 'db1134']
common results for hosts: ['db1099:3311']
table user has parameters KEY_BLOCK_SIZE extra on replica db1099:3311 wiki enwiki
table revision has parameters KEY_BLOCK_SIZE extra on replica db1099:3311 wiki enwiki
repl table comment column comment_data mismatch blob DEFAULT NULL
table recentchanges has parameters KEY_BLOCK_SIZE extra on replica db1099:3311 wiki enwiki
table text has parameters KEY_BLOCK_SIZE extra on replica db1099:3311 wiki enwiki
table page has parameters KEY_BLOCK_SIZE extra on replica db1099:3311 wiki enwiki
table watchlist has parameters KEY_BLOCK_SIZE extra on replica db1099:3311 wiki enwiki
common results for hosts: ['db1106']
common results for hosts: ['db1119']
repl table comment column comment_data mismatch blob DEFAULT NULL
common results for hosts: ['db1118']
repl table comment column comment_data mismatch blob DEFAULT NULL
--------
codfw:
dbhost: db2088:3311 version: 10.4.13-MariaDB-log
dbhost: db2116 version: 10.4.13-MariaDB-log
dbhost: db2085:3311 version: 10.4.12-MariaDB-log
dbhost: db2072 version: 10.1.43-MariaDB
dbhost: db2130 version: 10.4.13-MariaDB-log
dbhost: db2071 version: 10.4.13-MariaDB-log
dbhost: db2103 version: 10.1.43-MariaDB
dbhost: db2112 version: 10.1.43-MariaDB
dbhost: db2092 version: 10.4.13-MariaDB-log
master: db2112
wiki: enwiki
DIFFS ****
common results for hosts: ['db2112', 'db2072', 'db2103']
common results for hosts: ['db2088:3311', 'db2130', 'db2085:3311', 'db2116', 'db2071']
repl table comment column comment_data mismatch blob DEFAULT NULL
common results for hosts: ['db2092']
table user has master parameters KEY_BLOCK_SIZE missing on replica db2092 wiki enwiki
table watchlist has master parameters KEY_BLOCK_SIZE missing on replica db2092 wiki enwiki
table text has master parameters KEY_BLOCK_SIZE missing on replica db2092 wiki enwiki
repl table comment column comment_data mismatch blob DEFAULT NULL
table page has master parameters KEY_BLOCK_SIZE missing on replica db2092 wiki enwiki
table recentchanges has master parameters KEY_BLOCK_SIZE missing on replica db2092 wiki enwiki
table revision has master parameters KEY_BLOCK_SIZE missing on replica db2092 wiki enwiki