gm ppl do we have some ppl awake may be able to help me with LoadReplicationChanges ERROR: duplicate key value violates unique constraint "artist_gid_redirect_pkey"
2013-11-01 30514, 2013
ijabz joined the channel
2013-11-01 30542, 2013
JonnyJD_
Lewis: my guess is that there is a problem in the DB you got there
2013-11-01 30523, 2013
JonnyJD_
finding and deleting that duplicate might help
2013-11-01 30535, 2013
JonnyJD_
(as in: per sql)
2013-11-01 30520, 2013
Lewis
JonnyJD_: not able to find the key already exists. at /home/musicbrainz/musicbrainz-server/admin/replication/../../lib/Sql.pm line 107.
2013-11-01 30523, 2013
daveh
are you running a VM or did you do all the install yourself?
2013-11-01 30526, 2013
ocharles
Right, lets see if I can get this lazy loading for /release working
2013-11-01 30513, 2013
Lewis
Install.md
2013-11-01 30520, 2013
reoafk joined the channel
2013-11-01 30554, 2013
Lewis
I guess it will be one of them days after looking on google for help then come to mbdevel and still not help
2013-11-01 30557, 2013
JonnyJD_
Lewis: maybe try and delete all artist_gid_redirects? (not sure if you need it, but that is probably fixed with replication again)
2013-11-01 30530, 2013
nikki
replication doesn't recreate the entire table
2013-11-01 30511, 2013
JonnyJD_
well, then you have to find the exact entries that have a duplicate primary key
2013-11-01 30518, 2013
nikki
and imo if you're getting errors like that, you've managed to end up with a messed up db and should reimport it
2013-11-01 30550, 2013
JonnyJD_
hm, probably also easier, since it is unattended
2013-11-01 30500, 2013
rolo joined the channel
2013-11-01 30525, 2013
Lewis
nikki: you saying it may be best to dump and reimport
2013-11-01 30554, 2013
nikki
yes
2013-11-01 30537, 2013
Lewis
kk thanks well i guess that will be job for later tonight i have real job to get to
2013-11-01 30545, 2013
rolo has left the channel
2013-11-01 30511, 2013
Jozo
Nice. iTunes api returns error gzipped but normal response plain text... :/
2013-11-01 30547, 2013
Lewis
thanks Jozo for help last nite it made things work if i install ubuntu libjson-xs-perl first
2013-11-01 30512, 2013
ocharles
I've just pushed my original MBS-3841 branch out onto beta
JonnyJD_: That covers it basically, though what I did was just copy the files in the bin directory to the base picard directory. Adding th the path is probably a better choice for anything that needs gettext.
2013-11-01 30515, 2013
ruaok
reosarevok: done
2013-11-01 30536, 2013
JonnyJD_
yeah, copying the binaries is also an option, though adding things to the path is "the usual way to go"
2013-11-01 30559, 2013
snartal
I would agree
2013-11-01 30549, 2013
snartal
The only other thing I would say is since its in a paragraph, dense winders users like me who have new to this stuff have a harder time parsing it, where a the bulleted items above help break it apart mentally.
2013-11-01 30533, 2013
JonnyJD_
hm, didn't want to make a "big fuzz" with more bullets, but maybe I should do that
2013-11-01 30556, 2013
snartal
Maybe it clogs it up for the experienced folk, but for me, I know it helps.
2013-11-01 30532, 2013
JonnyJD_
snartal: well, the experienced folks don't need instructions anyways :-P
2013-11-01 30526, 2013
snartal
Also thanks again for your help. You and all the other folks who help me out are priceless. Answering our questions saves us hours and hours of aimless searching of the web. I, my desktop, and my drywall thank you!
