ocharles: do you have any idea what's going on with the edit note ISE? (the ones where an edit cannot be submitted because of: insert or update on table "edit_note" violates foreign key constraint "edit_note_fk_edit")
oh, I guess it's trying to add an edit note to an edit which failed.
pecastro joined the channel
ocharles
It'll only happen with auto-edits, and it's because the edit is automatically applied, but the error code wants to add the edit note
warp: This auto-applied business bit me yesterday, I think we could really simplify things if we make it insert the edit open, and then immediately accept it
kepstin-laptop joined the channel
ijabz_ joined the channel
kepstin-laptop joined the channel
reosarevok joined the channel
pecastro joined the channel
warp
ocharles: insert + accept sounds like less code paths than applying it immediatly, so sounds like a good idea to me.
of course, new warnings to fix, but i'll let you get back to work first
warp
haha, ok
ijabz
So luks I already have a musicbrainz db created with data from a few months ago do I was wondering if I could just use that with your replication stuff or whether I need to build from scratch
pecastro joined the channel
luks
ijabz: how did you import the data?
ijabz
Using pgsql from the dumps
luks
well, if you imported all tables (including replication_control) then you should be able to do that
ijabz
Maybe I should start from scratch, I suppose if new database is in schema I should due able to create it without deleting my current one
luks
but it might be faster to reimport, as the replication is not particularly fast if you are a few months behind
ijabz
(i didnt do replication control)
luks
just create the structure as you would do manually
and use mbslave-import.py to load the latest data dump
that's probably the easiest way
ijabz
Mine is a bit hand crafted, Im gonna try your way, at least gives it another test
luks
well, the reason why I created mbslave was that I needed the schema to be a bit hand crafted :)
you can do things like ignore tables you don't want
Leftmost joined the channel
ijabz
Weird, even though I have postgres running it won't let run any of the postgres commands complaing
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
luks
wrong permissions on the ticket?
the default is 0777, but perhaps it's changed in your postgresql.conf
er, socket, not ticket :)
ijabz
No, it was set to 0777, but commented out I removed the # anyway, restarted server and no difference
But my pgadmin guy woks fine
works
luks
doesn't it connect through the TCP socket on 127.0.0.1?
ijabz
no idea, but funnily enough psql also fails but ./psql works, yet ./createuser doesn't work
ah, doh, I have two copies of the commands
the default in is /usr/local/bin and a working set in /usr/local/pqsql/bin
ocharles
warp: I have another batch of fixes :)
reosarevok
What are you fixing?
Modbot stuff?
ocharles
no, the edit queue is fine atm
I'm just fixing warnings so I can read the logs
first step of many to actually get the logs usable
ijabz
luis mb-slave-import.py gave me ImportError: No module named psycopg2