#musicbrainz

have to edit with the debug inspector on atm in case ajax posts fail

down again :x

so it's not just me

nope

hello TheBikeGuitarist

hi hibiscuskazeneko

we're just passing time here since MB is slow as molasses

i will just go back to sleep :x

I've been polishing and waxing my bicycle six to eight hours every day the past two weeks. I do that about once every six years.

touched up paint etc.

most guitarists have big speakers with tiny wheels. My bicycle with the amp strapped to rear rack is like a tiny speaker with big wheels. It is a "riding amplifier" sort of like a riding lawnmower lol.

neat

do you power the amp by pedaling?

no, it has six AA batteries that last more than 20 hours loud enough to play with drums

Roland MicroCube amp.... really nice sounds... many options but I picked a sound I like and almost all my songs have that same setting

plus when you witness me perform on the bicycle live riding circles in front of you, you get a Doppler effect from the varying distances and directions of the sound

not like you can adjust it while riding, can you?

not safely really nope

didn't think so

but I never go fast, first gear all the time, so no big deal to stop and re-set the amp if I wanted to (but I don't....I like the sound I picked)

it is clean channel with some tone, very light reverb, and just the start of phase shifter for a slow sweep

that's the tone of the bicycling guitarist past few years since I got the Roland amp

been playing that pickup switch position for decades though

sometimes my hand in sweeping windmills will accidentally knock the switch to bridge pickup...sometimes that adds to the song and makes it better

several of my youtube videos have that type of thing going on, where sounds "just happen" that are not planned

so maybe at a higher level of consciousness I *am* planning it lol, but there are no thoughts while I play...just music flowing through me and out my fingers

bye for now have fun

see you

anyway, I do have a script running to check urls and store info about it locally, it doesn't remove ones which appear to be broken from mb though

partly because some sites suck and will claim something is a 404 when it isn't really

I do have another script which I run from time to time to update urls which are redirecting to another sufficiently similar url though

some sites blocked me though :P

ruaok: sup? :)

MB, for a change.

shh, don't jinx it

ruaok since when? :D

does anyone know where musicbrainz picard pulls the genre tags from when you enable "folksonomy tags"?

there's a bunch I want to fix

I cant see anywhere to amend them on the MB website so guessing their external?

I’m going to build some new indexes while things are quiet. (no recording indexes though)

what do you say about the title of this album? http://musicbrainz.org/release/2c0684b5-6137-4d...

the cover looks like this http://a5.mzstatic.com/us/r30/Music/v4/54/2c/2e...

one track is written using japanese, hence i think the title of the album also should be “Hearts 日本”

rather than Hearts Japan EP

nope. started index builing and load shot to 100.

no indexes, sorry.

New post: blog: Postgres troubles <http://blog.musicbrainz.org/2015/03/15/postgres...;

one thing about postgres, do you have the autovaccum daemon enabled / have you analysed the database recently?

ruaok looks like nginx stats are off? o.o

dns53: autovacuum is enabled.

well my quick guess is the statistics are wrong and decides to choose the wrong optimisations ie wrong index or wrong order in performing actions

you can fix this by analysing the table again so it has a better guess of what order things should e done

doing a full vacuume will fix this but this locks the database so it has consiquences

you could analyze each table one by one to make sure everything is up to date

but this uses a lot of cpu / io so it will make things worse before it gets better

we’d do a full downtime for that.

worth tryinng.

I am a dba but i work in oracle so i know the general principals but i'm not an expert in postgres

so what can happen is the database needs to join two tables, does it look at the first table and join the results to the second, or look at the second and join to the first

the difference can be big, and the database uses statistics to make a guess at what option is most likely better

working out what is better could theoretically be calculated but this could take longer than running the query so it has to make educated guesses

if you have 31+ joins it would take more than the heat death of the universe to work out what of the possible combinations of order would be better

understood. but this has never happened to us before — why now??

any database can go the same way, it may have now decided to use or not use an index that it did before

say you have a table with 1000000 rows and you delete all but 10, if the statistics are wrong it will still think the rows are still there

dns53: understood.

but we haven’t made any drastic changes like that.

still, I understand that these hidden thresholds are everywhere

hello guys

im having a problem with accessing musicbrainzvm:8080 from the virtualbox-2014-05-14

searching on musicbrainzvm:5000 works perfectly

on port 8080 i only managed to get it worked localy

i tried to change jetty to listen to all traffic but doesnt seem to work

do u have any idea what i could do wrong

and so i can access 8080 from my host?

I could use some votes on http://musicbrainz.org/edit/32140490 and http://musicbrainz.org/artist/28f5ef49-1192-480... so I can finish cleaning up these artists.

any help really really appreciated :)

I think you need to configure port forwarding from the vm to your host system as well, otherwise jetty can listen as much as it likes but the hypervisor doesn't forward any packets to it

does anyone know why i can’t add new releases? get this error message Caught exception in MusicBrainz::Server::Controller::ReleaseEditor->add "CGI param clash for mediums.0.track.-1.name=-1 at lib/MusicBrainz/Server/Controller/ReleaseEditor.pm line 111"

using the add cluster as release plugin for picard

ok mineo i will check that weird that port 5000 is working though

that seems like a problem with the plugin

I'm guessing the files have no track numbers or something

guigui_: yes, that's preconfigured

:)

ah true

i see it

sorry

not an expert

oh mineo

thank you so much

its fixed

how come it is not preconfigured for 8080

too?

could make sense

thx again u made my sunday :P

nikki: hmm, they all have 0 as track number

hibiscuskazeneko | now to check for more (I know of a few other cities that stretch across the county line) - please report these at http://tickets.musicbrainz.org/browse/AREQ :)

They're already in the database: are tickets even necessary?

the ticket tracker is for tracking issues in general, not only for requesting new things :)

plus the tickets will be there to remind people later if they don't have time to deal with it there and then

^