[mythtv-users] mythfilldatabase db errors after switching to tv_grab_zz_sdjson_sqlite

Paul B. Henson henson at acm.org
Mon Dec 10 00:39:24 UTC 2018


So I converted to tv_grab_zz_sdjson_sqlite which at first went quite 
well. I followed all the steps in the wiki and everything seemed to be 
working. Until the next scheduled mythfilldatabase run, which resulted 
in a crapload of:

2018-12-09 12:03:46.091364 E  DB Error (programgenres insert):
Query was:
INSERT INTO programgenres        ( chanid,  starttime, genre, 
relevance) VALUES (?, ?,    ?, ?)
Bindings were:
:CHANID=1504, :START=2018-12-27T04:30:00Z, :genre="series", :relevance=0
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1504-2018-12-27 04:30:00-0' for key 'PRIMARY'

2018-12-09 12:03:46.092178 E  DB Error (programgenres insert):
Query was:
INSERT INTO programgenres        ( chanid,  starttime, genre, 
relevance) VALUES (?, ?,    ?, ?)
Bindings were:
:CHANID=1504, :START=2018-12-27T04:30:00Z, :genre="Public affairs", 
:relevance=1
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1504-2018-12-27 04:30:00-1' for key 'PRIMARY'

2018-12-09 12:03:46.092816 E  DB Error (programgenres insert):
Query was:
INSERT INTO programgenres        ( chanid,  starttime, genre, 
relevance) VALUES (?, ?,    ?, ?)
Bindings were:
:CHANID=1504, :START=2018-12-27T04:30:00Z, :genre="Series", :relevance=2
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1504-2018-12-27 04:30:00-2' for key 'PRIMARY'

2018-12-09 12:03:46.093413 E  DB Error (programgenres insert):
Query was:
INSERT INTO programgenres        ( chanid,  starttime, genre, 
relevance) VALUES (?, ?,    ?, ?)
Bindings were:
:CHANID=1504, :START=2018-12-27T04:30:00Z, :genre="Episode", :relevance=3
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1504-2018-12-27 04:30:00-3' for key 'PRIMARY'

2018-12-09 12:03:46.093827 E  DB Error (programgenres insert):
Query was:
INSERT INTO programgenres        ( chanid,  starttime, genre, 
relevance) VALUES (?, ?,    ?, ?)
Bindings were:
:CHANID=1504, :START=2018-12-27T04:30:00Z, :genre="Show", :relevance=4
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1504-2018-12-27 04:30:00-4' for key 'PRIMARY'


All of them seemed to have the same value "1504-2018-12-27 04:30:00-4" 
that was erroring out as a duplicate.

Did I do something wrong? What's this all about?

Thanks much...


More information about the mythtv-users mailing list