2020-06-29T01:03:19  *** lurchi_ is now known as lurchi__
2020-06-29T02:47:31  *** okurz_ is now known as okurz
2020-06-29T04:45:24  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total waiting locks: 8 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-29T04:51:13  -heroes-bot- PROBLEM: PSQL locks on mirrordb2.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 366 * total waiting locks: 179 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb2.infra.opensuse.org&service=PSQL%20locks
2020-06-29T04:55:24  -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=17 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-29T05:01:13  -heroes-bot- RECOVERY: PSQL locks on mirrordb2.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=3 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb2.infra.opensuse.org&service=PSQL%20locks
2020-06-29T07:44:44  *** ggardet is now known as guillaume_g
2020-06-29T08:42:09  -heroes-bot- PROBLEM: HTTP l10n on nuka.infra.opensuse.org - CRITICAL - Socket timeout after 10 seconds ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=nuka.infra.opensuse.org&service=HTTP%20l10n
2020-06-29T08:55:09  *** ggardet is now known as guillaume_g
2020-06-29T09:01:59  -heroes-bot- RECOVERY: HTTP l10n on nuka.infra.opensuse.org - HTTP OK: HTTP/1.1 200 OK - 41221 bytes in 0.369 second response time ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=nuka.infra.opensuse.org&service=HTTP%20l10n
2020-06-29T11:52:40  <witek_> #opensuse-factory
2020-06-29T11:52:51  <witek_> ups, sorry
2020-06-29T13:28:38  <bmwiedemann1> there is a 1h bugzilla downtime scheduled for today 15:00 UTC =17:00 CEST
2020-06-29T13:29:37  <bmwiedemann1> should we add that to status.o.o ?
2020-06-29T15:03:54  <lcp90> kl_eisbaer: would you mind having a look at https://progress.opensuse.org/issues/66063 stuff, I pretty much summed up why I can't really do much about the postgres thing ;)
2020-06-29T15:04:38  <lcp90> I need to remind daniel about freeipa thing, since three weeks passed like a week ago
2020-06-29T15:12:47  <kl_eisbaer> bmwiedemann: yes, please.
2020-06-29T15:13:00  <kl_eisbaer> lcp90: ok, let me have a look...
2020-06-29T15:13:49  <kl_eisbaer> lcp90: let me ask you back in the ticket, what exactly you need.
2020-06-29T15:19:01  <kl_eisbaer> https://progress.opensuse.org/issues/66063?issue_count=147&issue_position=132&next_issue_id=65816&prev_issue_id=68512#note-8
2020-06-29T15:20:40  <kl_eisbaer> bmwiedemann: https://bugzilla.opensuse.org/index.cgi still seems to be online for me?
2020-06-29T15:33:24  <lcp90> kl_eisbaer: sudoers access is enough, thanks :P
2020-06-29T15:40:45  <lcp90> kl_eisbaer: oh yeah, the dbs need pgbouncer stuff, don't they? do we have any place where that's documented?
2020-06-29T16:04:33  *** zyga-mbp is now known as zyga
2020-06-29T16:06:27  *** paka is now known as Guest45419
2020-06-29T19:27:22  <kl_eisbaer> ähem: I thought it is somewhere in the wiki, but it looks like my brain lost the place.
2020-06-29T19:28:07  <kl_eisbaer> anyway: if you become the postgres user, you should find a file in your home called: pgbouncer.access.sql
2020-06-29T19:29:28  <kl_eisbaer> just execute that for the database in question like: ```psql -d matrix -f pgbouncer.access.sql```
2020-06-29T19:30:41  <kl_eisbaer> ...and please do not forget to adjust the /etc/pgbouncer/pg_hba.conf on anna and elsa (they are postgresql.infra.opensuse.org)
2020-06-29T20:54:22  *** lurchi_ is now known as lurchi__
2020-06-29T22:49:12  *** lurchi__ is now known as lurchi_
2020-06-29T23:05:04  *** lurchi_ is now known as lurchi__
2020-06-29T23:17:24  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 87 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-29T23:26:07  *** lurchi__ is now known as lurchi_