I've been trying to find some clues as to why mailman/postorious is so
slow, e.g. when discarding held messages.
I have notcied some long-running queries, running for 5-10-15mins, which
is bad enough, but I can't connect them to the slow discards. However,
I also see a few commits that have been waiting since yesterday:
mailman=> select usename,query_start,query from pg_stat_activity
WHERE (now()-query_start) > interval '5 minutes';
usename | query_start | query
mailman | 2022-01-17 15:40:06.544184+00 | COMMIT
mailman | 2022-01-18 16:26:05.343713+00 | COMMIT
mailman | 2022-01-17 15:40:14.329369+00 | COMMIT
mailman | 2022-01-17 15:40:13.993539+00 | COMMIT
mailman | 2022-01-17 15:40:15.522812+00 | COMMIT
Earlier I had one more:
mailman | 2022-01-17 15:40:12.888636+00 | COMMIT
so that one seems to have finished, aber after more than 24hours?
Surely, something is not right here?
Per Jessen, Zürich (1.7°C)
Member, openSUSE Heroes
I have a help request response ready, but can't submit it. :(
Evolution as taught in public schools is, like religion,
based on faith, not based on science.
Team OS/2 ** Reg. Linux User #211409 ** a11y rocks!
here are the minutes from today's meeting:
- Per sent a report on the mailinglist 
- the wiki update is mostly prepared, a few small issues need to be
fixed. Thanks to Klaus Kämpf for updating the elasticsearch package!
- salt GPG key was expired - updated, everybody needs to re-import it
from the salt repo before encrypting pillar
some discussions about the authentification systems
Bill wants to join the heroes
log.debug "If you are interested, I am here, but you probably are not."
log.info "JFYI: I am here"
log.warn "Hey! I am here."
log.error "I am here and you have problem."
[Josef Reidinger in yast-devel]
the first heroes meeting in 2022 will be on Tuesday (2022-01-11) at
19:00 UTC / 20:00 CET in https://meet.opensuse.org/heroes
Feel free to add your topics and/or status reports to
or just join the meeting ;-)
> Das sehe ich anders. Ein Mailserver sollte eine Message id nur
> einmal verwenden. [...]
Stimmt schon, aber wie heisst es so schön "Der klügere gibt nach"
(und das ist fast nie der Exchange)
[Sven Pastorik und Ralf Hildebrandt in postfix-users]
I just updated https://en-test.opensuse.org/ to MediaWiki 1.37.1.
Those with access to our salt repo  already know that the upgrade
needed several changes in config files etc.
The database upgrade took quite some time, but was nearly painless (only
exception: some AbuseFilter database indexes)
Please test if everything still works, and tell me if you find any
Known bug: The new ElasticSearch server is not setup yet, therefore the
search is completely broken and will not find anything.
BTW: en-test is based on a terribly outdated database dump of the
english wiki, therefore don't expect to find anything about the 15.x
releases on it.
I'll import the latest database dump from en.o.o on en-test.o.o (and
also sync file uploads) in a few days to do another test upgrade - but
I'll first give you the chance to find technical errors ;-)
 which translates to "everybody" - I just mirrored the latest version
One piece of advice: if you maintain a C&C server (which is both a
really bad idea and a criminal act and as such, strongly discouraged),
always use a strong password.
It's very unprofessional if your server is cracked this easily.
openSUSE:infrastructure contains some packages that don't have a build
target anymore. (This typically means they were enabled only for older
distributions like Leap 42.3.)
If nobody objects, I'll delete the following packages in a week:
- protobuf (link to Factory)
- python-six and python-six:test (outdated link to Factory)
- python-urllib3 and python-urllib3:test (outdated link to Factory)
- salt (outdated link to Factory, only build target is 15.2, and that is
hefur also doesn't have a build target anymore, but since it's a real
package (and is probably still used on download.o.o), I won't delete it.
Der geistige Horizont ist der Abstand zwischen Brett und Kopf.
I hope, everyone enjoyed the Christmas break.
I took the time to cleanup the network bridge between Nuremberg and Provo - and for some DNS cleanups.
The most interesting one might be: widehat.opensuse.org is gone.
As we run a new hypervisor machine named stonehat.opensuse.org now since a while - and the real HW of the former widehat.o.o is gone - I decided to give the (new) VM a speaking name: rsync.opensuse.org
Reverse DNS, mb and rsync stuff is done. I hope, I found most other important places. Only Salt needs someone who knows how to rename a minion.
More about the new hypervisor (including the generous personal HW sponsoring from our bcache-Code maintainer, Coly Li) and other (sponsoring) news from 2021 will become public on news.o.o soon. We are currently just waiting for the last approvals from some sponsors.
I just would like to follow up the wiki update topic from IRC:
This week I would like to start playing with OBS, going to set up an env for it and start looking into the wiki build. If you have any advice throw it my way ;)
I have a few pretty hectic weeks at work, but by the end of next week I should be good to work on this project. If all goes well I can keep on maintaining things going forward.
If there is a deadline on this please let me know so can try and prioritize things differently.
here are the minutes of today's heroes meeting:
- test package is building
- test installation will probably be updated next week
- meet.o.o can currently only have SUSE admins because it's used for
- meet-test.o.o server can have community admins (use one of the
*.infra.o.o VMs as jump host for ssh login)
- we have membership management again (phpMyAdmin)
- helios update prepared, waiting for a review of the salt MR
- Mirrorcache will implement a redirect in the future which will
redirect the user to a more local mirrorcache instance to make
subsequent requests faster
- Notes from Lars: https://progress.opensuse.org/issues/101851#note-2 -
TODO: JeOS changes need to also go into salt
- Notes from Per on the mailinglist:
- Neal will try to fix the 500s when creating a new issue on code.o.o
- Bernhard will try to find the ticket about the jenkins for openSUSE:
- IRC/matrix bridge is broken,
- datacenter move planned for April, we should have backup instances of
*.o.o in Provo or at QSC to avoid downtime
- backup server is ready - and waiting for admins to back up their
stuff. Please open a ticket, if you want to join the "backup party"
openSUSE Infrastructure Contributor Agreement:
- we base on trust
- should include the common openSUSE principles/guidelines
- we can not require an openSUSE hero to be an openSUSE member - as they
just earn the credits to become a member by working as openSUSE hero -
but we can ask to follow the member guidelines in general
- will be moved by a week to Jan 11th
Meine allerste Festplatte hatte 30 MB, und ich war der King, weil alle
anderen 20 MB hatten. Sie fragten, was ich mit 30 MB wolle, die bekomme
ich doch nie voll. ;) Meine jetzige Graphikkarte hat mehr. ;))
[Bernd Brodesser in suse-linux]