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")
2011-09-15 25848, 2011
warp
oh, I guess it's trying to add an edit note to an edit which failed.
2011-09-15 25833, 2011
pecastro joined the channel
2011-09-15 25818, 2011
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
2011-09-15 25840, 2011
ocharles
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
2011-09-15 25812, 2011
kepstin-laptop joined the channel
2011-09-15 25851, 2011
ijabz_ joined the channel
2011-09-15 25817, 2011
kepstin-laptop joined the channel
2011-09-15 25813, 2011
reosarevok joined the channel
2011-09-15 25856, 2011
pecastro joined the channel
2011-09-15 25841, 2011
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
2011-09-15 25837, 2011
warp
haha, ok
2011-09-15 25825, 2011
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
2011-09-15 25834, 2011
pecastro joined the channel
2011-09-15 25834, 2011
luks
ijabz: how did you import the data?
2011-09-15 25804, 2011
ijabz
Using pgsql from the dumps
2011-09-15 25801, 2011
luks
well, if you imported all tables (including replication_control) then you should be able to do that
2011-09-15 25816, 2011
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
2011-09-15 25822, 2011
luks
but it might be faster to reimport, as the replication is not particularly fast if you are a few months behind
2011-09-15 25839, 2011
ijabz
(i didnt do replication control)
2011-09-15 25859, 2011
luks
just create the structure as you would do manually
2011-09-15 25810, 2011
luks
and use mbslave-import.py to load the latest data dump
2011-09-15 25820, 2011
luks
that's probably the easiest way
2011-09-15 25805, 2011
ijabz
Mine is a bit hand crafted, Im gonna try your way, at least gives it another test
2011-09-15 25836, 2011
luks
well, the reason why I created mbslave was that I needed the schema to be a bit hand crafted :)
2011-09-15 25856, 2011
luks
you can do things like ignore tables you don't want
2011-09-15 25831, 2011
Leftmost joined the channel
2011-09-15 25839, 2011
ijabz
Weird, even though I have postgres running it won't let run any of the postgres commands complaing
2011-09-15 25849, 2011
ijabz
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
2011-09-15 25808, 2011
luks
wrong permissions on the ticket?
2011-09-15 25836, 2011
luks
the default is 0777, but perhaps it's changed in your postgresql.conf
2011-09-15 25844, 2011
luks
er, socket, not ticket :)
2011-09-15 25831, 2011
ijabz
No, it was set to 0777, but commented out I removed the # anyway, restarted server and no difference
2011-09-15 25839, 2011
ijabz
But my pgadmin guy woks fine
2011-09-15 25848, 2011
ijabz
works
2011-09-15 25838, 2011
luks
doesn't it connect through the TCP socket on 127.0.0.1?
2011-09-15 25842, 2011
ijabz
no idea, but funnily enough psql also fails but ./psql works, yet ./createuser doesn't work
2011-09-15 25824, 2011
ijabz
ah, doh, I have two copies of the commands
2011-09-15 25804, 2011
ijabz
the default in is /usr/local/bin and a working set in /usr/local/pqsql/bin
2011-09-15 25803, 2011
ocharles
warp: I have another batch of fixes :)
2011-09-15 25848, 2011
reosarevok
What are you fixing?
2011-09-15 25850, 2011
reosarevok
Modbot stuff?
2011-09-15 25855, 2011
ocharles
no, the edit queue is fine atm
2011-09-15 25801, 2011
ocharles
I'm just fixing warnings so I can read the logs
2011-09-15 25807, 2011
ocharles
first step of many to actually get the logs usable
2011-09-15 25844, 2011
ijabz
luis mb-slave-import.py gave me ImportError: No module named psycopg2
