[mythtv-users] INSERT INTO recordedmarkup fails w/duplicate; recording status changes

[Jan Ceuleers]

On 09/04/2023 09:50, Ross Boylan wrote:
> A few days ago my system locked up with video problems; I was able to
> ssh in and execute shutdown.  But since then I see an error like this
> in the logs, I think for every show I record:
> Apr  8 22:06:30 barley mythbackend[2592]: 2023-04-08 22:06:30.919562 E
>  DB Error (Duration insert):
> Apr  8 22:06:30 barley mythbackend[2592]: Query was:
> Apr  8 22:06:30 barley mythbackend[2592]: INSERT INTO recordedmarkup
>  (chanid, starttime, mark, type, data)    VALUES ( 10203,
> '2023-04-09T02:54:00Z', 0, 33, 7950000);
> Apr  8 22:06:30 barley mythbackend[2592]: Bindings were:
> Apr  8 22:06:30 barley mythbackend[2592]: :CHANID=10203,
> :DATA=7950000, :STARTTIME=2023-04-09T02:54:00.000Z, :TYPE=33
> Apr  8 22:06:30 barley mythbackend[2592]: Driver error was [2/1062]:
> Apr  8 22:06:30 barley mythbackend[2592]: QMYSQL: Unable to execute query
> Apr  8 22:06:30 barley mythbackend[2592]: Database error was:
> Apr  8 22:06:30 barley mythbackend[2592]: Duplicate entry
> '10203-2023-04-09 02:54:00-33-0' for key 'PRIMARY'

In order to exclude the possibility of database corruption, could you
check/repair the database?

https://www.mythtv.org/wiki/Database_errors

> Myth 1:31.0+fixes20220227.git7e4ce1ba98-dmo0+deb11u1 from Marillat's
> repository on Debian 11/bullseye
> mariadb 1:10.5.19-0+deb11u1
> nvidia proprietary driver 470.161.03-1
> amd64 architecture

People here may not be familiar with that particular repository (I
certainly am not, but I'm also not a MythTV dev).

Please always include the output of mythbackend --version in issue reports.