[mythtv-users] DB error I just logged

[Hika van den Hoven]

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.


Tot mails,
  Hika Alina Maria van den Hoven                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens
--