T141951 Add local_user_id and global_user_id fields to localuser table in centralauth database (original) (raw)

Comment Actions

Hello,

db1039 looks good, and so does error log, so I am going to proceed and execute the ALTER in the following servers (one by one):

dbstore2001.codfw.wmnet - done dbstore2002.codfw.wmnet - done db2040.codfw.wmnet - done db2047.codfw.wmnet - done db2054.codfw.wmnet - done db2061.codfw.wmnet - done db2068.codfw.wmnet - done db2029.codfw.wmnet - done

root@neodymium:/home/marostegui# for i in dbstore2001 dbstore2002 db2040 db2047 db2054 db2061 db2068 db2029; do echo i;mysql−hi; mysql -hi;mysql−hi.codfw.wmnet centralauth -e "show create table localuser;" | egrep "lu_local_id|lu_global_id";done dbstore2001 localuser CREATE TABLE localuser (\n lu_wiki varbinary(255) NOT NULL DEFAULT '',\n lu_name varbinary(255) NOT NULL DEFAULT '',\n lu_attached_timestamp varbinary(14) DEFAULT NULL,\n lu_attached_method enum('primary','empty','mail','password','admin','new','login') DEFAULT NULL,\n lu_local_id int(10) unsigned DEFAULT NULL,\n lu_global_id int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (lu_wiki,lu_name),\n KEY lu_name (lu_name,lu_wiki)\n) ENGINE=InnoDB DEFAULT CHARSET=binary dbstore2002 localuser CREATE TABLE localuser (\n lu_wiki varbinary(255) NOT NULL DEFAULT '',\n lu_name varbinary(255) NOT NULL DEFAULT '',\n lu_attached_timestamp varbinary(14) DEFAULT NULL,\n lu_attached_method enum('primary','empty','mail','password','admin','new','login') DEFAULT NULL,\n lu_local_id int(10) unsigned DEFAULT NULL,\n lu_global_id int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (lu_wiki,lu_name),\n KEY lu_name (lu_name,lu_wiki)\n) ENGINE=InnoDB DEFAULT CHARSET=binary db2040 localuser CREATE TABLE localuser (\n lu_wiki varbinary(255) NOT NULL DEFAULT '',\n lu_name varbinary(255) NOT NULL DEFAULT '',\n lu_attached_timestamp varbinary(14) DEFAULT NULL,\n lu_attached_method enum('primary','empty','mail','password','admin','new','login') DEFAULT NULL,\n lu_local_id int(10) unsigned DEFAULT NULL,\n lu_global_id int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (lu_wiki,lu_name),\n KEY lu_name (lu_name,lu_wiki)\n) ENGINE=InnoDB DEFAULT CHARSET=binary db2047 localuser CREATE TABLE localuser (\n lu_wiki varbinary(255) NOT NULL DEFAULT '',\n lu_name varbinary(255) NOT NULL DEFAULT '',\n lu_attached_timestamp varbinary(14) DEFAULT NULL,\n lu_attached_method enum('primary','empty','mail','password','admin','new','login') DEFAULT NULL,\n lu_local_id int(10) unsigned DEFAULT NULL,\n lu_global_id int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (lu_wiki,lu_name),\n KEY lu_name (lu_name,lu_wiki)\n) ENGINE=InnoDB DEFAULT CHARSET=binary db2054 localuser CREATE TABLE localuser (\n lu_wiki varbinary(255) NOT NULL DEFAULT '',\n lu_name varbinary(255) NOT NULL DEFAULT '',\n lu_attached_timestamp varbinary(14) DEFAULT NULL,\n lu_attached_method enum('primary','empty','mail','password','admin','new','login') DEFAULT NULL,\n lu_local_id int(10) unsigned DEFAULT NULL,\n lu_global_id int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (lu_wiki,lu_name),\n KEY lu_name (lu_name,lu_wiki)\n) ENGINE=InnoDB DEFAULT CHARSET=binary db2061 localuser CREATE TABLE localuser (\n lu_wiki varbinary(255) NOT NULL DEFAULT '',\n lu_name varbinary(255) NOT NULL DEFAULT '',\n lu_attached_timestamp varbinary(14) DEFAULT NULL,\n lu_attached_method enum('primary','empty','mail','password','admin','new','login') DEFAULT NULL,\n lu_local_id int(10) unsigned DEFAULT NULL,\n lu_global_id int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (lu_wiki,lu_name),\n KEY lu_name (lu_name,lu_wiki)\n) ENGINE=InnoDB DEFAULT CHARSET=binary db2068 localuser CREATE TABLE localuser (\n lu_wiki varbinary(255) NOT NULL DEFAULT '',\n lu_name varbinary(255) NOT NULL DEFAULT '',\n lu_attached_timestamp varbinary(14) DEFAULT NULL,\n lu_attached_method enum('primary','empty','mail','password','admin','new','login') DEFAULT NULL,\n lu_local_id int(10) unsigned DEFAULT NULL,\n lu_global_id int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (lu_wiki,lu_name),\n KEY lu_name (lu_name,lu_wiki)\n) ENGINE=InnoDB DEFAULT CHARSET=binary db2029 localuser CREATE TABLE localuser (\n lu_wiki varbinary(255) NOT NULL DEFAULT '',\n lu_name varbinary(255) NOT NULL DEFAULT '',\n lu_attached_timestamp varbinary(14) DEFAULT NULL,\n lu_attached_method enum('primary','empty','mail','password','admin','new','login') DEFAULT NULL,\n lu_local_id int(10) unsigned DEFAULT NULL,\n lu_global_id int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (lu_wiki,lu_name),\n KEY lu_name (lu_name,lu_wiki)\n) ENGINE=InnoDB DEFAULT CHARSET=binary