[mythtv-users] DB error I just logged

[Jerome Yuzyk]

On Saturday, October 17, 2015 11:27:11 PM Hika van den Hoven wrote:
> Hoi Hika,
> 
> Saturday, October 17, 2015, 11:23:28 PM, you wrote:
> 
> > Hoi Jerome,
> 
> > Saturday, October 17, 2015, 10:15:44 PM, you wrote:
> 
> >> I have a tail -f on the mythbackend log and it just registered
> >> this. I think it's about one of 2 recordings that started about 10
> >> minutes ago on one of my PVR-500 tuners. The backend keeps on recording though.
> 
> 
> >> 2015-10-17 14:06:27.367002 E [32247/3904] RecThread mythdb.cpp:183
> >> (DBError) - DB Error (Resolution insert):
> >> Query was:
> >> INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data) VALUES ( ?, ?, ?, ?, ?);
> >> Bindings were:
> >> :CHANID=1020, :DATA=720, :MARK=11581,
> >> :STARTTIME=2015-10-17T20:00:00Z, :TYPE=30
> >> Driver error was [2/1062]:
> >> QMYSQL3: Unable to execute statement
> >> Database error was:
> >> Duplicate entry '1020-2015-10-17 20:00:00-30-11581' for key 'PRIMARY'
> 
> >> 2015-10-17 14:06:27.367372 E [32247/3904] RecThread mythdb.cpp:183
> >> (DBError) - DB Error (Resolution insert):
> >> Query was:
> >> INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data) VALUES ( ?, ?, ?, ?, ?);
> >> Bindings were:
> >> :CHANID=1020, :DATA=480, :MARK=11581,
> >> :STARTTIME=2015-10-17T20:00:00Z, :TYPE=31
> >> Driver error was [2/1062]:
> >> QMYSQL3: Unable to execute statement
> >> Database error was:
> >> Duplicate entry '1020-2015-10-17 20:00:00-31-11581' for key 'PRIMARY'
> 
> > These are bookmarks and commercial flaggings, so doesn't come from
> > recording, but probably from run-time comflagging. I guess the process
> > just treats it as non fatal.
> 
> I checked in the wiki
> (https://www.mythtv.org/wiki/Recordedmarkup_table) what type = 30
> means. It somehow tried twice to record the width of the recording.

Interesting, thanks. It's happened again too. Perhaps that's why commflagging got about 6 minutes in and then starts giving me "At End, cannot Skip", like it didn't see a single commercial in 2.5 hours.

-- 
A little of Jerome's MythTV World: http://mythtv.bss.ab.ca