* Ulrich Klauer: Extend the search path for sitemaps/CreateFKConstraints
2016-04-26 11724, 2016
MBJenkins
* Ulrich Klauer: MBS-8800: Add a geodetic index on place
2016-04-26 11754, 2016
dr_saunde has quit
2016-04-26 11716, 2016
drsaunde joined the channel
2016-04-26 11729, 2016
JesseW joined the channel
2016-04-26 11720, 2016
Lingo__ joined the channel
2016-04-26 11724, 2016
Lingo__ has quit
2016-04-26 11738, 2016
kanha has quit
2016-04-26 11708, 2016
Lingo__ joined the channel
2016-04-26 11746, 2016
Lingo__ has quit
2016-04-26 11715, 2016
diana_olhovik_ joined the channel
2016-04-26 11747, 2016
kanha joined the channel
2016-04-26 11759, 2016
diana_olhovik_ has quit
2016-04-26 11753, 2016
Nyanko-sensei joined the channel
2016-04-26 11709, 2016
D4RK-PH0ENiX has quit
2016-04-26 11750, 2016
Lingo__ joined the channel
2016-04-26 11750, 2016
Lingo__ has quit
2016-04-26 11750, 2016
diana_olhovyk joined the channel
2016-04-26 11745, 2016
mihaitish joined the channel
2016-04-26 11726, 2016
Lingo__ joined the channel
2016-04-26 11750, 2016
Nyanko-sensei has quit
2016-04-26 11719, 2016
D4RK-PH0ENiX joined the channel
2016-04-26 11734, 2016
jesus2099 joined the channel
2016-04-26 11724, 2016
Lingo__ has quit
2016-04-26 11758, 2016
Lingo__ joined the channel
2016-04-26 11706, 2016
JesseW has quit
2016-04-26 11702, 2016
Freso
alastairp: You get notification/mail about all new posts in the AcousticBrainz category on the forum, right?
2016-04-26 11733, 2016
rahulr
Is there a way to stop ongoing network requests in Picard. I was testing [PICARD-811](http://tickets.musicbrainz.org/browse… but couldn't find a way to halt the requests manually (except closing Picard).
2016-04-26 11703, 2016
rahulr
Shouldn't removing a file halt the ongoing requests for that.
2016-04-26 11750, 2016
rahulr
zas, or bitmap, maybe ^
2016-04-26 11717, 2016
jesus2099 has quit
2016-04-26 11721, 2016
mihaitish has quit
2016-04-26 11729, 2016
LordSputnik
ruaok: if you're flying to Gatwick, expect really, really bad trains today
2016-04-26 11751, 2016
zas
rahulr: in this case, no :( this kind of loop should be prevented somehow
2016-04-26 11726, 2016
zas
We have a redirect loop prevention code, but in this case it doesn't work, this is a part of the issues
2016-04-26 11730, 2016
zas
Though my patch will prevent it, as it removes the conditions required for it to happen
2016-04-26 11721, 2016
zas
rahulr: you mean removing the sound file(s) ? Yes, requests related to them should be stopped, but the current code doesn't handle this case afaik (at least in the context of PICARD-811), any improvement is welcome here.
2016-04-26 11736, 2016
Lingo__ has quit
2016-04-26 11710, 2016
Lingo__ joined the channel
2016-04-26 11715, 2016
ruaok
LordSputnik: yep, survived, that already
2016-04-26 11731, 2016
ruaok
#fuckingthirdworldcountry
2016-04-26 11759, 2016
mihaitish joined the channel
2016-04-26 11715, 2016
Lingo__ has quit
2016-04-26 11732, 2016
kurros has quit
2016-04-26 11752, 2016
Lingo__ joined the channel
2016-04-26 11703, 2016
Nyanko-sensei joined the channel
2016-04-26 11749, 2016
D4RK-PH0ENiX has quit
2016-04-26 11723, 2016
kurros joined the channel
2016-04-26 11724, 2016
ruaok
ahhh, now parked in shoreditch. not bad 6 hours from flat to shoreditch
2016-04-26 11740, 2016
UmkaDK has quit
2016-04-26 11715, 2016
Nyanko-sensei has quit
2016-04-26 11745, 2016
D4RK-PH0ENiX joined the channel
2016-04-26 11714, 2016
UmkaDK joined the channel
2016-04-26 11752, 2016
ibotty joined the channel
2016-04-26 11723, 2016
kanha has quit
2016-04-26 11749, 2016
Lingo__ has quit
2016-04-26 11733, 2016
UmkaDK has quit
2016-04-26 11724, 2016
ibotty has left the channel
2016-04-26 11737, 2016
UmkaDK joined the channel
2016-04-26 11759, 2016
chrisskye
ruaok: Can we make a ticket/task to add the euro account IBAN to the donate page?
2016-04-26 11749, 2016
MajorLurker has quit
2016-04-26 11718, 2016
ruaok
I've already got a personal ticket for that.
2016-04-26 11726, 2016
ruaok
though if we ask Gentlecat to do it, it might happen faster.
ruaok: I said I'd make a ticket for adding the IBAN to the meb.o page.
2016-04-26 11723, 2016
Freso
You told me not to bother.
2016-04-26 11739, 2016
zas
alastairp: did you clean up your home dir on spike ? disk usage is too high, and most of the space is used by your home dir.
2016-04-26 11737, 2016
zas
well, 280Gb in your dir, but it seems /tmp has far too much files ...
2016-04-26 11711, 2016
zas
Something is wrong on spike, temporary files aren't deleted
2016-04-26 11716, 2016
zas
i can't even list files in /tmp
2016-04-26 11711, 2016
Lingo__ joined the channel
2016-04-26 11719, 2016
KodeStar
Freso told me to ask my off topic queries about database modelling in here, so blame him not me for the following questions!
2016-04-26 11723, 2016
Freso
(For those who don't know, KodeStar is the developer of FanArt.tv, which is doing a great job at promoting MBID use. :))
2016-04-26 11736, 2016
zas
I will reboot spike, no way to list or remove files, this machine doesn't a partition dedicated to /tmp :(
2016-04-26 11715, 2016
zas
not sure how long it will take to remove files during boot process, so ... expect significant downtime
2016-04-26 11728, 2016
CJ_
zas, You may have to boot to separate media and/or log in single user mode. We have had similar problems with root filling up.
2016-04-26 11718, 2016
KodeStar
I am currently building the new database for fanart.tvI am currently building the new database for fanart.tv, the old design was just a mess it had several tables for every section (so movie_items, movie_images, movie_denied, music_artists, music_albums, music_images, etc), the new code is based on laravel which has built in support for polymorphic relationships, my conundrum is I can either have (this is what I have currently built) an images table
2016-04-26 11719, 2016
KodeStar
which has a polymorphic relationship to movies, tv, music tables which means all the data specific to those items is in the columns, or I can have 2 tables, images and media, where media can be of type tv, artist, movie, this gets a bit more complicated when you add albums in because they would need to have a many to many relationship with the artist, but is much easier in the first type
2016-04-26 11725, 2016
KodeStar
I think the way I'm building it is the right way, as the relevant data for movies could be very different to music artists, and the images themselves don't care about that
2016-04-26 11722, 2016
Freso
LordSputnik, Leftmost: ^ you two have been talking data modelling a lot lately, maybe you can provide some insight?
2016-04-26 11747, 2016
KodeStar
It's a bit more difficultto work with in a DRY way, I've created a FanartController abstract class so all the common functions can be routed through that
2016-04-26 11735, 2016
Lingo__ has quit
2016-04-26 11713, 2016
Lingo__ joined the channel
2016-04-26 11736, 2016
zas
CJ_: i think the /tmp (which is on the same partition than /) is full of unremoved tmp files), the dist should clear them up at boot time, but the process can be long.
2016-04-26 11703, 2016
zas
in the meantime i mounted a tmpfs /tmp, and it filled up immediatly
2016-04-26 11714, 2016
CJ_
zas, Understood. Our issue was /var/log which is not automatically cleared. :)
2016-04-26 11720, 2016
zas
some process is creating zillions of tmp files
2016-04-26 11740, 2016
KodeStar
is something trying to send system emails?
2016-04-26 11714, 2016
KodeStar
that can fill up /tmp
2016-04-26 11719, 2016
zas
alastairp: it is one of your scripts, dunno which one exactly yet, but something is very broken
2016-04-26 11700, 2016
Freso
zas: Maybe ruaok or Gentlecat can send him a text or something.
2016-04-26 11755, 2016
zas
Freso: i telegrammed ruaok, no answer yet
2016-04-26 11716, 2016
kanha joined the channel
2016-04-26 11703, 2016
zas
alastairp: many empty tmp files, and many json tmp files with starting with {"tonal": {"hpcp": {"max":
2016-04-26 11735, 2016
zas
i'm cleanup the mess now, but scripts need to be fixed
2016-04-26 11702, 2016
Leo_Verto
Freso, love that meeting digest
2016-04-26 11738, 2016
Freso
Leo_Verto: :)
2016-04-26 11704, 2016
zas
Freso, reosarevok : can you tweet about acousticbrainz.org being down for a while ? prolly hours.
Or "uber mess clean up attempt after broken scripts filled up 1.5Tb of disk space and lack of awareness of our sysadmin, who is naive enough to think developpers give a shit about this kind of things" :D
2016-04-26 11727, 2016
zas
Hey alastairp ;)
2016-04-26 11703, 2016
alastairp
hmm, tmp
2016-04-26 11707, 2016
zas
alastairp: situation is the following : i stopped uswgi, and killed `python validate.py' scripts
2016-04-26 11729, 2016
alastairp
I don't know about validate.py?
2016-04-26 11739, 2016
alastairp
what user was running it?
2016-04-26 11746, 2016
zas
you
2016-04-26 11751, 2016
alastairp
hmm, right
2016-04-26 11759, 2016
zas
:D
2016-04-26 11718, 2016
zas
i'm currently deleting files, it will take a looooong time
2016-04-26 11720, 2016
alastairp
tmp files are used when we read lowlevel data from the database to compute highlevel files
2016-04-26 11727, 2016
alastairp
it should cleanup after itself
2016-04-26 11736, 2016
alastairp
but if it fails, it leaves files behind
2016-04-26 11706, 2016
zas
Imho, something broke, and files started to accumulate
2016-04-26 11741, 2016
zas
I moved old /tmp to /tmp.old, but it is almost impossible to read atm
2016-04-26 11740, 2016
zas
if you start things again /tmp will filled up fast, so to prevent bad things i mounted it as tmpfs (8Gb)
