#musicbrainz

aCiD2: do you have gdb installed?

i can install it if I don't

ps aux | grep postgres

yup, got the pid

there is many process, I'm not sure which one should be used for this

+es

i can try them all :)

ok, well..

once you have the pid, run: gdb /path/to/postgres pid

that should attach gdb to the process

ok

then when it crashes, type 'bt' and it should give you a backtrace

attaching seems to stop the server, so I have to type "continue" in gdb, but then I never get back to the gdb prompt

ah wait

yea, I have to continue

hm

which pid are you using?

I'm trying it with the one that has argv[0] looking like a real command line

the main postgres one, but the others do the same (attaching prints: in __select_nocancel () from /lib/libc.so.6 then drops me back to the gdb prompt)

you need the pid which your postgres session is connected to

that should be in the proc title

and yes, you do need to type continue

then when it crashes, it will bring you back to the gdb prompt

no

the pid of the postmaster process which is serving your connection

ah

like: postgres: musicbrainz_user musicbrainz_db ?

yup

ok, I have a backtrace luks

cool

pasting now

(error is a seg fault)

hm, I wonder how to compile the extension in debug mode

maybe just `CFLAGS="-g -O0" make` should work

hm, no

So are we doing away with the separation of release group types? I.e. Instead of having separate tables, just adding a release group type column and allowing the user to sort via that.

Heh.

,,,

I never typed that.

navap: no, we are using temporary solutions during development

Ocks.

Lolc.

Okay, so does that mean that the artist page will still have multiple tables, or is it a "we'll worry about it when we get to it" kind of thing?

it means that the plan is still to do this - http://oxygene.sk/lukas/mb/

Ah right, okay :)

aCiD2: ok, so there are two problems. I'm not handling libunac errors, and libunac for some reason can't unaccent the string

So maybe my libunac installation is broke?

aCiD2: can you open unaccent.c, add PG_RETURN_TEXT_P(CStringGetTextP(GetDatabaseEncodingName())); below the unac_string line in unaccent(PG_FUNCTION_ARGS)

then make && sudo make install

and try to run unaccent(')

yup, ok

this time without gdb, it shouldn't crash

no crash, returns SQL_ASCII

hm

aha, that's probably because you have DB in the C locale

should it not be in that locale?

according to InitDb.pl it should be

can you try one more thing?

luks: yup, what else should I change?

revert the last change

and replace the unac_string line with unac_string("UTF8", input, input_len, &output, &output_len);

ok

and then run e.g. unaccent('á');

that seems to work

yup

damn

I wonder how does it manage to store 8-bit characters in ASCII :)

but I guess it's not really ASCII

I'm not sure what now

I really don't like the idea of hardcoding UTF8 there

unless it is just a problem with my database

I doubt it is

you told it to use the C locale, it does so

what does using ASCII instead of UTF-8 buy you?

I'm not sure

the check in the database initialization script was there for ages

I don't think *anybody* knows why it's there :)

do SHOW client_encoding()

in psql

with a semicolon

maybe also SHOW server_encoding();

maybe without parens

yeah

maybe that

long day :/

brb

I think Piicard may have crashed...

It's not doing anything.

Yay it's come back to life!

luks: hi

hi

luks: do you think you can provide me with the necessary stuff for a windows build of picard next week?

outsidecontext: I think I can't :(

hi ruaok, outsidecontext, and everyone else :)

wn brianfreud

but I think I should be able to build it myself

wb, that is. :)

luks: ok, that's another solution

:)

luks: i think if you could give me some directions i could figure out most stuff myself. but without anything i'm lost

luks: and hey, how was paris?

paris was great. I really needed to take a few days off :)

i can imagine that :)

regarding picard, the trickest part is to build ffmpeg

you need msys for that

Personally, I think I need a vacation from my "vacation". :D

Driving to Florida and back was... exhausting

but it didn't work out of the box last time I tried

but there is a whole site about that somewhere

how is that whole python stuff build on windows?

well, that's easy

luks: the last time i was trying to build the picard C modules they wouldn't run on windows. but i guess my compiler was not compatible with the binary python i had installed

you can use mingw, so that's fine

ok

I was using msvc for picard builds

but mingw should work without problems