oh, maybe because I ran abzsubmit again to check if it wasn't sending weird data
2014-11-20 32410, 2014
alastairp
also, this is interesting now
2014-11-20 32411, 2014
alastairp
because we whitelist
2014-11-20 32450, 2014
Mineo
so it seems to be a problem with data that was submitted at the very beginning of acousticbrainz because http://acousticbrainz.org/fe65b13e-6edc-40b8-a022… (same album, submitted around the same time) has the problem as well
2014-11-20 32451, 2014
alastairp
really? it seems to me like it's a metadata problem
are you assuming that you're the only person who's submitted this track?
2014-11-20 32421, 2014
alastairp
I've told you. there's a tag called "artists", not artist
2014-11-20 32443, 2014
alastairp
we know that we're not showing the "correct" track for a duplicate. it's on the list
2014-11-20 32428, 2014
Mineo
ah, yes, I assumed I was the only one that submitted it
2014-11-20 32447, 2014
alastairp
good data point for that page: "number of submitted tracks"
2014-11-20 32438, 2014
Mineo
that would be great :)
2014-11-20 32406, 2014
Mineo
also, what's the scale for the "danceability" value?
2014-11-20 32414, 2014
alastairp
0 - we don't know
2014-11-20 32423, 2014
Mineo
ok
2014-11-20 32425, 2014
alastairp
according to the source code, about 3
2014-11-20 32432, 2014
alastairp
annecdotally, 0-1
2014-11-20 32439, 2014
alastairp
with wayyyy too many tracks at 1
2014-11-20 32405, 2014
alastairp
I'm having errors uploading images to the blog
2014-11-20 32447, 2014
alastairp
it looks like it uploads it, then says "an error occurred"
2014-11-20 32447, 2014
alastairp
ah, I reloaded the edit page and it's ok
2014-11-20 32412, 2014
warp joined the channel
2014-11-20 32415, 2014
Gentlecat joined the channel
2014-11-20 32456, 2014
xram
I'm under the impression that caa is no longer included into replication packets since the 17th of november
2014-11-20 32407, 2014
xram
are you already aware of it ?
2014-11-20 32433, 2014
xram
in fact a "grep cover" of the latest dbmirror_pending gives no results
2014-11-20 32447, 2014
CallerNo6 joined the channel
2014-11-20 32459, 2014
kepstin-laptop joined the channel
2014-11-20 32407, 2014
JesseW joined the channel
2014-11-20 32450, 2014
ijabz joined the channel
2014-11-20 32414, 2014
adhawkins joined the channel
2014-11-20 32408, 2014
adhawkins joined the channel
2014-11-20 32440, 2014
dukeleto joined the channel
2014-11-20 32416, 2014
michaeljames joined the channel
2014-11-20 32409, 2014
chirlu`
ianmcorvidae: Still hunting the edit search performance issue; may I see the output of “SELECT attname, most_common_vals, most_common_freqs, histogram_bounds FROM pg_stats WHERE tablename = 'edit' AND attname IN ('status', 'type')”?
2014-11-20 32431, 2014
ianmcorvidae
chirlu`: huh. no histogram_bounds at all for status, that seems questionable
2014-11-20 32440, 2014
ianmcorvidae
rest of it, one sec while I get it somewhere web-accessible
2014-11-20 32411, 2014
chirlu`
Histogram bounds are only needed for range queries, though, so not really applicable here.
(Though I don’t know why Postgres would know we don’t do range queries on status. :-) )
2014-11-20 32430, 2014
ianmcorvidae
perhaps it doesn't include a histogram when it has the entire set of possibilities in the most_common_* bits
2014-11-20 32439, 2014
ianmcorvidae
(which it will there)
2014-11-20 32439, 2014
chirlu`
Ah, that may be.
2014-11-20 32435, 2014
chirlu`
Unfortunately, this output doesn’t explain why the problem is there, either. :-(
2014-11-20 32439, 2014
chirlu`
Or perhaps it does, because the searches currently don’t time out.
2014-11-20 32418, 2014
LordSputnik joined the channel
2014-11-20 32419, 2014
chirlu`
Searches for some historic edit types are still slow, because they make up for a relatively high percentage of all edits, so the planner uses a table scan; which takes much longer than estimated because there are no recent edits of this type.
2014-11-20 32449, 2014
chirlu`
Don’t see a way to improve this without cross-column statistics.
2014-11-20 32408, 2014
ianmcorvidae
splitting up the edit table is the way to fix that
CallerNo6 doesn't have much hope that his ascii logo will catch on. (𝇒}
2014-11-20 32450, 2014
CallerNo6
(well, not ascii)
2014-11-20 32412, 2014
alastairp
ruaok: yeeeargh
2014-11-20 32425, 2014
ruaok
ah ha. thanks yeeeargh!
2014-11-20 32435, 2014
alastairp
ruaok: he pm'd them to me, so I dont' think anyone else as seen them :)
2014-11-20 32447, 2014
ruaok
oh, heh.
2014-11-20 32459, 2014
alastairp
sigh. ok
2014-11-20 32401, 2014
alastairp
things to do
2014-11-20 32459, 2014
Zastai joined the channel
2014-11-20 32403, 2014
Zastai
hmm - new-release editor seems to have messed up. first it stopped showing correct info for mediums 2&3 (after using track parser for quick update), then it stopped showing any edit info on Edit Note pane
2014-11-20 32419, 2014
Zastai
enter edit resulted in "Can't call method "id" on an undefined value at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 247, <$fh> line 1. "
