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

[Ross Boylan]

 mariadb --version
mariadb  Ver 15.1 Distrib 10.5.19-MariaDB, for debian-linux-gnu (x86_64)
using  EditLine wrapper

The thread you cite is interesting because it shows a recent update to
maria.
The last on my system seems (in dpkg.log) from 2023-03-11:
upgrade mariadb-server-core-10.5:amd64 1:10.5.18-0+deb11u1
1:10.5.19-0+deb11u1
which was quite awhile before I noticed a problem.  This is a later version
than reported in the post you linked to.  However, the system was up
continuously from 2023-03-05 until the problems on 2023-04-04, so maybe the
old binaries were in use until then..  Although I think the upgrade stops
the database, and I think I remember waiting til myth wasn't active before
applying the update to mariadb.

Ross

On Mon, Apr 10, 2023 at 7:01 PM Bill Meek <keemllib at gmail.com> wrote:

>
> On Sunday 09 April 2023 02:50:16 AM (-05:00), Ross Boylan wrote:
>
> ...
>
> > 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
>
> What version of mariadb are you running? mariadb --version
>
> https://forum.mythtv.org/viewtopic.php?p=25746#p25746
> --
> Bill
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230410/a7249b3f/attachment.htm>