Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F32360653
s1 table schema comparison
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
ArielGlenn
Sep 23 2020, 9:17 AM
2020-09-23 09:17:17 (UTC+0)
Size
3 KB
Referenced Files
None
Subscribers
None
s1 table schema comparison
View Options
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
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
8574677
Default Alt Text
s1 table schema comparison (3 KB)
Attached To
Mode
P12749 s1 table schema comparison
Attached
Detach File
Event Timeline
Log In to Comment