@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
```