Hmm, in the commands I posted, you'll probably want to replace the user (-U flag) with postgres instead of bookbrainz
2019-05-16 13622, 2019
gr0uch0mars joined the channel
2019-05-16 13619, 2019
akhilesh
Yes, It require, how to replace user with postgres instead of bookbrainz?
2019-05-16 13635, 2019
Mr_Monkey
`-U postgres`
2019-05-16 13645, 2019
Mr_Monkey
instread of `-U bookbrainz`
2019-05-16 13649, 2019
akhilesh
ok
2019-05-16 13657, 2019
ayerhart_ has quit
2019-05-16 13613, 2019
akhilesh
Mr_Monkey: Running now, Thanks!
2019-05-16 13623, 2019
Mr_Monkey
Great :)
2019-05-16 13656, 2019
ayerhart joined the channel
2019-05-16 13648, 2019
akhilesh
Mr_Monkey: In which issue, You are working ?
2019-05-16 13611, 2019
akhilesh
in BB
2019-05-16 13642, 2019
Mr_Monkey
Currently on ListenBrainz, but about to go back to tackling entity merging
2019-05-16 13615, 2019
akhilesh
I am working with date validation tests, then I think we should move to author_credit
2019-05-16 13623, 2019
akhilesh
also, it is imp
2019-05-16 13608, 2019
akhilesh
Mr_Monkey ^
2019-05-16 13629, 2019
Mr_Monkey
Agreed
2019-05-16 13653, 2019
Mr_Monkey
That gives me a day or two to think of a plan and what needs to be done
2019-05-16 13620, 2019
akhilesh
By that time, I will try to finish date related work.
2019-05-16 13647, 2019
ayerhart has quit
2019-05-16 13656, 2019
D4RK-PH0ENiX has quit
2019-05-16 13629, 2019
D4RK-PH0ENiX joined the channel
2019-05-16 13659, 2019
Matthew_ joined the channel
2019-05-16 13603, 2019
D4RK-PH0ENiX has quit
2019-05-16 13606, 2019
Matthew_
Hi. I'm struggling to get full indexing working properly on Solr. I note a lot of errors in logs about missing fields when running reindex from mb-sir. It seems that the submodules for mb-solr are very old and aren't aware of some schema 25 fields. Does anyone know what revisions I should be using to reindex against a schema 25 database? Or should I be using a < schema 25 version of mb-sir to do the indexing? Thanks!
2019-05-16 13655, 2019
yvanzo
Hi Matthew_: are errors about label/isni only?
2019-05-16 13656, 2019
Matthew_
Hi yvanzo. I'm mostly seeing issues with artists - haven't got any further than the 'a's ;) I'm seeing 'unknown field 'primary_alias'' a lot.
2019-05-16 13616, 2019
yvanzo
schema 25 should still work with previous versions of mb-solr/sir
2019-05-16 13648, 2019
yvanzo
Matthew_: Ok, which versions of mb-solr and sir do you run?
2019-05-16 13640, 2019
yvanzo
sir master is ready to work with schema 25, but mb-solr is still work-in-progress
2019-05-16 13658, 2019
yvanzo
We still run previous versions of mb-solr/sir in production.
2019-05-16 13610, 2019
Matthew_
For mb-solr, I've tried 'master' should I be using v3.0? For sir, I don't see any branch/tag that leaps out as stable so I'm also on master
2019-05-16 13651, 2019
Matthew_
OK. Thanks, yvanzo. What versions/revisions would you recommend for those components?
2019-05-16 13610, 2019
yvanzo
mb-solr v3.0
2019-05-16 13632, 2019
yvanzo
and sir commit 5109d2606eb84a444b1c15dd6efe70571e67afd7
2019-05-16 13645, 2019
Matthew_
Great. Thanks, yvanzo!
2019-05-16 13645, 2019
yvanzo
Matthew_: you will have to patch sir requirements.txt because mbdata 2017.6.2 is no more available from PyPI
2019-05-16 13601, 2019
Matthew_
Thanks yvanzo. What version should I be replacing it with? most recent? 25.0.3?
2019-05-16 13631, 2019
yvanzo
Same version, but it should retrieved from github instead as follows:
ferbncode: Finals could always be better, but it wasn't too bad.
2019-05-16 13624, 2019
Lotheric_ joined the channel
2019-05-16 13645, 2019
ohrstrom joined the channel
2019-05-16 13652, 2019
Lotheric has quit
2019-05-16 13632, 2019
alastairp
how do I submit acoustids with picard? on mac, I have fpcalc bundled, I added an API key, the album has mbids
2019-05-16 13611, 2019
alastairp
the icon is grayed out
2019-05-16 13609, 2019
CallerNo6
alastairp, and you've hit the `scan` button I assume
2019-05-16 13655, 2019
alastairp
no, it wasn't clear that you have to scan before you can submit (in this case I know that the album has no fingerprints, so I assumed that scan wasn't necessary)
2019-05-16 13620, 2019
alastairp
also, scan only works if there are files in the left, but since they all have mbids, they all go straight to the right
2019-05-16 13627, 2019
alastairp
anyway, I found the scan button now, doing that.
2019-05-16 13628, 2019
CallerNo6
no, it's not very clear. it trips me up every time I've done it.
2019-05-16 13609, 2019
CallerNo6
You can select and drag a set of files back to the left to do further operations on them at any time.
2019-05-16 13610, 2019
alastairp
thanks
2019-05-16 13617, 2019
alastairp
looks like acoustid is down anyway, I'll finish tomorrow
2019-05-16 13618, 2019
CallerNo6
argh. anyway, iirc the submit button will also be ghosted if there's already a match (same mbid and acoustid).
2019-05-16 13656, 2019
Lotheric_ is now known as Lotheric
2019-05-16 13640, 2019
ferbncode
spellew: Cool, just let me know whenever you're done fixing the timelines. :) Also, hit me with any questions that you encounter o/
2019-05-16 13657, 2019
Matthew_ has quit
2019-05-16 13655, 2019
ohrstrom has quit
2019-05-16 13609, 2019
spellew
ferbncode: Sure thing
2019-05-16 13641, 2019
ohrstrom joined the channel
2019-05-16 13627, 2019
ohrstrom has quit
2019-05-16 13653, 2019
iliekcomputers
alastairp: re comments on PR, if the rows aren't ordered, suppose the current max is 3, the query then returns rows 8, 9, 10 without returning 4, 5, 6, that'd be a bug.
2019-05-16 13620, 2019
alastairp
iliekcomputers: mmm, sure. but it only has to return 4, 5, 6 eventually. if it computes 8 9 10 then the left join against highlevel will have non-null rows, so they won't be selected, and maybe 4 5 6 will appear
2019-05-16 13615, 2019
iliekcomputers
but once 10's hl data is calculated, the new max would become 10, so the query would only return ids >= 10.
2019-05-16 13631, 2019
iliekcomputers
that's the way I wrote it, not sure if there's something I'm missing.
2019-05-16 13642, 2019
alastairp
mmm, yes. this is the bit that I was missing
2019-05-16 13652, 2019
alastairp
you're right. if we want to have a limit we need to do it in order
2019-05-16 13631, 2019
alastairp
OK, I think we should try it splitting into 2 queries too then - as ruaok pointed out last week, doing order by with the json table in the picture makes queries quite slow
2019-05-16 13640, 2019
alastairp
do you understand the queryplans that I asked for?
