[mythtv-users] Mythfilldatabase insertion errors

Fri Jul 28 20:40:42 UTC 2017

Having gotten my Stretch/myth 0.28.1 system finally working, I have cleaned up the channel list and 
just run a mythfilldatabase. I have run some previously before I restored the database again.

It mostly works, but I'm getting duplicate key errors on programrating. Not for every entry, but a 
random number. In fact, there are only three this time so I'm appending the entire run log:

(Apologies if this is overkill.)

mythtv at jade:~$ mythfilldatabase --verbose
2017-07-28 21:28:16.017504 C  mythfilldatabase version: fixes/0.28 [03f4403] www.mythtv.org
2017-07-28 21:28:16.017540 C  Qt version: compile: 5.7.1, runtime: 5.7.1
2017-07-28 21:28:16.017551 N  Enabled verbose msgs:  general
2017-07-28 21:28:16.017569 N  Setting Log Level to LOG_INFO
2017-07-28 21:28:16.030732 I  Added logging to the console
2017-07-28 21:28:16.030988 I  Setup Interrupt handler
2017-07-28 21:28:16.031013 I  Setup Terminated handler
2017-07-28 21:28:16.031045 I  Setup Segmentation fault handler
2017-07-28 21:28:16.031062 I  Setup Aborted handler
2017-07-28 21:28:16.031083 I  Setup Bus error handler
2017-07-28 21:28:16.031110 I  Setup Floating point exception handler
2017-07-28 21:28:16.031126 I  Setup Illegal instruction handler
2017-07-28 21:28:16.031151 I  Setup Real-time signal 0 handler
2017-07-28 21:28:16.031170 I  Setup Hangup handler
2017-07-28 21:28:16.031274 N  Using runtime prefix = /usr
2017-07-28 21:28:16.031288 N  Using configuration directory = /home/mythtv/.mythtv
2017-07-28 21:28:16.031427 I  Assumed character encoding: en_GB.UTF-8
2017-07-28 21:28:16.031446 W  This application expects to be running a locale that specifies a UTF-8 
codeset, and many features may behave improperly with your current language settings. Please set the 
LC_ALL or LC_CTYPE variable(s) in the environment in which this program is executed to include a 
UTF-8 codeset (such as 'en_US.UTF-8').
2017-07-28 21:28:16.031951 I  Using localhost value of jade.example.com
2017-07-28 21:28:16.078996 N  Setting QT default locale to en_GB
2017-07-28 21:28:16.079025 I  Current locale en_GB
2017-07-28 21:28:16.079138 N  Reading locale defaults from /usr/share/mythtv//locales/en_gb.xml
2017-07-28 21:28:16.093768 I  Loading en_gb translation for module mythfrontend
2017-07-28 21:28:16.097936 I  Current MythTV Schema Version (DBSchemaVer): 1344
2017-07-28 21:28:16.101673 I  MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 
192.168.151.8:6543 (try 1 of 1)
2017-07-28 21:28:16.107041 I  MythCoreContext::CheckProtoVersion(): Using protocol version 88 XmasGift
2017-07-28 21:28:16.108565 I  Opening blocking connection to master backend
2017-07-28 21:28:16.540168 I  Updating source #1 (Freeview) with grabber tv_grab_sd_json
2017-07-28 21:28:16.541703 I  Found 97 channels for source 1 which use grabber
2017-07-28 21:28:16.545658 I  Starting process manager
2017-07-28 21:28:16.545842 I  Starting IO manager (write)
2017-07-28 21:28:16.546013 I  Starting IO manager (read)
2017-07-28 21:28:16.546230 I  Starting process signal handler
2017-07-28 21:28:17.856145 I  Grabber has capabilities: baseline manualconfig preferredmethod
2017-07-28 21:28:19.164095 I  Grabber prefers method: allatonce
2017-07-28 21:28:19.166794 I  XMLTV config file is: /home/mythtv/.mythtv/Freeview.xmltv
2017-07-28 21:31:55.564945 E  DB Error (programrating insert):
Query was:
INSERT INTO programrating        ( chanid, starttime, system, rating) VALUES (?, ?,    ?,  ?)
Bindings were:
:CHANID=5163, :RATING="G", :START=2017-08-04T14:15:00Z,
:SYS="Australian Classification Board"
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '5163-2017-08-04 14:15:00-Australi-G' for key 'chanid'

2017-07-28 21:31:55.566089 E  DB Error (programrating insert):
Query was:
INSERT INTO programrating        ( chanid, starttime, system, rating) VALUES (?, ?,    ?,  ?)
Bindings were:
:CHANID=5163, :RATING="G", :START=2017-08-04T14:15:00Z,
:SYS="Canadian Parental Rating"
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '5163-2017-08-04 14:15:00-Canadian-G' for key 'chanid'

2017-07-28 21:31:55.567106 E  DB Error (programrating insert):
Query was:
INSERT INTO programrating        ( chanid, starttime, system, rating) VALUES (?, ?,    ?,  ?)
Bindings were:
:CHANID=5163, :RATING="TVG", :START=2017-08-04T14:15:00Z,
:SYS="USA Parental Rating"
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '5163-2017-08-04 14:15:00-USA Pare-TVG' for key 'chanid'

2017-07-28 21:33:55.019024 I  Updated programs: 6923 Unchanged programs: 31347
2017-07-28 21:33:55.945505 I  Updating source #2 (Freeview-HD) with grabber tv_grab_sd_json
2017-07-28 21:33:55.946596 I  Found 40 channels for source 2 which use grabber
2017-07-28 21:33:57.261267 I  Grabber has capabilities: baseline manualconfig preferredmethod
2017-07-28 21:33:58.568511 I  Grabber prefers method: allatonce
2017-07-28 21:33:58.572684 I  XMLTV config file is: /home/mythtv/.mythtv/Freeview-HD.xmltv
2017-07-28 21:37:39.252452 I  Updated programs: 14156 Unchanged programs: 2425
2017-07-28 21:37:39.504569 N  Data fetching complete.
2017-07-28 21:37:39.504623 I  Adjusting program database end times.
2017-07-28 21:37:39.505548 I      0 replacements made
2017-07-28 21:37:39.505565 I  Marking generic episodes.
2017-07-28 21:37:40.051906 I      Found 0
2017-07-28 21:37:40.051923 I  Extending non-unique programids with multiple parts.
2017-07-28 21:37:40.234393 I      Found 0
2017-07-28 21:37:40.234407 I  Fixing missing original airdates.
2017-07-28 21:37:41.035852 I      Found 0 with programids
2017-07-28 21:37:41.037575 I      Found 0 without programids
2017-07-28 21:37:41.037590 I  Marking repeats.
2017-07-28 21:37:41.090972 I      Found 0
2017-07-28 21:37:41.090984 I  Unmarking new episode rebroadcast repeats.
2017-07-28 21:37:41.812815 I      Found 4513
2017-07-28 21:37:43.414249 I  Marking episode first showings.
2017-07-28 21:37:46.067514 I      Found 28772
2017-07-28 21:37:46.067524 I  Marking episode last showings.
2017-07-28 21:37:48.722582 I      Found 28456
2017-07-28 21:37:48.759765 I
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================
2017-07-28 21:37:48.770800 N  mythfilldatabase run complete.
2017-07-28 21:37:48.772216 I  Waiting for threads to exit.
mythtv at jade:~$

-- 

Mike Perkins