Page MenuHomePhabricator
Paste P4470

ALTER TABLE page
ActivePublic
Actions

Authored by jcrespo on Nov 18 2016, 8:57 AM.
Tags
None
Referenced Files
F4739457: ALTER TABLE page
Nov 18 2016, 8:57 AM
Subscribers
None
root@neodymium:~$ while read host port; do echo $host $port; while read db; do yes | ./software/dbtools/osc_host.sh --host=$host --port=$port --db=$d
b --table=page --method=ddl --no-replicate "ADD COLUMN page_lang varbinary(35) DEFAULT NULL"; done < s4.dblist; done < s4.hosts
dbstore2002.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 1150905
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.28-MariaDB MariaDB Server
Protocol version: 10
Connection: dbstore2002.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 9 days 4 hours 14 min 13 sec
Threads: 6 Questions: 424338181 Slow queries: 1 Opens: 1269445 Flush tables: 1 Open tables: 50000 Queries per second avg: 535.204
--------------
Host : dbstore2002.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off
pt args : --recurse=0 --set-vars=sql_log_bin=off
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: dbstore2002.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
dbstore2001.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 393399
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.28-MariaDB MariaDB Server
Protocol version: 10
Connection: dbstore2001.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 3 days 5 hours 52 min 57 sec
Threads: 4 Questions: 209544408 Slow queries: 2 Opens: 21037 Flush tables: 1 Open tables: 20812 Queries per second avg: 747.366
--------------
Host : dbstore2001.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off
pt args : --recurse=0 --set-vars=sql_log_bin=off
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: dbstore2002.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary
(35) DEFAULT NULL
dbstore2001.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 393399
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.28-MariaDB MariaDB Server
Protocol version: 10
Connection: dbstore2001.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 3 days 5 hours 52 min 57 sec
Threads: 4 Questions: 209544408 Slow queries: 2 Opens: 21037 Flush tables: 1 Open tables: 20812 Queries per second avg: 747.366
--------------
Host : dbstore2001.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off
pt args : --recurse=0 --set-vars=sql_log_bin=off
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: dbstore2002.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary
(35) DEFAULT NULL
host: dbstore2002.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary
(35) DEFAULT NULL
dbstore2001.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 393399
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.28-MariaDB MariaDB Server
Protocol version: 10
Connection: dbstore2001.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 3 days 5 hours 52 min 57 sec
Threads: 4 Questions: 209544408 Slow queries: 2 Opens: 21037 Flush tables: 1 Open tables: 20812 Queries per second avg: 747.366
--------------
Host : dbstore2001.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off
pt args : --recurse=0 --set-vars=sql_log_bin=off
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: dbstore2001.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
ERROR 1062 (23000) at line 1: Duplicate entry '14-TEP70_locomotives_of_Ukraine' for key 'name_title'
WARNING commonswiki : page encountered problems
db2065.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 139751369
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db2065.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 286 days 2 hours 43 min 58 sec
Threads: 4 Questions: 6301743325 Slow queries: 89 Opens: 740 Flush tables: 1 Open tables: 702 Queries per second avg: 254.922
--------------
Host : db2065.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2065.codfw.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2065.codfw.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db2065.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
ERROR 1062 (23000) at line 1: Duplicate entry '53249753' for key 'PRIMARY'
WARNING commonswiki : page encountered problems
db2058.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 52286488
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db2058.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 286 days 3 hours 43 min 14 sec
Threads: 6 Questions: 4533408382 Slow queries: 37 Opens: 533 Flush tables: 1 Open tables: 528 Queries per second avg: 183.362
--------------
Host : db2058.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2058.codfw.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2058.codfw.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db2058.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
ERROR 1062 (23000) at line 1: Duplicate entry '53250362' for key 'PRIMARY'
WARNING commonswiki : page encountered problems
db2051.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 89066123
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db2051.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 286 days 5 hours 22 min 18 sec
Threads: 4 Questions: 4870864218 Slow queries: 283 Opens: 538 Flush tables: 1 Open tables: 510 Queries per second avg: 196.963
--------------
Host : db2051.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2051.codfw.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2051.codfw.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db2051.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
db2044.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 29352279
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db2044.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 286 days 6 hours 22 min 39 sec
Threads: 5 Questions: 3982386105 Slow queries: 293 Opens: 531 Flush tables: 1 Open tables: 554 Queries per second avg: 161.012
--------------
Host : db2044.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2044.codfw.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2044.codfw.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db2044.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
db2037.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 29656210
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db2037.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 287 days 2 hours 47 min 54 sec
Threads: 5 Questions: 3998279045 Slow queries: 304 Opens: 452 Flush tables: 1 Open tables: 475 Queries per second avg: 161.176
--------------
Host : db2037.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2037.codfw.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2037.codfw.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db2037.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
db2019.codfw.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 11098170
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db2019.codfw.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 216 days 11 hours 10 min 58 sec
Threads: 14 Questions: 2613961132 Slow queries: 28 Opens: 484 Flush tables: 1 Open tables: 485 Queries per second avg: 139.764
--------------
Host : db2019.codfw.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2019.codfw.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db2019.codfw.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db2019.codfw.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
dbstore1001.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 13224146
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB MariaDB Server
Protocol version: 10
Connection: dbstore1001.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 148 days 4 hours 43 min 44 sec
Threads: 5 Questions: 14733630677 Slow queries: 25083 Opens: 1535777 Flush tables: 1 Open tables: 50000 Queries per second avg: 1150.685
--------------
Host : dbstore1001.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off
pt args : --recurse=0 --set-vars=sql_log_bin=off
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: dbstore1001.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
dbstore1002.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 656141934
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB MariaDB Server
Protocol version: 10
Connection: dbstore1002.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 119 days 5 hours 14 min 37 sec
Threads: 7 Questions: 14017495864 Slow queries: 210515 Opens: 256227 Flush tables: 1 Open tables: 49999 Queries per second avg: 1360.858
--------------
Host : dbstore1002.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off
pt args : --recurse=0 --set-vars=sql_log_bin=off
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: dbstore1002.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
labsdb1001.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 1820599
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.15-MariaDB Source distribution
Protocol version: 10
Connection: labsdb1001.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 1 day 5 hours 26 min 59 sec
Threads: 48 Questions: 170486009 Slow queries: 11360 Opens: 249801 Flush tables: 1 Open tables: 9985 Queries per second avg: 1608.070
--------------
Host : labsdb1001.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off
pt args : --recurse=0 --set-vars=sql_log_bin=off
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: labsdb1001.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
ERROR 1205 (HY000) at line 1: Lock wait timeout exceeded; try restarting transaction
WARNING commonswiki : page encountered problems
labsdb1003.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 222986
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB MariaDB Server
Protocol version: 10
Connection: labsdb1003.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 5 hours 26 min 44 sec
Threads: 46 Questions: 24732411 Slow queries: 1932 Opens: 120467 Flush tables: 1 Open tables: 10000 Queries per second avg: 1261.600
--------------
Host : labsdb1003.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off
pt args : --recurse=0 --set-vars=sql_log_bin=off
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: labsdb1003.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
db1069.eqiad.wmnet 3314
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 264072
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db1069.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3314
Uptime: 15 days 3 hours 46 min 31 sec
Threads: 6 Questions: 304288514 Slow queries: 0 Opens: 181 Flush tables: 1 Open tables: 168 Queries per second avg: 232.353
--------------
Host : db1069.eqiad.wmnet
Port : 3314
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1069.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1069.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1069.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
db1053.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 293088424
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.27-MariaDB MariaDB Server
Protocol version: 10
Connection: db1053.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 30 days 50 min 22 sec
Threads: 10 Questions: 1991321200 Slow queries: 7623 Opens: 949 Flush tables: 1 Open tables: 807 Queries per second avg: 767.361
--------------
Host : db1053.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1053.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1053.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1053.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
db1056.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 1499077500
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.22-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db1056.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 176 days 6 hours 1 min 24 sec
Threads: 13 Questions: 14833826040 Slow queries: 52638 Opens: 2750 Flush tables: 1 Open tables: 2508 Queries per second avg: 974.109
--------------
Host : db1056.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1056.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1056.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1056.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
ERROR 1062 (23000) at line 1: Duplicate entry '53255065' for key 'PRIMARY'
WARNING commonswiki : page encountered problems
db1059.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 1322233603
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.23-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db1059.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 146 days 22 hours 28 min 31 sec
Threads: 6 Questions: 9903020734 Slow queries: 13670 Opens: 1124 Flush tables: 1 Open tables: 914 Queries per second avg: 780.053
--------------
Host : db1059.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1059.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1059.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1059.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
ERROR 1062 (23000) at line 1: Duplicate entry '53257028' for key 'PRIMARY'
WARNING commonswiki : page encountered problems
db1064.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 99606920
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.23-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db1064.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 30 days 2 hours 40 min 36 sec
Threads: 4 Questions: 1688701001 Slow queries: 6536 Opens: 223 Flush tables: 1 Open tables: 275 Queries per second avg: 649.091
--------------
Host : db1064.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1064.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1064.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1064.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
db1068.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 2981825804
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.23-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db1068.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 149 days 10 hours 4 min 30 sec
Threads: 11 Questions: 24045903485 Slow queries: 26177 Opens: 1928 Flush tables: 1 Open tables: 1710 Queries per second avg: 1862.598
--------------
Host : db1068.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1068.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1068.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1068.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
db1081.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 2875502331
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.23-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db1081.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 156 days 8 hours 28 min 10 sec
Threads: 128 Questions: 119898499993 Slow queries: 71080 Opens: 1831 Flush tables: 1 Open tables: 1801 Queries per second avg: 8875.525
--------------
Host : db1081.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1081.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1081.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1081.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
db1084.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 2911870556
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.23-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db1084.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 156 days 11 hours 30 min 39 sec
Threads: 158 Questions: 120894748466 Slow queries: 89538 Opens: 1784 Flush tables: 1 Open tables: 1748 Queries per second avg: 8942.025
--------------
Host : db1084.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1084.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1084.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1084.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
ERROR 1205 (HY000) at line 1: Lock wait timeout exceeded; try restarting transaction
WARNING commonswiki : page encountered problems
db1091.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 2915490854
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.23-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db1091.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 156 days 10 hours 31 min 30 sec
Threads: 211 Questions: 120768912520 Slow queries: 60822 Opens: 1677 Flush tables: 1 Open tables: 1655 Queries per second avg: 8935.063
--------------
Host : db1091.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1091.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1091.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1091.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
ERROR 1205 (HY000) at line 1: Lock wait timeout exceeded; try restarting transaction
WARNING commonswiki : page encountered problems
db1040.eqiad.wmnet 3306
--------------
mysql Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 313256157
Current database:
Current user: root@10.64.32.20
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.5-10.0.23-MariaDB-log MariaDB Server
Protocol version: 10
Connection: db1040.eqiad.wmnet via TCP/IP
Server characterset: binary
Db characterset: binary
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3306
Uptime: 156 days 12 hours 33 min 56 sec
Threads: 217 Questions: 15605950078 Slow queries: 44338 Opens: 1428 Flush tables: 1 Open tables: 1331 Queries per second avg: 1153.975
--------------
Host : db1040.eqiad.wmnet
Port : 3306
Databases : commonswiki
Table : page
Alter : ADD COLUMN page_lang varbinary(35) DEFAULT NULL
method : ddl
pt dry args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1040.eqiad.wmnet
pt args : --recurse=0 --set-vars=sql_log_bin=off --check-slave-lag=db1040.eqiad.wmnet
ddl args : SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0;
analyze : 0
host: db1040.eqiad.wmnet, database: commonswiki
SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=60; set session sql_log_bin=0; alter table page ADD COLUMN page_lang varbinary(35) DEFAULT NULL
ERROR 1062 (23000) at line 1: Duplicate entry '53260621' for key 'PRIMARY'
WARNING commonswiki : page encountered problems
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL