[mythtv-users] DB error I just logged

[Hika van den Hoven]

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.

Tot mails,
  Hika                            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