2020-06-30T01:35:49  *** lurchi_ is now known as lurchi__
2020-06-30T01:52:02  *** lurchi__ is now known as lurchi_
2020-06-30T02:07:11  *** lurchi_ is now known as lurchi__
2020-06-30T02:46:46  *** okurz_ is now known as okurz
2020-06-30T04:45:13  -heroes-bot- PROBLEM: PSQL locks on mirrordb2.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 272 * total waiting locks: 132 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb2.infra.opensuse.org&service=PSQL%20locks
2020-06-30T04:59:22  -heroes-bot- PROBLEM: HTTP download on pontifex2.infra.opensuse.org - CRITICAL - Socket timeout after 10 seconds ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=pontifex2.infra.opensuse.org&service=HTTP%20download
2020-06-30T05:05:14  -heroes-bot- RECOVERY: PSQL locks on mirrordb2.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=4 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb2.infra.opensuse.org&service=PSQL%20locks
2020-06-30T05:09:12  -heroes-bot- RECOVERY: HTTP download on pontifex2.infra.opensuse.org - HTTP OK: HTTP/1.1 200 OK - 6638 bytes in 0.005 second response time ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=pontifex2.infra.opensuse.org&service=HTTP%20download
2020-06-30T05:24:57  *** Martchus_ is now known as Martchus
2020-06-30T07:17:24  -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=40 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-30T09:23:24  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 51 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-30T10:03:24  -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-06-30T12:01:24  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 59 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-30T14:13:17  *** lurchi_ is now known as lurchi__
2020-06-30T16:15:24  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 66 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-30T20:16:20  *** cboltz_ is now known as cboltz
2020-06-30T20:51:14  *** okurz_ is now known as okurz
2020-06-30T21:05:25  -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=20 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-30T21:19:24  -heroes-bot- PROBLEM: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS CRITICAL: DB postgres total locks: 62 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-06-30T21:22:17  <lcp99> cboltz: did you come up with any ideas with the long queries :P
2020-06-30T21:22:27  <lcp99> as you can see above, pg doesn't like it
2020-06-30T22:00:17  <cboltz> lcp: not really, see what I wrote 3 days ago
2020-06-30T22:01:32  <cboltz> the most interesting part is that one part in the explain showed a big number (>1M) of rows in the subqueries