Event Timeline
Comment Actions
root@db1098.eqiad.wmnet[frwiki]> CREATE UNIQUE INDEX ct_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id); ERROR 1062 (23000): Duplicate entry '183704908-185' for key 'ct_rev_tag_id'
Comment Actions
root@db1113:~# mysql -S /run/mysqld/mysqld.s6.sock -e "show slave status\G" *************************** 1. row *************************** Slave_IO_State: Master_Host: db1173.eqiad.wmnet Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: db1173-bin.000313 Read_Master_Log_Pos: 400654759 Relay_Log_File: db1113-relay-bin.000025 Relay_Log_Pos: 400655059 Relay_Master_Log_File: db1173-bin.000313 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 400654759 Relay_Log_Space: 400655417 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: Yes Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 171978805 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 171974883-171974883-1921892293,0-180359184-3049354376,180367475-180367475-264159665,171970594-171970594-1063329989,171974662-171974662-836768948,171978904-171978904-200854125,171970705-171970705-239075862,171978766-171978766-1375989821,180359184-180359184-35598956,180367474-180367474-91976046,171978805-171978805-102808315 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: conservative SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 0 Slave_Transactional_Groups: 12564988
Comment Actions
root@db1098.eqiad.wmnet[frwiki]> explain SELECT /* DifferenceEngine::loadRevisionData */ ct_tag_id AS `value` FROM `change_tag` WHERE ct_rev_id = 178004903 /* 53cc390a825e0a18df7723cd34285e2d db1098:3316 frwiki 2s */; +------+-------------+------------+------+---------------+---------------+---------+-------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+------------+------+---------------+---------------+---------+-------+------+-------------+ | 1 | SIMPLE | change_tag | ref | ct_rev_tag_id | ct_rev_tag_id | 5 | const | 2 | Using index | +------+-------------+------------+------+---------------+---------------+---------+-------+------+-------------+ 1 row in set (0.002 sec)