[12:54:15] marostegui: mysql is not running on clouddb1029, is that expected? [12:56:01] dhinus: I've not touched that host [12:56:39] I haven't touched it either, in phab I see you wrote on Jul, 13th "clouddb1029 is now replicating s5 s8" [12:56:43] let me check when it stopped [12:57:20] earlier today: Error reading relay log event: slave SQL thread was killed [12:57:22] dhinus: Jul 24 11:33:28 clouddb1029 mysqld[49680]: 2026-07-24 11:33:28 0 [Note] InnoDB: Starting shutdown... [12:58:06] dhinus: both instances, maybe your script? [12:58:19] It was shutdown cleanly and at the same time [12:58:28] checking the logs [13:01:15] ah I see, yes it was my cookbook and it was an interesting combination of events [13:01:28] it tried to stop all 3 instances, but one was not running [13:01:34] dhinus: but it wasn't rebooted though [13:01:46] yes because it doesn't handle this case, so it crashed and stopped there [13:02:13] the script tries to stop all instances, then reboot. if one of the instances cannot be stopped, instead of skipping it, it just crashes :/ [13:02:37] and leaves it like that? [13:03:02] yes, it reenables puppet, but does not try to restart it. I need to fix this [13:03:11] *does not try to restart mariadb [13:03:51] I'm restarting mariadb manually [13:04:49] mind if I start all sections, even if x3 is depooled? [13:06:02] s5 and s8 restarted and catching up [13:06:56] dhinus: x3 is no more on that host [13:07:21] you're right, then why the cookbook was detecting it? checking [13:08:13] maybe because mysql.x3 is still present [13:08:20] yeah, maybe a leftover [13:08:27] we can just remove it [13:08:59] spicerack is actually checking "/etc/mysql/mysqld.conf.d/*.cnf" [13:09:29] I will delete both /etc/mysql/mysqld.conf.d/x3.cnf and /usr/local/bin/mysql.x3 [13:09:53] +1 [13:10:32] done [13:10:41] s5 and s8 are back in sync, I will retry the reboot and it should work now [13:10:44] thanks [13:17:59] 1029 rebooted successfully, I'm doing 1030, 1031 and 1033, then only 1032 is left and I'll leave that to you [13:20:53] 1032 was already done [13:25:08] ok excellent, all clouddbs are done then! [13:25:15] great! [13:30:41] 1029 also has "wmf-pt-kill@x3" that needs removing, doing it now [13:30:53] thank you [13:34:00] done