2020-03-09T00:01:17  <cboltz> BTW: line 9058 is   INSERT INTO `vb_tag`
2020-03-09T03:06:54  *** okurz_ is now known as okurz
2020-03-09T08:22:42  *** ldevulder_ is now known as ldevulder
2020-03-09T09:40:31  *** jadamek2 is now known as jadamek
2020-03-09T10:30:56  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 60 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-03-09T11:50:56  -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=43 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-03-09T12:03:43  *** Martchus_ is now known as Martchus
2020-03-09T12:04:55  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 70 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-03-09T14:02:58  -heroes-bot- PROBLEM: MySQL WSREP recv on galera3.infra.opensuse.org - CRIT wsrep_local_recv_queue_avg = 197.220831 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=galera3.infra.opensuse.org&service=MySQL%20WSREP%20recv
2020-03-09T14:55:41  <malcolmlewis> pjessen, when you have a moment, seems the Forum Mods received forum notifications the other day with your opensuse.org email. I advised them it was a transient issue...
2020-03-09T15:44:59  <pjessen> malcolmlewis:  yeah, I see some of those - I have no idea why they would have gone out.
2020-03-09T15:45:42  <pjessen> I also see some bounces of the same.
2020-03-09T15:46:52  <pjessen> all, do we have a dns problem?
2020-03-09T15:49:15  <pjessen> hmm, must be local
2020-03-09T15:49:21  <lcp> not experiencing any issues atm
2020-03-09T15:50:57  <malcolmlewis> pjessen, or have MF changed it on the live system?
2020-03-09T15:51:51  <pjessen> malcolmlewis: I doubt it, not much reason to. I'll check if our new system has sent out any mails.
2020-03-09T15:53:40  <malcolmlewis> pjessen, ok thanks :)
2020-03-09T15:57:20  <pjessen> malcolmlewis:  the new machine has in fact sent out 12-13 mails, since 28 Feb. All to my address though :-)
2020-03-09T15:58:07  <pjessen> malcolmlewis: I have seen some bounces, but they came from a novell server. hmm, dunno
2020-03-09T16:06:17  <malcolmlewis> pjessen, then it may have been from the MF side... oh well...
2020-03-09T16:19:16  <malcolmlewis> pjessen, I've asked Henk to post the full email headers to see what is what.
2020-03-09T16:24:56  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 140 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-03-09T16:30:11  <malcolmlewis> pjessen, https://susepaste.org/74608784
2020-03-09T16:30:18  <pjessen> malcolmlewis: the database does have a novell server set for outgoing SMTP, I wonder if mails are sent in the time gap before I change it
2020-03-09T16:30:51  <malcolmlewis> pjessen, if it's changed now, then issue solved ;)
2020-03-09T16:32:01  <pjessen> malcolmlewis: partially.   every time I try another import, it is reset :-)
2020-03-09T16:32:44  <malcolmlewis> pjessen, ahh ok, maybe on the host /dev/null the email server?
2020-03-09T16:34:11  <malcolmlewis> 127.0.0.2 smtp2.provo.novell.com ?
2020-03-09T16:34:31  <pjessen> there is a config.php option to disable email altogether, I just forget to use it
2020-03-09T16:34:49  <malcolmlewis> pjessen, :)
2020-03-09T16:34:55  -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=29 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-03-09T16:35:20  <pjessen> malcolmlewis: yup, looks familiar - the database is loading (again) right now, I can't verify it.
2020-03-09T16:36:11  <pjessen> malcolmlewis: yeah, not a bad idea.
2020-03-09T16:39:22  <malcolmlewis> pjessen, who knows where other email bits are lurking...
2020-03-09T16:43:22  <pjessen> malcolmlewis: agree and I like your solution.
2020-03-09T16:53:10  <pjessen> malcolmlewis: done
2020-03-09T21:53:23  -heroes-bot- PROBLEM: MySQL WSREP recv on galera2.infra.opensuse.org - CRIT wsrep_local_recv_queue_avg = 70.663474 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=galera2.infra.opensuse.org&service=MySQL%20WSREP%20recv