[mythtv-users] Schedules Direct DataDirect replacement service testing

[Anthony Brummett]

On Thu, Oct 23, 2014 at 4:55 PM, Bill Meek <keemllib at gmail.com> wrote:

> On 10/23/2014 03:14 PM, Anthony Brummett wrote:
>
>> 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
>>
>

> That's some great data collection work. The timestamp says you ran it
> today, so this *shouldn't* be the cause:
>
>     http://forums.schedulesdirect.org/viewtopic.php?f=6&t=2599&
> start=70#p7985
>
> I'm just wondering if you've got some stale data and if it would
> be worth running again tomorrow before jumping in to trouble-
> shooting this one.
>

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:
2014-10-24 11:16:05.054 DB Error (Inserting into dd_program):
Query was:
INSERT INTO dd_program      ( programid,    title,
subtitle,              description,  showtype,    category_type,
mpaara
ting,   starrating,  stars,                 runtime,      year,
seriesid,              colorcode,    syndicatedepisodenumber, ori
ginalairdate) 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'

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.

Here's the log from mfd taking to the new server with only a few of the 683
insert failures included:
http://pastebin.com/RK86fjzc

Here's the lines from the download data for 'EP000009935605' for the new
server:
http://pastebin.com/cJbpFADL

Here's the lines from the download data for 'EP000009935605' from the old
server:
http://pastebin.com/zMN0Xw07

Let me know if you need any more information.
Thanks,
-- Tony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20141024/0ec98f0c/attachment.html>