[mythtv-users] Schedules Direct DataDirect replacement service testing

[Anthony Brummett]

I've switched to the new server using the /etc/hosts method using IP
54.85.117.227.  I'm using MythTV 0.24.  I'm running mfd with this command
line:
mythfilldatabase --dd-grab-all -v file,network >
/tmp/mythfilldatabase-newserver.log 2>&1

I can see in the log that it authenticates and downloads the data just
fine, but as it's loading up its tables, there a a ton of errors like this:

2014-10-23 14:54:28.363 DB Error (Inserting into dd_program):
Query was:
INSERT INTO dd_program      ( programid,    title,
subtitle,              description,  showtype,    category_type,
mpaarating,   starrating,  stars,
runtime,      year,        seriesid,              colorcode,
syndicatedepisodenumber, originalairdate) VALUES      (?,   ?,
?,             ?, ?,   ?,              ?,  ?, ?,
                ?,     ?,       ?,             ?,   ?,    ?)
Bindings were:
:CATTYPE=series, :COLORCODE=, :DESCRIPTION=, :MPAARATING=,
:ORIGAIRDATE=2009-01-01, :PROGRAMID=EP000009935605, :RUNTIME=,
:SERIESID=EP00000993, :SHOWTYPE=Series, :STARRATING=, :STARS=0,
:SUBTITLE=Teams TBA, :SYNDNUM=TBA, :TITLE=College Football, :YEAR=
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry 'EP000009935605' for key 'PRIMARY'

That's the only kind of error that appears (inserting into dd_program), but
it's there several hundred times with different programs each time.  When I
run mfd with the /etc/hosts line commented out, there aren't any errors
like that.  The end of the log appears to be successful; it finds generic
episodes, repeats, etc and tells the backend to reschedule.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141023/4ae76c23/attachment.html>