<div dir="ltr">On Thu, Oct 23, 2014 at 4:55 PM, Bill Meek <span dir="ltr"><<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>></span> wrote:<br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=""><div class="h5">On 10/23/2014 03:14 PM, Anthony Brummett wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
I've switched to the new server using the /etc/hosts method using IP<br>
54.85.117.227. I'm using MythTV 0.24. I'm running mfd with this command<br>
line:<br>
mythfilldatabase --dd-grab-all -v file,network ><br>
/tmp/mythfilldatabase-newserver.log 2>&1<br></blockquote></div></div></blockquote><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class=""><div class="h5"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"></blockquote></div></div>
That's some great data collection work. The timestamp says you ran it<br>
today, so this *shouldn't* be the cause:<br>
<br>
<a href="http://forums.schedulesdirect.org/viewtopic.php?f=6&t=2599&start=70#p7985" target="_blank">http://forums.schedulesdirect.<u></u>org/viewtopic.php?f=6&t=2599&<u></u>start=70#p7985</a><br>
<br>
I'm just wondering if you've got some stale data and if it would<br>
be worth running again tomorrow before jumping in to trouble-<br>
shooting this one.<br></blockquote><div><br></div><div>Probably not. I've been trying from time to time all week, and it was failing in the same way. I ran it again today, and it's still failing with the same kind of errors. Just looking at the first failure:<br>2014-10-24 11:16:05.054 DB Error (Inserting into dd_program):<br>Query was:<br>INSERT INTO dd_program ( programid, title, subtitle, description, showtype, category_type, mpaara<br>ting, starrating, stars, runtime, year, seriesid, colorcode, syndicatedepisodenumber, ori<br>ginalairdate) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?<br>, ?, ?) <br>Bindings were:<br>:CATTYPE=series, :COLORCODE=, :DESCRIPTION=, :MPAARATING=,<br>:ORIGAIRDATE=2009-01-01, :PROGRAMID=EP000009935605, :RUNTIME=,<br>:SERIESID=EP00000993, :SHOWTYPE=Series, :STARRATING=, :STARS=0,<br>:SUBTITLE=Teams TBA, :SYNDNUM=TBA, :TITLE=College Football, :YEAR=<br>Driver error was [2/1062]:<br>QMYSQL3: Unable to execute statement<br>Database error was:<br>Duplicate entry 'EP000009935605' for key 'PRIMARY'<br><br></div><div>When I grep for 'EP000009935605' in the download data, there are 104 'schedule' tags (many, like yours). There also 2 'program' tags and 2 'programGenre' tags, where yours only has one of each. When I download from the old server, it also has only a single 'program' and 'programGenre' tags with that ID/program.<br><br></div><div>Here's the log from mfd taking to the new server with only a few of the 683 insert failures included:<br><a href="http://pastebin.com/RK86fjzc">http://pastebin.com/RK86fjzc</a><br><br></div><div>Here's the lines from the download data for 'EP000009935605' for the new server:<br><a href="http://pastebin.com/cJbpFADL">http://pastebin.com/cJbpFADL</a><br><br></div><div>Here's the lines from the download data for 'EP000009935605' from the old server:<br><a href="http://pastebin.com/zMN0Xw07">http://pastebin.com/zMN0Xw07</a><br> </div><div> <br></div><div>Let me know if you need any more information.<br>Thanks,<br></div><div>-- Tony<br></div></div></div></div>