2020-03-07T03:08:04  *** okurz_ is now known as okurz
2020-03-07T04:42:55  -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-03-07T04:52:56  -heroes-bot- RECOVERY: PSQL locks on mirrordb1.infra.opensuse.org - POSTGRES_LOCKS OK: DB postgres total=38 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=mirrordb1.infra.opensuse.org&service=PSQL%20locks
2020-03-07T09:26: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-07T10:38:43  <pjessen> goodmorning - I see I have a new database machine?
2020-03-07T10:46:55  -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-07T10:52:13  <lcp> pjessen: yup
2020-03-07T11:07:03  <pjessen> hmm, no access yet
2020-03-07T11:08:05  <pjessen> might it have been easier to just give the current vm some resources and run mysql locally?
2020-03-07T11:08:22  <pjessen> some *more* resources
2020-03-07T12:12:21  <cboltz> pjessen: the temporary mysql server is ready, I'll send you a mail with some details
2020-03-07T12:16:06  <pjessen> have just received it - pgp encoded?  I'm not set up for that :-)
2020-03-07T12:16:19  <cboltz> it contains some passwords ;-)
2020-03-07T12:16:49  <cboltz> but I can put it on the forums VM if that makes things easier
2020-03-07T12:17:01  <pjessen> good idea
2020-03-07T12:17:48  <cboltz> see /dev/shm/fuer_per on forum.i.o.o
2020-03-07T12:18:05  <cboltz> please delete the file after making a, well, backup ;-)
2020-03-07T12:20:38  <pjessen> okay, danke
2020-03-07T12:21:23  <cboltz> FYI: I only did a basic config for mysql (using salt + mysql-formula)
2020-03-07T12:21:38  <cboltz> since this VM is meant as a temporary solution, feel free to manually edit the mysql config
2020-03-07T12:22:09  <pjessen> okay
2020-03-07T12:59:17  <lcp> cboltz: news-o-o might have too good caching rules, people are complaining they don't see the news without reloading a few times (some headers will need adjusting)
2020-03-07T13:00:14  <cboltz> good point, we probably just copied over the expiry time from static.o.o
2020-03-07T13:01:00  <cboltz> please adjust to more sensible values - I'd guess that especially "text/" (which gets used for html) should have less than 28d ;-)
2020-03-07T13:01:39  <lcp> sure, I will do that later today
2020-03-07T14:02:58  -heroes-bot- PROBLEM: MySQL WSREP recv on galera3.infra.opensuse.org - CRIT wsrep_local_recv_queue_avg = 453.863412 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=galera3.infra.opensuse.org&service=MySQL%20WSREP%20recv
2020-03-07T14:34:59  <pjessen> for now, the forums are running on the new vm.
2020-03-07T14:49:46  <pjessen> the forums database that is
2020-03-07T15:32:35  <malcolmlewis> pjessen, even logged in.... https://susepaste.org/1c93515d seems you have nntp active?
2020-03-07T15:35:55  <malcolmlewis> pjessen, would need to make sure that page is only visible to forum staff ;)
2020-03-07T17:58:32  <pjessen> malcolmlewis: if anything, it points to the old nntp service in Provo, and that's not active anymore.
2020-03-07T18:19:02  <lcp> hm, I would assume nntp for news.opensuse.org also stopped working since we switched?
2020-03-07T19:07:55  <pjessen> lcp: i dont know if we even had any nntp on news.o.o ?
2020-03-07T19:08:30  <lcp> I believe so
2020-03-07T19:08:45  <lcp> but nowadays I doubt anybody even used it anymore
2020-03-07T19:08:55  <pjessen> you would be surprised.
2020-03-07T19:09:15  <pjessen> the forums had an active community on nntp until last June
2020-03-07T19:10:45  <lcp> excellent
2020-03-07T19:11:18  <lcp> it kinda feels good getting rid of the crusty old parts of the infra
2020-03-07T19:12:09  <pjessen> well, I hope we can reestablish it actually :-)
2020-03-07T19:12:23  <pjessen> but moving stuff "home" feels good.
2020-03-07T19:15:10  <cboltz> pjessen: for the forum database charset/encoding -
2020-03-07T19:15:27  <cboltz> ideally the dump should have both CREATE TABLE (with charset given) and INSERT so that things don't break
2020-03-07T19:15:43  <cboltz> practise shows that this might not have been the case ;-)
2020-03-07T19:16:21  <cboltz> if you want to convert a table to another charset, that's not as easy as it might look
2020-03-07T19:16:47  <cboltz> if you for example alter a column from latin1 to utf8, mysql will convert the content, so in the end, you won't see a change
2020-03-07T19:17:39  <cboltz> the trick is to first convert to varbinary (will only change the column description, not the content), and then to varchar utf8 (which again will only change the column description)
2020-03-07T19:18:32  <lcp> always remember to set everything up at utf-8 or utf-16, because otherwise it's a nightmare to convert later >:D
2020-03-07T19:19:00  <cboltz> agreed, but that's another topic ;-)
2020-03-07T19:19:50  <cboltz> (besides that, if you want multi-column indexes and have content that is guaranteed to be latin1, you really might want to use latin1 to avoid problems with the maximum index length)
2020-03-07T21:53:22  -heroes-bot- PROBLEM: MySQL WSREP recv on galera2.infra.opensuse.org - CRIT wsrep_local_recv_queue_avg = 214.439856 ; See https://monitor.opensuse.org/icinga/cgi-bin/extinfo.cgi?type=2&host=galera2.infra.opensuse.org&service=MySQL%20WSREP%20recv