#musicbrainz-devel

Swarup: you can run the update script which has that function I think.

Swarup: see the conversation here: http://chatlogs.musicbrainz.org/musicbrainz-dev...

which update script?... admin/sql/updates/20120731-constrain-catno-whitespace.sql - i don't see this in my sandbox

should i just run CreateFunctions.sql

ha nm..i see it ..sorry..

i got this error during install of that script: admin/sql/updates/20120731-constrain-catno-whitespace.sql .... https://gist.github.com/9e937b86cd6a4ae7ceb6

is that ok to continue

warp: as far as I can tell, that script is only for master servers

luks: ok

luks: do you have an suggestions on how Swarup should continue?

I guess creating just the functions from that script will work

but I never managed to run the whole upgrade process, so I'm not sure

ok let me try that..but i would expect others to have issue ..right?

after hitting the postgresql 8.4 issue I gave up

Swarup: yes, everybody I've seen trying to upgrade today ended up with a reimport instead :)

hmm

ok probably that's safer in anycase..let me go that route..

it seems that creating the functions should work though

Swarup: we're trying to get a fix for the 8.4 problem out. but a reimport will likely be faster. :(

ruaok: note that this was not the array_agg/ORDER problem

ah.

things looked so promising yesterday. :(

we're on posgres 9 i believe..i just loaded those missing functions manually...running it now..if it still fails will go with re-import

good. then you should be fine, Swarup

ruaok: both machines here upgraded without trouble yesterday. but that's with the friday dump on ubuntu supplied 9.x.

same here.

but I should've gone with the stock 8.4 pg install for my testing.

I've noted the problem in the migration doc, so we that do our testing with the lowest version of pg supported

ruaok: in the months leading up to the schema change we should perhaps ping our customers and ask what postgres they're running exactly.

that will give us a better idea which versions are important to test.

yeah.

I think for the next release we should specify a min of 9.x.

Rob..do u recommend to upgrade search server too along with api servers for this patch..

I think once I start the schema change process on feb 1, I will mail our customers and tell them that.

obviously that's easiest for us, we're all on 9.x anyway. I don't know how easy it is for customers to upgrade.

Someone mentioned debian stable has 8.4

Swarup: can't hurt. the upgrade is easy -- you just need to put a new war in place for the search servers.

reosarevok: debian stable is also ancient

ok will do..thanks

good luck Swarup

ruaok: if we still have a few customers on 8.4 we can perhaps support a (re)import on 8.4, but not upgrade.

Sure, but I imagine some people prefer "stable" to "new", especially companies

reosarevok: there _should_ be a new debian stable in february.

No real reason why I couldn't update my VM with MB server to testing though

That's all it does.

oh, I need to get a new VM going too.

ruaok: I think I mentioned this last time, but if you could create a second disk and mount it for postgres it'd help people

Make it much easire when you run out of space.

easier

yes.

and then we could put out data updates without having to update everything else.

That's true.

1GB root and then a 10GB /mnt/db or something?

Something like that sounds good.

A dynamic disk will mean the second bit will only be as big as the data on it and can grow as necessary

should I do a 64bit or 32 bit install?

32bit seems safer.

Yeah, a lot of linux installs are still 32 bit these days (mine included).

I plan on changing that next time I reinstall though.

You can run a 32bit VM on both a 32bit and 64bit machine. I'm not sure a 32bit host can run a 64bit guest yet.

warp: I don't think mine can.

I often do that (64bit vm on 32bit host)

for building

Depends on the processor and VM software I think luks

a 32bit os with a 64bit processor with hardware virtualization can run a 64bit guest

kepstin-work: I don't think my atom can though :)

adhawkins: yeah. requires hardware virtualization extensions; atom doesn't have that.

kepstin-work: looks like a 32bit os on a 32bit CPU can also run 64bit guests if the CPU has the appropriate VT support.

warp: that's what I said.

er, wait, no

it has to be a 64bit cpu

a 32bit cpu can't run 64bit programs no matter what, unless you do slow software emulation.

I think I'll just continue with a 32bit one for now.

but you also get 64bit pointers that you don't need

in general, having double the registers gives you more performance than you lose by having bigger pointers

a few unusual cases don't.

All good.

(this is what that 'x32' stuff recently added to linux is supposed to work around - keep the extra registers, but keep using short pointers)

aren't larger pointers useful when you have >4GB ram?

warp: most userspace programs don't need >4gb ram

but those that do, really do.

(I have no idea how much overhead PAE is)

warp: pae only lets the kernel spread processes out over more ram. processes are still individually limited to 4gb

er, closer to 3gb in most setups, really.

right.

so your gimp example would suffer badly on a 32bit os.

yep

you could run a 64bit kernel with mixed 32bit/64bit userspace

but then you have a ram and cache penalty, because some shared libraries can't be shared between the two.

kepstin-work: Isn't that the most common scenario for people running 64-bit kernels?

Freso: most linux installs use 64bit kernel with mostly-64bit userspace

I wouldn't expect libraries to use a significant amount of memory compared to the data you're processing.

I know I have a fair share of lib32 packages installed.

notable exceptions are wine and proprietary applications that are 32bit only

kepstin-work: But if it's "mostly-64bit userspace", is it not then also mixed? :)

warp: instruction cache penalties when multitasking hurt - the more shared code, the better :)

kepstin-work: Actually, Wine can be 64bit now too.

Freso: 64bit wine can only run 64bit windows programs

kepstin-work: If you compile it to be. But its support isn't very good, even for Wine standards, yet.

you need 32bit wine for 32bit windows programs (i.e. almost all of them)

gentoo and some others do a multibuild wine that installs both 64bit wine and 32bit wine together.

Arch \o/

windows is more or less the other way - the kernel is 64bit, but most programs are 32bit with a few exceptions.

I think some newer versions of e.g. photoshop might have 64bit versions?

windows is for steam, and not much else. :)

kepstin-work: I was merely commenting on how "mixed" was the most likely scenario. Not the degree of "mixed". :)

either way, my desktop has 12gb ram, and I can use large amounts of that for processing big scans in the gimp :)

Freso: yeah; although I did actually run my laptop pure-64bit for a while

before I installed wine

Yeah. I need more RAM, I've realised. :)

* :|

I thought I needed more RAM

Since I've begun pushing a lot of filesystem paths into hourly sync'd tmpfs file systems...

For something silly like $120, I can put 24gb ram in my desktop.

I've always been fine on the desktop with 4GB, but after replacing debian with ubuntu I started to have some trouble after a few weeks.

well, that's ubuntu :/

I never had the need for that much ram on a desktop machine

so I went out and bought another 4GB, installed it, and now I'm back to less than 3GB usage. turns out it probably just needed a reboot.

Haha.

luks: you've never had the opportunity to extract raw cd audio to a ramdisk then encoding it :)

(obviously a reboot is required for installing memory :)

Yeah, I thought I'd be good with 8 GB. Before I started pushing stuff into tmpfs's.

most compiling I do is on tmpfs as well

I can compile libreoffice completely in ram :/

lol

All compiling I do is on tmpfs. :p

well, most of the day all I need it a browser, music player and terminal with ssh, don't need much ram for that :)

But then, I don't compile LO.

ram is for the servers I ssh to

at this point tho, I probably use my laptop more often than my desktop

and my laptop only has 4gb.

luks: I'm on the same page with you there.

my laptop hardly ever does any work. but the machines I ssh to, lots.

since I switched to gnome 3, I often feel sad then I alt+tab and see only three/four icons there :)

it made me realize how much I really use the laptop

luks: there's an extension if you want to see separate icons for your terminal windows :)

it might make you feel better.

heh, when I'm working on non-musicbrainz projects the machine I SSH into does most of the work as well.