2021-09-23T09:59:11  <darix> JanZerebecki[m]: i reverted that patch again. I think a cleaner solution would be 1. shutdown matrix.o.o. 2. fix the collation 3. fix all broken records in the DB
2021-09-23T09:59:26  <darix> instead of hammering over it with upsert
2021-09-23T10:16:48  <darix> cboltz_: https://about.gitlab.com/releases/2021/09/22/gitlab-14-3-released/
2021-09-23T10:18:53  <cboltz_> darix: thanks for the info, but I only know gitlab as a user, so the infamous "Mr. Someone Else" will need to do the update ;-)
2021-09-23T11:02:29  <JanZerebecki[m]> darix, I think it is done after the federation is synced, but there is more, so I need to update it and include it once more and we can remove it again afterwards
2021-09-23T11:02:53  <darix> JanZerebecki[m]: why not just fix the DB?
2021-09-23T11:03:08  <darix> once you have a clean DB all new inserts should be fine right?
2021-09-23T11:26:54  <JanZerebecki[m]> darix, that is fixing that part of the db. As federation sync happens on startup. And it passed upstream ci. It is the easiest way for me. Creating something that searches for violations of those non-expressed constraints and repairs it by deletion is more work. But it would be the better way, so if you send a patch upstream, i'm interested. 
2021-09-23T11:27:52  <darix> it wont need a patch
2021-09-23T11:28:11  <darix> it would need a few sql queries to fix the DB and then some blog post to explain how and why
2021-09-23T11:28:24  <JanZerebecki[m]> And just using a one off sql command seems riskier, if I fat finger that...
2021-09-23T11:31:32  <darix> that
2021-09-23T11:31:42  <darix> thats why your DB is offline and you have a backup
2021-09-23T18:19:51  <kl_eisbaer> cboltz: good news - the updated cachet package works -> https://status3.opensuse.org/ . Now the only addition left is the apparmor profile
2021-09-23T18:47:54  <darix> kl_eisbaer: php-fpm or mod_php?
2021-09-23T18:50:48  <kl_eisbaer> mod_php at the moment. There is already an apparmor profile on the old status machine, But I still see some receive/send signals being blocked with it
2021-09-23T18:51:22  <kl_eisbaer> operation="signal" profile="/usr/sbin/httpd{,2}-prefork//HANDLING_UNTRUSTED_INPUT" comm="httpd-prefork" requested_mask="receive" denied_mask="receive" signal=term peer="/usr/sbin/httpd{,2}-prefork"
2021-09-23T18:51:51  <kl_eisbaer> operation="signal" profile="/usr/sbin/httpd{,2}-prefork" pid=14441 comm="httpd-prefork" requested_mask="send" denied_mask="send" signal=term peer="/usr/sbin/httpd{,2}-prefo
2021-09-23T18:51:54  <kl_eisbaer> for example
2021-09-23T18:52:15  <darix> that is apache base profile which doesnt fit
2021-09-23T18:52:42  <darix> cboltz: is that fixed upstream already?
2021-09-23T18:52:49  <kl_eisbaer> ...and did I already say that I love maintenance for releasing kernel updates on Thursday EVENING, when the maintenance window is on Thursday MORNING? :-/
2021-09-23T18:53:33  <darix> they want to give you 6.5days to plan the kernel updates ;)
2021-09-23T18:53:46  <kl_eisbaer> I know that they are very polite and friendly people
2021-09-23T18:55:11  <darix> which file are you editing there?
2021-09-23T18:55:30  <darix> because i think it might be opensuse specific
2021-09-23T18:55:32  <kl_eisbaer> at the moment: none 
2021-09-23T18:55:34  <darix> ok
2021-09-23T18:56:18  <kl_eisbaer> but it should be /etc/apparmor.d/apache2.d/cachet on status{1,2}.opensuse.org
2021-09-23T18:56:33  <kl_eisbaer> but anyway: time to leave for today
2021-09-23T18:56:53  <kl_eisbaer> "Raus aus diesem Irrenhaus" - Gute Nacht! :D
2021-09-23T18:56:58  <darix> nn