it's impossible to execute something I'm asked about a few days ago, which is basically this query: http://www.apaste.info/f8Xm
2014-01-13 01313, 2014
Mattx
it takes way too long
2014-01-13 01325, 2014
djinni` joined the channel
2014-01-13 01300, 2014
reosarevok
Wait
2014-01-13 01316, 2014
reosarevok
For *every single recording* in the DB? The 10 million of them?
2014-01-13 01323, 2014
Mattx
yep
2014-01-13 01336, 2014
reosarevok
Well yeah, that's likely to take a while
2014-01-13 01304, 2014
Mattx
it does finish though, I was just saying.. :P
2014-01-13 01330, 2014
reosarevok has to wonder why you want to do that
2014-01-13 01300, 2014
Mattx
I need a slighlty different query but I couldn't find a way to express it in SQL in a sane way
2014-01-13 01314, 2014
reosarevok
(for a specific artist I would understand it, but for every single recording...)
2014-01-13 01320, 2014
Mattx
do you remember? I wanted some info about all "songs"
2014-01-13 01327, 2014
Mattx
and I asked here what that would be
2014-01-13 01336, 2014
reosarevok
Yeah, but I thought you'd want them for one artist, heh
2014-01-13 01347, 2014
reosarevok
(at a time, I mean)
2014-01-13 01306, 2014
Mattx
the point is this is getting ALLLLLL the recordings
2014-01-13 01316, 2014
Mattx
I was supposed to use the earliest release
2014-01-13 01322, 2014
Mattx
but that's not easy to accomplish
2014-01-13 01346, 2014
Mattx
becuase the year is in two different tables and you have to do LEAST(...) etc :|
2014-01-13 01357, 2014
reosarevok
Heh
2014-01-13 01316, 2014
Mattx
I mean, for a release_group, I only wanted the songs of its earliest release
2014-01-13 01326, 2014
reosarevok is really curious what you want to do with a list of every recording and its release
2014-01-13 01328, 2014
Mattx
instead I'm getting all the songs for simplicity
2014-01-13 01345, 2014
Mattx
(where song == recording)
2014-01-13 01301, 2014
reosarevok
(and nothing else, since you're not getting the artist data or anything)
2014-01-13 01337, 2014
Mattx
I'm getting the recording_group mbid, which is my link to artists!
2014-01-13 01325, 2014
reosarevok
Well, I meant you're not taking the recording artist
2014-01-13 01302, 2014
reosarevok
But yeah, if you have the ID you can indeed always query for that later
2014-01-13 01317, 2014
Mattx
I'm doing so with a different query...
2014-01-13 01330, 2014
Mattx
mb's database is too big and complex, I'm taking what I need and caching it in a different schema in pgsql
2014-01-13 01325, 2014
Mattx
so then I can drop this DB
2014-01-13 01326, 2014
Mattx
err, drop this schema I meant (mb's schema, with over 150 tables, wtf!?)
2014-01-13 01327, 2014
Mattx
xD
2014-01-13 01348, 2014
Mattx
reosarevok, can you think of any way to limit the recordings to those in the earliest release for each release_group?
2014-01-13 01345, 2014
Mattx
I couldn't find out how to filter the recordings like that
2014-01-13 01347, 2014
santiissopasse joined the channel
2014-01-13 01328, 2014
derwin
mb's schema.. highly normalized
2014-01-13 01323, 2014
Mattx
yep, I mean, it's really awesome and well designed
2014-01-13 01344, 2014
Mattx
but I'm using only 10% of it, so I'm caching results and dropping the rest
2014-01-13 01307, 2014
Nyanko-sensei joined the channel
2014-01-13 01315, 2014
santiissopasse joined the channel
2014-01-13 01304, 2014
HibiscusKazeneko joined the channel
2014-01-13 01331, 2014
HibiscusKazeneko
my dad made a normally-delicious dinner, but my stomach is acting up
2014-01-13 01346, 2014
KillDaBOB joined the channel
2014-01-13 01339, 2014
peaveyman joined the channel
2014-01-13 01306, 2014
d4rkie joined the channel
2014-01-13 01351, 2014
kepstin-laptop_ joined the channel
2014-01-13 01316, 2014
JonnyJD joined the channel
2014-01-13 01351, 2014
johnb003 joined the channel
2014-01-13 01343, 2014
STalKer-X_r joined the channel
2014-01-13 01353, 2014
Mattx joined the channel
2014-01-13 01354, 2014
Mattx joined the channel
2014-01-13 01321, 2014
Wixy joined the channel
2014-01-13 01346, 2014
JesseW joined the channel
2014-01-13 01337, 2014
HibiscusKazeneko
just had to put duct tape on my charger due to split rubber
2014-01-13 01354, 2014
HibiscusKazeneko
it annoys me how poorly designed and overpriced these things are
2014-01-13 01320, 2014
ticklish joined the channel
2014-01-13 01304, 2014
ticklish
Hi
2014-01-13 01343, 2014
ticklish
By any chance does anyone know about the acoustic fingerprinting for releases?
2014-01-13 01323, 2014
ticklish
As in how to create that from CDs, or info from the MB database?
2014-01-13 01336, 2014
ticklish
Okay, is anyone out here, or is everyone else otherwise engaged?
2014-01-13 01343, 2014
derwin
sigh
2014-01-13 01301, 2014
HibiscusKazeneko
need something, derwin?
2014-01-13 01330, 2014
flamingspinach
he was probably just sighing at the impatience of *!*@gateway/web/*
2014-01-13 01342, 2014
zas joined the channel
2014-01-13 01357, 2014
HibiscusKazeneko
I'm not sure what that is
2014-01-13 01336, 2014
ianweller
HibiscusKazeneko: someone joined from web irc, asked a question, and quit 4 minutes later
2014-01-13 01343, 2014
HibiscusKazeneko
I know
2014-01-13 01349, 2014
HibiscusKazeneko
I couldn't get to him in time
2014-01-13 01351, 2014
ianweller
*!*@gateway/web/* refers to the hostmask
2014-01-13 01331, 2014
HibiscusKazeneko
hmm
2014-01-13 01320, 2014
d4rkie
HibiscusKazeneko: cheap rubber
2014-01-13 01326, 2014
d4rkie
good cables, though
2014-01-13 01346, 2014
HibiscusKazeneko
yeah, the cable itself appears fine
2014-01-13 01354, 2014
d4rkie
I have mine rubberless for a year now and it still works
2014-01-13 01358, 2014
HibiscusKazeneko
it might be coming unwound, but at least it isn't frayed yet
2014-01-13 01306, 2014
d4rkie
I just duct-taped the parts I'm touching
2014-01-13 01317, 2014
HibiscusKazeneko
do you still cover the wires so they don't catch anything on fire?
2014-01-13 01329, 2014
d4rkie
12v
2014-01-13 01335, 2014
d4rkie
what fire?
2014-01-13 01354, 2014
HibiscusKazeneko
one previous charger I had became discolored over time
2014-01-13 01309, 2014
HibiscusKazeneko
I was worried that the combination of heat and exposed wires would produce sparks
2014-01-13 01351, 2014
simukis_ joined the channel
2014-01-13 01326, 2014
HibiscusKazeneko
BTW this charger outputs 20V
2014-01-13 01338, 2014
HibiscusKazeneko
the last one was lower, I'm not sure by how much
2014-01-13 01341, 2014
d4rkie
not sure how much fire I can make out of 12-20V
2014-01-13 01309, 2014
HibiscusKazeneko
plenty if you leave an unattended book, sock or something near an exposed wire
2014-01-13 01314, 2014
d4rkie
just dust
2014-01-13 01318, 2014
danoply joined the channel
2014-01-13 01356, 2014
Jinx joined the channel
2014-01-13 01320, 2014
simukis_ joined the channel
2014-01-13 01318, 2014
danoply joined the channel
2014-01-13 01301, 2014
simukis_ joined the channel
2014-01-13 01359, 2014
HibiscusKazeneko
I gotta get some sleep. Night all
2014-01-13 01302, 2014
HibiscusKazeneko has left the channel
2014-01-13 01355, 2014
hilikus joined the channel
2014-01-13 01311, 2014
hilikus
Hi all, I am looking for some help. I have this error after upgrading to the new version (schema 19)
2014-01-13 01314, 2014
hilikus
Caught exception in MusicBrainz::Server::Controller::Root->index "Failed query:
2014-01-13 01324, 2014
hilikus
DBD::Pg::st execute failed: ERROR: relation "release_name" does not exist LINE 7: FROM release JOIN release_name name ON release.name=na... ^ at lib/Sql.pm line 83.
2014-01-13 01320, 2014
nikki
how did you upgrade? that sounds like the code is out of date since it's looking for a table which was removed in the schema change
2014-01-13 01352, 2014
nikki
(also #musicbrainz-devel might be better)
2014-01-13 01319, 2014
hilikus_ joined the channel
2014-01-13 01300, 2014
hilikus_
@Nikki thanks. I am following the update instructions - git fetch origin, git checkout <latest-git-tag>. then, carton exec -Ilib -- ./upgrade.sh
2014-01-13 01341, 2014
nikki
hm, not sure then :/
2014-01-13 01312, 2014
nikki
I'd suggest asking in #musicbrainz-devel, since the people who might have the answer pay more attention there, although it's quiet right now, not sure if anyone else is around
2014-01-13 01301, 2014
hilikus_
yeah. Agree! thanks for being a help mate. :)
2014-01-13 01313, 2014
bitmap
hilikus_: what url are you fetching the code from? 'git remote show origin' should say either github or bitbucket
okay, that's good then :) what does 'git rev-parse HEAD' say?
2014-01-13 01350, 2014
hilikus_
b32b2fc23ebb11d50888ea0969d9e2bf27c0a9e2
2014-01-13 01312, 2014
hilikus_
that's the result. btw, thanks for looking into it. :)
2014-01-13 01349, 2014
bitmap
hm, that would indicate the code is up to date at least
2014-01-13 01310, 2014
bitmap
did you restart the server after updating? :) ianmcorvidae might have more ideas but he's in #musicbrainz-devel
2014-01-13 01345, 2014
hilikus_
I didn't restart yet. will going to reboot now. thanks
2014-01-13 01322, 2014
SultS joined the channel
2014-01-13 01333, 2014
hilikus_
bitmap: I believe the upgrade steps I've performed was right. But when I roll back DB schema sequence to 18 everything works fine.
2014-01-13 01338, 2014
ruaok joined the channel
2014-01-13 01345, 2014
hilikus_
bitmap: I changed it back to 19 so that code base and database are all 19. After that, I can update the slave now without any issue. I think restarting my instance resolved the issue. thanks
