0:01 AM
shivam-kapila has quit
2020-02-23 05428, 2020
0:21 AM
D4RK-PH0ENiX has quit
2020-02-23 05400, 2020
0:41 AM
D4RK-PH0ENiX joined the channel
2020-02-23 05448, 2020
0:50 AM
tmontney has quit
2020-02-23 05403, 2020
2:42 AM
kyan joined the channel
2020-02-23 05445, 2020
3:09 AM
Gore has quit
2020-02-23 05405, 2020
3:10 AM
Gore joined the channel
2020-02-23 05432, 2020
3:14 AM
prabal has quit
2020-02-23 05457, 2020
4:01 AM
shivam-kapila joined the channel
2020-02-23 05447, 2020
4:24 AM
goldenshimmer joined the channel
2020-02-23 05427, 2020
4:50 AM
SomalRudra joined the channel
2020-02-23 05458, 2020
5:03 AM
dpmittal joined the channel
2020-02-23 05410, 2020
5:40 AM
SomalRudra has quit
2020-02-23 05417, 2020
5:55 AM
supersandro2000 has quit
2020-02-23 05442, 2020
5:55 AM
supersandro2000 joined the channel
2020-02-23 05445, 2020
6:11 AM
shivam-kapila has quit
2020-02-23 05406, 2020
6:27 AM
Guest34242 joined the channel
2020-02-23 05411, 2020
6:58 AM
D4RK-PH0ENiX has quit
2020-02-23 05409, 2020
7:15 AM
D4RK-PH0ENiX joined the channel
2020-02-23 05429, 2020
7:16 AM
D4RK-PH0ENiX has quit
2020-02-23 05436, 2020
7:16 AM
D4RK-PH0ENiX joined the channel
2020-02-23 05440, 2020
8:13 AM
dpmittal has quit
2020-02-23 05458, 2020
8:46 AM
shivam-kapila joined the channel
2020-02-23 05427, 2020
8:55 AM
c1e0 joined the channel
2020-02-23 05428, 2020
9:34 AM
ruaok
iliekcomputers: data imported into timescale in 107minutes, with dups removed and unique index created!
2020-02-23 05406, 2020
9:35 AM
ruaok
I think I could very easily build in the sub-second last.fm duplicate track scrubber into this process as well.
2020-02-23 05403, 2020
9:36 AM
ruaok
this level of data cleaning and then carrying forth with INSERT ... ON CONFLICT DO NOTHING would even allow us to not do all the searches we do on the data -- just insert.
2020-02-23 05415, 2020
9:36 AM
ruaok
these arguments are becoming compelling.
2020-02-23 05445, 2020
9:36 AM
iliekcomputers
That is pretty fast!
2020-02-23 05414, 2020
9:37 AM
iliekcomputers
2020-02-23 05423, 2020
9:37 AM
iliekcomputers
Out of curiosity
2020-02-23 05433, 2020
9:37 AM
ruaok
the only thing I haven't sorted out yet is understanding which tracks are considered unique, so we can push them down the unique pipeline.
2020-02-23 05437, 2020
9:37 AM
ruaok
that isn't clear.
2020-02-23 05421, 2020
9:38 AM
ruaok
that is guaranteed to be very slow.
2020-02-23 05404, 2020
9:39 AM
ruaok
anything that requires a complete scan of the db will be slow and should be avoided in a production server.
2020-02-23 05439, 2020
9:40 AM
iliekcomputers
Yeah, I guess that makes sense
2020-02-23 05408, 2020
9:41 AM
ruaok
but the timestamp limited queries that hit a few chunks of time, are quite fast.
2020-02-23 05404, 2020
9:42 AM
ruaok
want a login to the VM?
2020-02-23 05421, 2020
9:42 AM
iliekcomputers
If that query had a ts limit until last week
2020-02-23 05427, 2020
9:43 AM
iliekcomputers
How long would it take
2020-02-23 05456, 2020
9:43 AM
ruaok
find out: 34.68.39.62
2020-02-23 05400, 2020
9:44 AM
ruaok
param@ should work now.
2020-02-23 05406, 2020
9:44 AM
iliekcomputers
I'm just wondering if it has a use case for doing smaller stats things, so we don't have to create specific jobs for sparks for small stuff
2020-02-23 05410, 2020
9:44 AM
ruaok
postgres is exposed on 5432
2020-02-23 05417, 2020
9:44 AM
iliekcomputers
Awesome thanks!
2020-02-23 05421, 2020
9:44 AM
ruaok
run queries as you would any other normal psql instance.
2020-02-23 05436, 2020
9:44 AM
ruaok
"I'm just wondering if it has a use case for doing smaller stats things, so we don't have to create specific jobs for sparks for small stuff"
2020-02-23 05442, 2020
9:44 AM
ruaok
possibly.
2020-02-23 05447, 2020
9:44 AM
iliekcomputers
Can we use pg_dump now?
2020-02-23 05457, 2020
9:44 AM
ruaok
yes.
2020-02-23 05406, 2020
9:45 AM
ruaok
anything PG you want to use, use it.
2020-02-23 05421, 2020
9:45 AM
iliekcomputers
Well, that is really convenient
2020-02-23 05434, 2020
9:45 AM
ruaok
if we write a full TimescaleListenStore, it would mostly invole deleting influx code and porting things to psql.
2020-02-23 05459, 2020
9:45 AM
ruaok
I'll probably have that done even before our hack-day. there just isn't that much work to do.
2020-02-23 05402, 2020
10:05 AM
Gazooo has quit
2020-02-23 05443, 2020
10:06 AM
Gazooo joined the channel
2020-02-23 05410, 2020
10:11 AM
dotmavriq joined the channel
2020-02-23 05402, 2020
10:22 AM
sbvkrishna joined the channel
2020-02-23 05445, 2020
11:45 AM
Sophist-UK joined the channel
2020-02-23 05406, 2020
11:53 AM
sweta05 joined the channel
2020-02-23 05446, 2020
12:01 PM
shivam-kapila has quit
2020-02-23 05415, 2020
12:17 PM
dotmavriq has quit
2020-02-23 05402, 2020
12:30 PM
reosarevok
2020-02-23 05404, 2020
12:30 PM
BrainzBot
MBS-10661: Recording-work rel not showing pending edits on release page
2020-02-23 05412, 2020
12:31 PM
sbvkrishna has quit
2020-02-23 05427, 2020
12:31 PM
sweta05 has quit
2020-02-23 05459, 2020
12:48 PM
anant joined the channel
2020-02-23 05426, 2020
13:03 PM
c1e0 has quit
2020-02-23 05431, 2020
13:13 PM
Guest34242 is now known as killme
2020-02-23 05409, 2020
13:49 PM
Cyna
Hey reosarevok could you tell me what are the edit you made, that broke the edit display ?
2020-02-23 05436, 2020
13:49 PM
reosarevok
I just loaded the recent edits
2020-02-23 05441, 2020
13:49 PM
reosarevok
On the edit search page
2020-02-23 05432, 2020
13:56 PM
reosarevok
Cyna: I suspect you can reproduce it by editing a work without type to have a type or the other way around though
2020-02-23 05437, 2020
13:56 PM
supersandro2000 has quit
2020-02-23 05451, 2020
13:56 PM
supersandro2000 joined the channel
2020-02-23 05411, 2020
14:20 PM
reosarevok
2020-02-23 05412, 2020
14:20 PM
BrainzBot
MBS-10660: Interwiki links are incorrectly configured on MB wiki
2020-02-23 05420, 2020
14:20 PM
reosarevok
(lb and ab are not supposed to be language links :D )
2020-02-23 05451, 2020
14:29 PM
moufl joined the channel
2020-02-23 05434, 2020
14:31 PM
supersandro2000 has quit
2020-02-23 05449, 2020
14:31 PM
supersandro2000 joined the channel
2020-02-23 05404, 2020
14:36 PM
Lotheric
amCap1712: think it would be possible to install your plugin on VLC for android tv ?
2020-02-23 05423, 2020
14:36 PM
Lotheric has an android tv box to test it out :)
2020-02-23 05434, 2020
14:38 PM
amCap1712
Lotheric: to quote vlc devs, that question has a compex answer. it might or might not work.
2020-02-23 05414, 2020
14:39 PM
Lotheric
would I need to follow the linux guide for it ?
2020-02-23 05425, 2020
14:39 PM
Lotheric
I'll try it on my box to see if it works
2020-02-23 05453, 2020
14:39 PM
amCap1712
However, since the plugin is almost similar to audioscrobbler except tls part if audioscrobbler works, listenbrainz should work as well
2020-02-23 05408, 2020
14:40 PM
Lotheric
2020-02-23 05457, 2020
14:40 PM
amCap1712
i am not familiar with android tv interface but yes you should follow linux guide
2020-02-23 05429, 2020
14:41 PM
Lotheric
it has a VLC app in the store, I'll try to fiddle with it :)
2020-02-23 05431, 2020
14:41 PM
amCap1712
you can ping me with any queries you have while installing or using it if it gets installed
2020-02-23 05425, 2020
14:43 PM
BrainzGit
2020-02-23 05435, 2020
14:43 PM
amCap1712
my only doubt is whether you can use an external plugin with android app
2020-02-23 05414, 2020
14:47 PM
chaban
So I've finally found out why MBS-10477 happens.
2020-02-23 05415, 2020
14:47 PM
BrainzBot
2020-02-23 05401, 2020
15:00 PM
Cyna
reosarevok: I think the error is in here `lp_attributes(type.new?.name ?? '', 'work_type')`
2020-02-23 05427, 2020
15:00 PM
Cyna
empty string is not a valid translation key
2020-02-23 05410, 2020
15:01 PM
reosarevok
Yeah, exactly, that's why you need to do what you did for EditSeries, where you had the exact same problem :)
2020-02-23 05434, 2020
15:02 PM
Cyna
Yep solved it and in a funny way XD
2020-02-23 05416, 2020
15:03 PM
Cyna
ohh it was the same way as in EditSeries :(
2020-02-23 05450, 2020
15:08 PM
reosarevok
Well, that's good, we should be consistent across files :p
2020-02-23 05402, 2020
15:13 PM
Cyna
reosarevok: done with both the PRs
2020-02-23 05410, 2020
15:13 PM
Cyna
Let me know once you're done with them :)
2020-02-23 05435, 2020
15:20 PM
anant has quit
2020-02-23 05412, 2020
15:32 PM
sweta05 joined the channel
2020-02-23 05418, 2020
15:33 PM
anant joined the channel
2020-02-23 05404, 2020
15:34 PM
BrainzGit
2020-02-23 05405, 2020
15:34 PM
BrainzBot
2020-02-23 05440, 2020
15:34 PM
reosarevok
yvanzo, bitmap ^ small bugfix that would be great to merge for next release unless it's more complicated than what I thought :)
2020-02-23 05434, 2020
15:50 PM
sweta05 has quit
2020-02-23 05451, 2020
15:52 PM
ZaphodBeeblebrox
BrainzBot: !m test
2020-02-23 05451, 2020
15:52 PM
BrainzBot
You're doing good work, test!
2020-02-23 05423, 2020
15:54 PM
Cyna
BrainzBot: !m me
2020-02-23 05423, 2020
15:54 PM
BrainzBot
You're doing good work, me!
2020-02-23 05429, 2020
15:54 PM
Cyna
BrainzBot: !m /me
2020-02-23 05429, 2020
15:54 PM
BrainzBot
You're doing good work, /me!
2020-02-23 05437, 2020
15:54 PM
Freso
Please keep bot testing to #brainzbot
2020-02-23 05431, 2020
15:55 PM
Cyna
Why cant me be converted to the username :(. Freso do you have a repository of IRC bot ?
2020-02-23 05438, 2020
15:55 PM
ZaphodBeeblebrox
sorry I wastesting ot see if i was actually *in* here (that is online9
2020-02-23 05409, 2020
15:56 PM
Freso
ZaphodBeeblebrox: A single one-off thing is one thing, but when people then pick up on it and it starts to be a whole thing…
2020-02-23 05422, 2020
15:56 PM
ZaphodBeeblebrox
yeh. I mean I didn't want that, sorry
2020-02-23 05433, 2020
15:56 PM
Freso
ZaphodBeeblebrox: No worries. ❤️
2020-02-23 05437, 2020
15:56 PM
ZaphodBeeblebrox
:D
2020-02-23 05453, 2020
15:56 PM
Freso
2020-02-23 05436, 2020
15:58 PM
Cyna
2020-02-23 05443, 2020
15:58 PM
Freso
Yes.
2020-02-23 05416, 2020
15:59 PM
Freso
2020-02-23 05425, 2020
16:05 PM
Freso
2020-02-23 05425, 2020
16:06 PM
Freso
I don’t think it’s a good idea to add a lot of more advanced logic to that. If you want to !m yourself, just do "!m Cyna".
2020-02-23 05424, 2020
16:07 PM
Cyna
2020-02-23 05430, 2020
16:13 PM
vishnuedavarath joined the channel
2020-02-23 05410, 2020
16:14 PM
Cyna
reosarevok: can you restart this ?https://circleci.com/gh/metabrainz/musicbrainz-server/9401?utm_campaign=workflow-failed&utm_medium=email&utm_source=notification
2020-02-23 05402, 2020
16:23 PM
vishnuedavarath has quit
2020-02-23 05455, 2020
17:16 PM
c1e0 joined the channel
2020-02-23 05408, 2020
17:18 PM
Lotheric has quit
2020-02-23 05422, 2020
17:21 PM
Lotheric joined the channel
2020-02-23 05440, 2020
17:38 PM
reosarevok
Cyna: rebase on latest master
2020-02-23 05449, 2020
17:38 PM
Cyna
ok
2020-02-23 05452, 2020
17:45 PM
Freso
I’m trying to make a list of mentors we’ve sent to the GCI student trip in the past. Does anyone remember who went on the 2017, 2018, and 2019 trips? Was LordSputnik 2017?
2020-02-23 05419, 2020
18:07 PM
Freso
Managed to help myself via my e-mail archives. :)
2020-02-23 05402, 2020
18:24 PM
rdswift has quit
2020-02-23 05433, 2020
18:42 PM
iliekcomputers
given that the import was stuck on the single file, since yesterday, i'm debugging on leader with incremental dumps, you might see errors on sentry lb beta.
2020-02-23 05414, 2020
18:47 PM
rdswift joined the channel
2020-02-23 05434, 2020
18:48 PM
iliekcomputers
files still not importing
2020-02-23 05414, 2020
19:13 PM
iliekcomputers
huh
2020-02-23 05420, 2020
19:13 PM
iliekcomputers
so i stopped the request consumer
2020-02-23 05428, 2020
19:13 PM
iliekcomputers
and the import started working
2020-02-23 05435, 2020
19:14 PM
iliekcomputers
whatttt
2020-02-23 05451, 2020
19:16 PM
iliekcomputers
2020-02-23 05404, 2020
19:17 PM
iliekcomputers
looks like there needs to be some hacking around sparkcontexts