zas: the 7-day graphs for load, blks_hits and temp_bytes don't look normal to me, though I don't see anything obvious right now
2020-06-22 17417, 2020
bitmap
I just killed one query that was stuck, but
2020-06-22 17428, 2020
bitmap
it *looks* like someone or some thing is requesting every VA release ever
2020-06-22 17444, 2020
bitmap
since all these slow queries being logged are from Data::Release::find_by_artist, have WHERE acn.artist = '1', and ridiculous offsets like OFFSET '86400'
2020-06-22 17410, 2020
bitmap
zas: check grep -F 'GET /ws/2/release?artist=89ad4ac3-39f7-470e-963a-56509c546377' in prod.musicbrainz-website.access.log, someone's doing strange things from a bunch of different ips :P
2020-06-22 17419, 2020
bitmap
we should still fix the find_by_artist query to not be so slow an maybe reject offsets exceeding some sensible number, but
the thing I think muight make sense is if Hildegard's works are added, and that links between this book's work and hers are made
2020-06-22 17425, 2020
CatQuest
something like "[bookwork] contains {partial} ... by [hildegardwork]
2020-06-22 17433, 2020
CatQuest
the .. is the wrod i have problems with
2020-06-22 17435, 2020
CatQuest
ford*
2020-06-22 17438, 2020
CatQuest
word ffs
2020-06-22 17418, 2020
CatQuest
does this seem sane to you/have you any feedback
2020-06-22 17406, 2020
v6lur joined the channel
2020-06-22 17429, 2020
Mr_Monkey
So the "Hildegard av Bingens urtehage" contains some of Bingens' works?
2020-06-22 17455, 2020
CatQuest
excerpts of it (that's the word i was looking for!)
2020-06-22 17410, 2020
Mr_Monkey
The relationship you described makes sense in that case. There is a "WorkX contains WorkY" relationship that could apply
2020-06-22 17419, 2020
CatQuest
and translated int omodern norwegian via (probably) modern german, yes
2020-06-22 17428, 2020
CatQuest
ooh that's perfect
2020-06-22 17429, 2020
Mr_Monkey
The partial"" part at the moment is the issue
2020-06-22 17433, 2020
CatQuest
yes
2020-06-22 17440, 2020
CatQuest
for now we can use contains
2020-06-22 17446, 2020
Mr_Monkey
Yes
2020-06-22 17458, 2020
CatQuest
the "contains excerpts" could be a future child relatinonship
2020-06-22 17406, 2020
Mr_Monkey
Agreed
2020-06-22 17422, 2020
Mr_Monkey adds to /opens ticket
2020-06-22 17434, 2020
CatQuest
for books, quotations and thel ike are so common that a spearate rel is neccessary I feel, since there is a difference between "just a quote" and "countaisn parts"
2020-06-22 17404, 2020
Mr_Monkey
Definitely
2020-06-22 17422, 2020
CatQuest
ok last final thing before I'll let you go on with it:
2020-06-22 17430, 2020
CatQuest
there is a dart of types for non-fiction
2020-06-22 17441, 2020
Mr_Monkey
And then there's also possibly "references" for when a book appears as a source but is not quoted
2020-06-22 17451, 2020
CatQuest
oh yes! i'd love such a rel too!
2020-06-22 17410, 2020
CatQuest
this book has a rich refrence sectino wich woudl be cool to link
2020-06-22 17430, 2020
CatQuest
oh! imagine how much interesting data we coudl ahve aobut what boosk refrences what books
2020-06-22 17436, 2020
Mr_Monkey
> there is a dart of types for non-fiction
2020-06-22 17436, 2020
Mr_Monkey
What was this about?
2020-06-22 17419, 2020
CatQuest
there are few types for works, for non-fiction
2020-06-22 17436, 2020
CatQuest
there is adiference between f-ex colouringbooks and herbaries
2020-06-22 17400, 2020
ruaok wastes more hours battling datetime vs epoch vs datetime+tz vs other non-sense in LB
short story: disallowed concerned user-agent, cpu load divided by 2, for only few requests dropped
2020-06-22 17458, 2020
CatQuest
504 is somewhat differnt
2020-06-22 17406, 2020
Mr_Monkey
CatQuest: I'm following the subject, but not sure what the question is
2020-06-22 17419, 2020
sumedh has quit
2020-06-22 17421, 2020
alastairp
ruaok: hi, is there a public dump of messybrainz data? An ex-coworker is working on some metadata matching projects at his job and they're looking for some data to test with (and are happy to share results when they have something)
2020-06-22 17441, 2020
CatQuest
ah: theqiestion is: whne if at all woudl it be feasable to have this? is this osmething we want users to be able to add (ie specialusers liek relationships)
