was there cover art on that site? We could link some into musicbrainz ;)
2011-03-01 06036, 2011
ruaok groans
2011-03-01 06053, 2011
nikki
why is it painful?
2011-03-01 06034, 2011
ruaok
the entire concept of the cd index was painful.
2011-03-01 06059, 2011
ruaok
I'm giving a talk about OSS/MB at Cal Poly on thu.
2011-03-01 06002, 2011
ruaok
from my notes:
2011-03-01 06007, 2011
ruaok
" When Slashdot asked what the replacement for CDDB was, I finished a rough version of the index and it was slashdotted. It tipped over and failed."
2011-03-01 06016, 2011
ruaok
"- A craptastic community evolved from the screaming bitches that streamed in from Slashdot."
2011-03-01 06041, 2011
ruaok
a slashdot borne community is *not* what you want. :)
2011-03-01 06055, 2011
nikki can imagine
2011-03-01 06009, 2011
dinog1 joined the channel
2011-03-01 06038, 2011
djce joined the channel
2011-03-01 06059, 2011
nikki prods ocharles_
2011-03-01 06040, 2011
nikki
ruaok: problem on test is back
2011-03-01 06048, 2011
ruaok
which one. :)
2011-03-01 06051, 2011
warp
postgresql is eating 100% cpu
2011-03-01 06052, 2011
nikki
Caught exception in MusicBrainz::Server::Controller::Root->begin "DBD::Pg::st fetchrow_array failed: no statement executing at /home/musicbrainz/perl5/lib/perl5/Catalyst/Plugin/Session/Store/DBI.pm line 32."
2011-03-01 06024, 2011
nikki
it's the one ollie wanted to look at, wasn't it?
2011-03-01 06028, 2011
nikki
but I bet he's not here now :P
2011-03-01 06046, 2011
ruaok
this is a new one. postgres has not previously taken 100%.
2011-03-01 06050, 2011
nikki
oh
2011-03-01 06058, 2011
nikki
it's the same error message at least
2011-03-01 06014, 2011
ruaok
yeah.
2011-03-01 06033, 2011
ruaok
that we should leave to ocharles.
2011-03-01 06039, 2011
ruaok
let me see what pg is doing though.
2011-03-01 06027, 2011
ruaok
thats the newfangled empty artists query running.
2011-03-01 06047, 2011
ruaok
uhm. ya. that query needs to be split up into something more sane.
2011-03-01 06042, 2011
ruaok
its only been going a measley 15 hours. should finish any moment now.
2011-03-01 06050, 2011
nikki
whoa
2011-03-01 06015, 2011
ruaok
processor hours. probably has been running longer in wallclock time
ocharles: I wasn't trying to bust your chops on MBS-1557. I was just trying to figure out why hobbes was running old code.
2011-03-01 06005, 2011
ruaok
sorry about, that. :(
2011-03-01 06011, 2011
ocharles_
no problem :)
2011-03-01 06014, 2011
ruaok waves to nikki
2011-03-01 06021, 2011
ocharles_
where were you running it from?
2011-03-01 06034, 2011
ocharles_
~musicbrainz/musicbrainz-server should have next on
2011-03-01 06037, 2011
ruaok
it was running on hobbes. from cron
2011-03-01 06044, 2011
ruaok
thats why I was confused.
2011-03-01 06011, 2011
ruaok
but the only thing that could've happened is that the cron job ran, then the code was updated and some hours later I came and killed it
2011-03-01 06020, 2011
ocharles_
yea, that's a possibility
2011-03-01 06028, 2011
ocharles_
i cat'ed it earlier though and it looks right now
2011-03-01 06045, 2011
ocharles_
re db backed sessions, I'm not having much luck
2011-03-01 06049, 2011
ruaok
have you run that script by hand on hobbes?
2011-03-01 06058, 2011
ocharles_
nope, only locally
2011-03-01 06010, 2011
ruaok
not much luck in which way?
2011-03-01 06029, 2011
ocharles_
i couldn't work out what was happening. looking at the logs the fastcgi processes were dying and restarting
2011-03-01 06029, 2011
ruaok
I saw that it died again last night. in a very particular and worrysome way,
2011-03-01 06045, 2011
ocharles_
and when I checked ps only 1 session db connection was open, 2 raw data, and 5 readwrite were open it
2011-03-01 06048, 2011
ocharles_
should be 5 of each
2011-03-01 06017, 2011
ruaok
do you know which module might be at fault?
2011-03-01 06037, 2011
ocharles_
Well, I can only imagine it's Session::Store::DBI, but when I asked in #catalyst I didn't get much of a response
2011-03-01 06039, 2011
ocharles_
I may try the ML
2011-03-01 06048, 2011
ruaok
please do.
2011-03-01 06052, 2011
ocharles_
I tried Memcached sessions in the meantime, and that also seems to be useless
2011-03-01 06054, 2011
ruaok
this would be an excellent thing to have working.
2011-03-01 06055, 2011
nikki
ocharles_: hm... I don't understand the change you made for the youtube urls, it doesn't seem to do anything different
2011-03-01 06001, 2011
ocharles_
after a few hours sessions immediately expired
2011-03-01 06012, 2011
ruaok
lame.
2011-03-01 06029, 2011
ocharles_
nikki: yea, I've just noticed I forgot the ?
2011-03-01 06031, 2011
ocharles_
bah.
2011-03-01 06012, 2011
nikki
what's the point of having it there if it's optional?
2011-03-01 06018, 2011
nikki
and you didn't update the other youtube regex
2011-03-01 06035, 2011
ocharles_
eww, duplication
2011-03-01 06048, 2011
ocharles_
time to fix that so I don't make that mistake again
2011-03-01 06045, 2011
ocharles_
ruaok: so options are to keep trying to figure out why dbi backed sessions aren't working, look into writing our own session store driver, or look at using memcached/redis/something else
2011-03-01 06000, 2011
ocharles_
memcached is nice but the moment it runs out of space it starts expiring sessions
2011-03-01 06005, 2011
ocharles_
redis could be a good middleground
2011-03-01 06016, 2011
ocharles_
but it's more server software to run
2011-03-01 06024, 2011
ruaok
my order of preferences:
2011-03-01 06031, 2011
ruaok
1. debug the DBI session store.
2011-03-01 06036, 2011
ruaok
2. tinker with memcached.
2011-03-01 06040, 2011
ruaok
3. seek something else.
2011-03-01 06058, 2011
ruaok
for #2, we could run a separate instance in memcached that did nothing but sessions and was tuned for that.
2011-03-01 06008, 2011
ruaok
that would be easy to try too.
2011-03-01 06018, 2011
ocharles_
that could work
2011-03-01 06018, 2011
ruaok
just run another copy on another port and turn it to what you need.
2011-03-01 06030, 2011
ruaok
thats easy to try.
2011-03-01 06034, 2011
ocharles_
yea
2011-03-01 06043, 2011
ruaok
s/turn/tune
2011-03-01 06026, 2011
ocharles_
hrm, I think I know why memcached was failing... turns out the default expiry time is 0
2011-03-01 06058, 2011
ocharles_
no, no it isn't, it's 86400. hrm.
2011-03-01 06040, 2011
ruaok
it could be full.
2011-03-01 06050, 2011
ruaok
how much ram is allocated to it?
2011-03-01 06051, 2011
ocharles_
i think it may well be that problem
2011-03-01 06056, 2011
ocharles_
no idea, I haven't configured it at all
2011-03-01 06009, 2011
ruaok
memcached will give you all sorts of stats.
2011-03-01 06024, 2011
ruaok
restart memcached and what what it does over time.
