makes sense, i'll add to the comment on that proposal.
2022-04-04 09444, 2022
lucifer
we only have 2 proposals for LB for the time being so that's it on this topic.
2022-04-04 09418, 2022
mayhem
thanks for jumping into this -- I hope to be out of accounting jail tomorrow.
2022-04-04 09426, 2022
mayhem
half day should do it.
2022-04-04 09458, 2022
lucifer
alastairp: you may also want to look at the proposal above. particularly the time zone storage stuff, i had assumed PG had a built in type for it but apparently there isn't one.
2022-04-04 09408, 2022
lucifer
ah cool. nice
2022-04-04 09409, 2022
PrathameshG[m]
<akshaaatt> "Why would you need to share..." <- Actually half of them were just MBID examples embedded with the links haha.
2022-04-04 09409, 2022
PrathameshG[m]
I removed them, so it should be fine now ig.
2022-04-04 09416, 2022
alastairp
lucifer: yeah, I have it open now. that's a good question
2022-04-04 09442, 2022
lucifer
the answers i saw on SO, suggested text column plus a constraint check.
2022-04-04 09444, 2022
akshaaatt
Great Prathamesh! All the best :)
2022-04-04 09419, 2022
PrathameshG[m]
<alastairp> "PrathameshG: you can make a..." <- Yes, I am doing both.
2022-04-04 09419, 2022
PrathameshG[m]
Including a full link for the google doc, as well as a not-as-good-looking proposal written in Markdown on discourse.
2022-04-04 09428, 2022
alastairp
lucifer: where text is the name of an official tz database name?
2022-04-04 09437, 2022
lucifer
yes.
2022-04-04 09402, 2022
alastairp
right. I wonder how often new ones get added/removed there? :)
2022-04-04 09411, 2022
PrathameshG[m]
akshaaatt: Thanks akshaaatt :))
2022-04-04 09425, 2022
lucifer
oh well there was a great controversy about that recently.
2022-04-04 09431, 2022
alastairp
yes, I remember
2022-04-04 09447, 2022
alastairp
lucifer: oh, urhg. you know what I realised
2022-04-04 09405, 2022
lucifer
mostly about pre 1970 dates though so not concerning us much. iirc PG chose to track the fork or revert changes from offical repos
2022-04-04 09418, 2022
alastairp
for when DST changes, we should probably store an offset with the listen, indicating what the offset was at the time that it was submitted
2022-04-04 09456, 2022
alastairp
there was that interesting post on HN a few weeks back about how to store time in calendars for future events
2022-04-04 09405, 2022
lucifer
do we need an offset for that? i was assuming knowing the timezone would be enough and a datetime lib could figure out the offset.
2022-04-04 09416, 2022
alastairp
nope
2022-04-04 09420, 2022
lucifer
oh!
2022-04-04 09451, 2022
Dijia joined the channel
2022-04-04 09459, 2022
alastairp
because for example, CEST happens from the last sunday of march to the last sunday of october
2022-04-04 09409, 2022
alastairp
but what if next year they decide to start it on the first sunday of april
2022-04-04 09429, 2022
Freso
alastairp: datetime lib should be able to handle that.
2022-04-04 09435, 2022
Freso
Using the tzdata.
2022-04-04 09405, 2022
alastairp
hmm, yes, if it takes into account historical data then it should
2022-04-04 09409, 2022
lucifer
yeah i was assuming tzdata tracks the offset for each zone over period
2022-04-04 09417, 2022
Freso
It does.
2022-04-04 09434, 2022
mayhem
Freso: I have some obligations at :30 after the hour. I'd love to go sooner than later, plz.
2022-04-04 09404, 2022
alastairp
lucifer: in any case, some careful things to think about with this proposal so that we don't screw it up again like we did with the listened at timestamp
2022-04-04 09408, 2022
alastairp
I'll take a look at it
2022-04-04 09410, 2022
Freso
<BANG>
2022-04-04 09411, 2022
Freso
It’s International Monday for Mine Awareness and Assistance in Mine Action!
I was occupied with work and some IRL matters last week so was unfortunately unable to dedicate much time to MB.
2022-04-04 09412, 2022
Freso
However I did resolve a minor issue with shorewall due to a reference to an invalid log file and hopefully fixed an recurrent issue with apt tasks failing when bootstrapping servers. I also reviewed a PR created by zas that added a role to manage timezone and NTP configuration.
2022-04-04 09412, 2022
Freso
The playbooks are now mature enough that zas was able to fully deploy a server from scratch in 30 minutes today, which is a great achievement.
2022-04-04 09413, 2022
Freso
"""
2022-04-04 09413, 2022
Freso
Others up: alastairp, mayhem, akshaaatt, zas, yvanzo, lucifer, bitmap, monkey, reosarevok, CatQuest, Freso – anyone else who wish to give review, let me know ASAP!
2022-04-04 09414, 2022
Freso
mayhem: Go!
2022-04-04 09417, 2022
mayhem
thx!
2022-04-04 09424, 2022
Freso
Np :)
2022-04-04 09430, 2022
alastairp
great to see the playbooks going well!
2022-04-04 09434, 2022
lucifer
alastairp: yes makese sense 👍
2022-04-04 09434, 2022
alastairp
!m atj and zas
2022-04-04 09434, 2022
BrainzBot
You're doing good work, atj and zas!
2022-04-04 09443, 2022
mayhem
last week was all about the metadata view, or more specifically the MB datadata cache coming together.
2022-04-04 09450, 2022
mayhem
massive SQL queries ftw.
2022-04-04 09417, 2022
mayhem
lucifer and I also cleaned up some mapping stuff, fixing some things that were not mapped and also renaming things to be more consistent.
2022-04-04 09455, 2022
mayhem
we now also have a python class for making it super simple to run an SQL query to create a new table and then to rotate that table into production inside a transaction.
2022-04-04 09420, 2022
mayhem
those bulk tables can be chained as well, so more than one table can be swapped in in the same transaction.
2022-04-04 09442, 2022
mayhem
this is the meat and potatoes of the mapping work, so this will make me more efficient in the future.
2022-04-04 09456, 2022
mayhem
then I paid people and did quarterly accounting today.
mayhem alastairp akshaaatt : Please check it out if you find some time :))
2022-04-04 09452, 2022
PrathameshG[m]
Feel free to criticize it wherever possible. I'd be happy to even rewrite it if required!
2022-04-04 09424, 2022
akshaaatt
Sure PrathameshG[m]! Will do so after a while :)
2022-04-04 09425, 2022
mayhem
will do tomorrow afternoon
2022-04-04 09425, 2022
Freso
Mostly the usual, but I also poked at an issue with logging in to the forums from the iOS… and got that solved. So anyone using the Discourse iOS app should now be able to use it with our instance, too. :)
2022-04-04 09444, 2022
Freso
fin.
2022-04-04 09446, 2022
Freso
alastairp: Go!
2022-04-04 09450, 2022
alastairp
hello
2022-04-04 09425, 2022
PrathameshG[m]
Thanks a lot akshaaatt mayhem :)
2022-04-04 09449, 2022
alastairp
last week I finished work on the metadata viewer backend to update out of date rows, and planned with mayhem how to actually find out of date rows. I also started work on data dumps for the canonical tables
2022-04-04 09439, 2022
alastairp
I finally got the BU upgrade in CB finished and released and some people tested that. It's looking good so we'll merge and roll that out. with lucifer's help I also merged and released some really old CB PRs (from before when lucifer was a contractor!)
2022-04-04 09413, 2022
alastairp
I also read and reviewed some SoC proposals, and reviewed some PRs
2022-04-04 09408, 2022
alastairp
finally, I worked on getting AB dumps working, so that we can distribute an archive of submissions when we shut the site down. 2 of the 3 dump types are working, so almost finished there
2022-04-04 09416, 2022
alastairp
that's me, akshaaatt next?
2022-04-04 09422, 2022
akshaaatt
Hi everyone!
2022-04-04 09439, 2022
akshaaatt
Last week I worked massively on the MusicBrainz revamp work
I also opened a PR to improve our CAA error logging and deployed that to hopefully help debug an issue Zas was seeing
2022-04-04 09418, 2022
bitmap
earlier in the week I helped perform another primary database switchover from pink to floyd so that pink could be upgraded, then restored standby service on pink later that day. and I apologize for not better communicating which services would be affected by that, I've noted it for the future!
2022-04-04 09434, 2022
bitmap
fin. yvanzo go!
2022-04-04 09441, 2022
yvanzo
Hi!
2022-04-04 09455, 2022
yvanzo
Last week I hotfixed bugs in the wrapper that runs MB background tasks.
2022-04-04 09407, 2022
Freso
(Still up: zas, lucifer, monkey, reosarevok, CatQuest – anyone else who wish to give review, let me know ASAP!)
2022-04-04 09407, 2022
yvanzo
Helped with pink update, and investigated some alerts (CAA, SIR…).
2022-04-04 09418, 2022
yvanzo
Updated the documentation PR about Docker volumes.
2022-04-04 09427, 2022
yvanzo
Resumed updating the PR about releasing MBS.
2022-04-04 09437, 2022
yvanzo
Also reviewed a few PRs and provided support.
2022-04-04 09450, 2022
yvanzo
Finito, go zas!
2022-04-04 09454, 2022
zas
Hey
2022-04-04 09426, 2022
zas
Mainly worked on moving servers to ansible, last week we did pink, patton and ludwig
2022-04-04 09414, 2022
zas
It implied fixing/improving our playbooks, but today's ludwig was up and running within 30 minutes from scratch (including formatting/installing from rescue)
2022-04-04 09442, 2022
monkey
!m zas and atj
2022-04-04 09442, 2022
BrainzBot
You're doing good work, zas and atj!
2022-04-04 09400, 2022
zas
I also continued on new gateways, fixed few issues, and started to benchmark (using vegeta), there's some bottlenecks related to SSL I need to identify
2022-04-04 09456, 2022
zas
basically I achieved 30k+ req/s on http on a single server, but this goes down to 2.5k in https with keepalive, and only 530 without ka
2022-04-04 09404, 2022
zas
(that's per second)
2022-04-04 09449, 2022
zas
plus usual supervision, upgrades, edits, PR reviews. fin, lucifer?
2022-04-04 09400, 2022
lucifer
hi all!
2022-04-04 09401, 2022
cuanim has quit
2022-04-04 09426, 2022
Freso
(Only monkey, reosarevok, and CatQuest left.)
2022-04-04 09407, 2022
lucifer
i reviewed some LB PRs last week and SoC proposals. also did some on work on metadata viewer backend and related electron app. also some dumps debugging. that's it for me.
2022-04-04 09409, 2022
lucifer
reosarevok: next?
2022-04-04 09417, 2022
reosarevok
Hi!
2022-04-04 09444, 2022
reosarevok
I released the server, worked on a few small issues, and took a couple chill days to rest and bird and cycle
2022-04-04 09402, 2022
reosarevok
Also spent some time reviewing akshaaatt's code :)
2022-04-04 09403, 2022
CatQuest
:bird:
2022-04-04 09405, 2022
alastairp
I didn't know that birds could cycle
2022-04-04 09409, 2022
CatQuest
:D
2022-04-04 09416, 2022
CatQuest
cyclebirds
2022-04-04 09419, 2022
reosarevok
It's in the Lion King, dude
2022-04-04 09423, 2022
CatQuest
eeehht
2022-04-04 09425, 2022
reosarevok
It's the cyyyyycle of biiiirss
2022-04-04 09428, 2022
reosarevok
*birds
2022-04-04 09438, 2022
CatQuest
shouldn't thst be birbs
2022-04-04 09445, 2022
reosarevok
Oh, yeah, of birbs
2022-04-04 09404, 2022
reosarevok
Anyway, this week plan is to hopefully start working on moods
We should work on merging some of the open schema change PRs too
2022-04-04 09414, 2022
reosarevok
But anyway, that's it for me. CatQuest ?
2022-04-04 09425, 2022
CatQuest
Meow! `😺`
2022-04-04 09446, 2022
CatQuest
last week was spent mostly nagging people to help write a stupid blogpost
2022-04-04 09407, 2022
CatQuest
then reosarevok basically rewrote the whole thing :(
2022-04-04 09407, 2022
CatQuest
but it ended up a success so that was a good thing! :D
2022-04-04 09416, 2022
CatQuest
this week I've nagged monkey and shub but they are doing really good work
2022-04-04 09427, 2022
mayhem runs off
2022-04-04 09428, 2022
mayhem
bai!
2022-04-04 09449, 2022
CatQuest
so I'll be working on testing bookbrainz and seeing if I can be at all useful :) ♓
2022-04-04 09449, 2022
CatQuest
fin, go monkey !
2022-04-04 09449, 2022
CatQuest
(also ps happy aprilfish day!)
2022-04-04 09457, 2022
monkey
Hello everyone !
2022-04-04 09400, 2022
monkey
Last week I worked on UI mockups for the LB metadata viewer, with a bit of help from aerozol (thanks!)
2022-04-04 09407, 2022
monkey
I tweaked BB's automated GitHub deployment configuration a bit, and deployed a new version in production.
2022-04-04 09413, 2022
monkey
We’ve already identified a couple of regressions (unrelated to the deployment config), so not the best deployment ever…we’re discussing better deployment cycle practices on the #bookbrainz channel.
2022-04-04 09422, 2022
monkey
I also reviewed PRs, mostly for BB, and spent some time helping and directing new contributors, participating in forum discussions and reviewing GSoC project proposals.
