[06:10] icey: I've MIR reviewed all of the octavia packages (and associated depends). Majority need security review as well (assigned to security team) and there are a couple of non-blocking recommendations as well [06:11] cool - how would you feel reviewing the sqlalchemy-utils one? [06:11] :-D [06:16] oh jamespage - looks like you also did that already, thanks :) [06:16] I did [09:56] I just checked my mysql status with systemctl and I see: Status: "InnoDB: Error: Database page corruption on disk or a failed file read of tablespace..." I wonder if anyone has a tool that sends email alerts when something like this occurs? [09:57] are there any good tools for that? [10:43] skylite: I use zabbix for that sort of things, but I would guess systemd has some setting for it somewhere? [10:44] RoyK: Im looking into it in #systemd it's not that easy by default [10:44] but thanks [10:50] skylite: OnFailure=notify-failed@%n [10:50] not that? [10:51] https://serverfault.com/questions/694818/get-notification-when-systemd-monitored-service-enters-failed-state/701100 [10:52] no this is only for notifying if the service is down [10:53] for example my mysql is not down I just have a corrupted table for instance [10:53] I would see that in the StatusText [10:55] I see [10:56] well, I would just write a zabbix check for that if there isn't anything available already, but then, you'll need to setup zabbix first which my be a bit overkill for monitoring a single machine [10:57] I'm using datadog I'll check if they have a solution for this one [10:57] I already have a command that gives me the last StatusText back for a service [10:57] If nothing I'll write a shell script that alerts me on change [11:06] should work [11:06] or just pipe it though sed or awk or perl or python or something to look for bad signs [11:10] skylite: something like this: if $(systemctl status mysql | grep -i error > /dev/null 2>&1 ) ; then echo No error ; else echo FAIL! ; fi [11:11] sure but I'm thinking I want to somehow save the last status and alert if it changes [11:11] I feel like I need to know everything for now :D [11:22] skylite: you may be able to get some ideas from this https://share.zabbix.com/operating-systems/systemd-service-monitoring [11:23] it's way broader, though, but possibly worth a look [11:26] skylite: erm - sorry - forget about that - it just shows status, not details [11:29] it'd be nice i systemctl could output its status in some parsable format like json or something [11:29] I bet it can [11:30] couldn't find anything in the manual [11:30] busctl get-property org.freedesktop.systemd1 /org/freedesktop/systemd1/unit/mysqld_2eservice org.freedesktop.systemd1.Service StatusText [11:30] this gives me back only the StatusText string [11:30] for mysql [11:41] should be ok to script then === klokken is now known as iopl === iopl is now known as klokken