[07:52:23] !log admin add new /dev/sdb back to software raid after it was replaced in cloudcephmon1004 [07:52:28] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [14:22:27] !status Ok [14:28:15] oh, right. thanks! [16:52:57] !log lucaswerkmeister@tools-bastion-13 tools.ranker deployed 5e4572a330 (l10n updates: it) [16:52:59] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.ranker/SAL [16:54:34] !log lucaswerkmeister@tools-bastion-13 tools.wd-image-positions deployed 9cea85d255 (l10n updates: tr) [16:54:35] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.wd-image-positions/SAL [17:29:39] Hello, I'm getting "pymysql.err.OperationalError: (1226, "User 's51114' has exceeded the 'max_user_connections' resource (current value: 10)")" connecting to toolforge DB. I think it's because I killed some processes and maybe left orphaned connections? Is there any way to clear those out or do I just have to wait for them to timeout? [17:32:28] hmmm.. I was about to suggests using `show processlist;` and `kill` to get rid of those but that requires you to be able to connect in the first place [17:33:03] oh wait sorry [17:33:09] this isn't on toolforge, it's on the replica db [17:33:35] enwiki.analytics.db.svc.eqiad.wmflabs [17:33:39] the same comment applies there [17:33:43] let me manually kill thsoe for you [17:33:48] thank you! [17:35:48] audiodude: i don't see any active connections for s51114 on that database [17:36:07] okay maybe they timed out on their own already? [17:36:12] I was just seeing that message in my logs [17:36:19] recent logs! [17:37:03] do you know if the connection limit is new by any chance? [17:37:39] no [17:38:05] (= yes I know it's not new, just realized that's a bit ambigious) [17:38:14] lol thanks [17:41:43] okay everything's working again now, thanks! [18:20:30] !log lucaswerkmeister@tools-bastion-13 tools.wdactle deployed 8f20eca8ac (scroll to guess on click) [18:20:32] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.wdactle/SAL [18:35:40] taavi: do you have a recommendation regarding cron in debian 12? i.e. should I install cron? anacron? systemd-cron? Or is it just that with the package missing the structure is not as verbose, but the dirs do still work for basic things if I create them myself? [18:36:26] I noticed that on cvn-apache12, I installed apache2 and php mod, and that included logrotate and php session GC and various crons installed. I would assume that one of these would have set up a dependency or warned me if those didn't run. [18:36:34] but it looks like indeed none are running [18:37:34] FWIW I noticed that several cron scripts on my own server are set up to exit early if a corresponding systemd timer is enabled, so I’m guessing those are only included in the packages for compatibility [18:37:55] but I don’t even know if that’s true for all the cronjobs on my server (I haven’t uninstalled cron), let alone yours [18:38:26] Krinkle: systemd timers or just install cron, depending on what you find easier. I personally prefer systemd timers [18:39:11] and yes, as Lucas says the various packages installing cron jobs should also install systemd timers that do the same thing. [18:41:13] OK. [18:44:24] and if packages don't install systemd timers, I expect they should depend on (or recommend?) cron? [18:48:33] May 26 16:09:14 cvn-apache11 systemd[1]: Finished phpsessionclean.service - Clean php session files. [18:48:42] looks like apache2 indeed provisions a systemd timer as wel [18:49:00] these, unlike crons, don't log to /var/log/syslog by default, but I fished the above from sudo journalctl