@Dispenser are you aware of a big transaction (looks like an UPDATE) being done to: u2815__p.all_articles.
Apparently it started yesterday around 23:09:34
That run on the toolforge db master and it has now being executed on the slave (labsdb1004) - it has been running now for around 8 hours)
The slave is stuck processing: Exec_Master_Log_Pos: 16403525 for log.186637
Which looks like it has a massive amount of UPDATES like:
### UPDATE `u2815__p`.`all_articles` ### WHERE ### @1=REMOVED /* INT meta=0 nullable=0 is_null=0 */ ### @2='REMOVED' /* VARSTRING(1020) meta=1020 nullable=0 is_null=0 */ ### @3='1' /* VARSTRING(1024) meta=1024 nullable=0 is_null=0 */ ### @4=0 /* TINYINT meta=0 nullable=0 is_null=0 */ ### @5=-1 (255) /* TINYINT meta=0 nullable=0 is_null=0 */ ### @6=-1 (255) /* TINYINT meta=0 nullable=0 is_null=0 */ ### SET ### @1=REMOVED /* INT meta=0 nullable=0 is_null=0 */ ### @2='REMOVED' /* VARSTRING(1020) meta=1020 nullable=0 is_null=0 */ ### @3='1' /* VARSTRING(1024) meta=1024 nullable=0 is_null=0 */ ### @4=0 /* TINYINT meta=0 nullable=0 is_null=0 */ ### @5=0 /* TINYINT meta=0 nullable=0 is_null=0 */ ### @6=0 /* TINYINT meta=0 nullable=0 is_null=0 */
There is no PK on that key.
Table: all_articles Create Table: CREATE TABLE `all_articles` ( `aa_page` int(10) unsigned NOT NULL, `aa_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `title_normalized` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL, `aa_is_dab` tinyint(1) NOT NULL, `linkedFromDab` tinyint(1) NOT NULL, `linkedFromSI` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci