Mailing List Archive

Unable to delete recordings
G'day all,

This is a new issue that I have not had before...
I did have a power cut the other day and had to repair the database.
I did need to repair recordedseek but running mysqlcheck now shows no errors

MariaDB [mythconverg]> select title,subtitle,basename from recorded
where title like '%vera%'\G
*************************** 1. row ***************************
   title: Vera
subtitle: The Darkest Evening
basename: 80020_20230312123100.ts
1 row in set (0.000 sec)

root@mythtv:/var/log/apache2# locate 80020_20230312123100.ts
/home/mythtv/.mythtv/cache/remotecache/80020_20230312123100.ts.png
/home/mythtv/.mythtv/cache/thumbnails/-home-mythtv-.mythtv-cache-remotecache-80020_20230312123100.ts.png-masked-1229x660.png
/home/mythtv/.mythtv/cache/thumbnails/-sg-tv3-tv-80020_20230312123100.ts.png-masked-1229x660.png
/sg/tv3/tv/80020_20230312123100.ts
/sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
/sg/tv3/tv/80020_20230312123100.ts.png

root@mythtv:/var/log/apache2# ll /sg/*/tv/80020_20230312123100.ts*
-rw-r--r-- 1 mythtv mythtv 2605616080 Mar 12 22:14
/sg/tv3/tv/80020_20230312123100.ts
-rw-rw-rw- 1 mythtv mythtv       9248 Apr  4 07:30
/sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
-rw-rw-rw- 1 mythtv mythtv    1223367 Mar 21 21:23
/sg/tv3/tv/80020_20230312123100.ts.png

Using mythweb I delete the recording

Backend log says

2023-04-05 07:49:01.029878 I  MainServer: MainServer::ANN Monitor
2023-04-05 07:49:01.029895 I  MainServer: adding: mythtv(55d2a141f710)
as a client (events: 0)
2023-04-05 07:49:01.032603 D  PortChecker::checkPort(): host database
port 3306 timeLimit 30000 linkLocalOnly 1
2023-04-05 07:49:01.260483 N  ApplyRecordRecGroupChange: Default to
Deleted (3)
2023-04-05 07:49:01.261936 I  Reschedule requested for CHECK 0 4277 0
DoHandleDelete1 | Vera | The Darkest Evening | During a violent storm,
Vera comes across an abandoned car with a baby inside and is forced to
seek refuge at Brockburn House, the Stanhope's ancestral pile. |
EP025678420052
2023-04-05 07:49:01.263188 I  Monitor sock(55d2a141f710) 'mythtv'
disconnected
2023-04-05 07:49:01.756887 I  Scheduled 307 items in 0.4 = 0.00 match +
0.06 check + 0.34 place


In mythweb the entry disappears only to reappear when the page is refreshed
the gui frontend is the same, will delete but reappears.

Running backend with:
root@mythtv:/var/log/apache2# ps -eaf|grep backend
mythtv   25889 25846  0 07:41 pts/1    00:00:04 /usr/bin/mythbackend
--loglevel debug
root     26477 26101  0 07:51 pts/2    00:00:00 grep backend


root@mythtv:/var/log/apache2# /usr/bin/mythbackend --version
Please attach all output as a file in bug reports.
MythTV Version : v31.0+fixes.20200911.c4aa648-0ubuntu0
MythTV Branch : fixes/31
Network Protocol : 91
Library API : 31.20200101-1
QT Version : 5.11.3
Options compiled in:
 linux profile use_hidesyms using_alsa using_oss using_pulse
using_pulseoutput using_backend using_bindings_perl
using_bindings_python using_bindings_php using_dvb using_firewire
using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr
using_ivtv using_joystick_menu using_libcec using_libcrypto using_gnutls
using_libdns_sd using_libfftw3 using_libxml2 using_lirc using_mheg
using_opengl using_egl using_qtwebkit using_qtscript using_qtdbus
using_taglib using_v4l2 using_v4l2prime using_x11
using_libbluray_external using_xrandr using_profiletype
using_systemd_notify using_systemd_journal using_drm using_bindings_perl
using_bindings_python using_bindings_php using_freetype2
using_mythtranscode using_opengl using_egl using_drm using_vaapi
using_nvdec using_vdpau using_ffmpeg_threads using_mheg using_libass
using_libxml2 using_libmp3lame

--
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email:stinga+mythtv@wolf-rock.com o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------
Re: Unable to delete recordings [ In reply to ]
On Tuesday 04 April 2023 06:56:27 PM (-05:00), stinga via mythtv-users
wrote:

> G'day all,
>
> This is a new issue that I have not had before...
> I did have a power cut the other day and had to repair the database.
> I did need to repair recordedseek but running mysqlcheck now shows no
errors
>
> MariaDB [mythconverg]> select title,subtitle,basename from recorded
where title like '%vera%'\G
> *************************** 1. row ***************************
> title: Vera
> subtitle: The Darkest Evening
> basename: 80020_20230312123100.ts
> 1 row in set (0.000 sec)
>
> root@mythtv:/var/log/apache2# locate 80020_20230312123100.ts
> /home/mythtv/.mythtv/cache/remotecache/80020_20230312123100.ts.png
>
/home/mythtv/.mythtv/cache/thumbnails/-home-mythtv-.mythtv-cache-remotecache-80020_20230312123100.ts.png-masked-1229x660.png

>
/home/mythtv/.mythtv/cache/thumbnails/-sg-tv3-tv-80020_20230312123100.ts.png-masked-1229x660.png

> /sg/tv3/tv/80020_20230312123100.ts
> /sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
> /sg/tv3/tv/80020_20230312123100.ts.png
>
> root@mythtv:/var/log/apache2# ll /sg/*/tv/80020_20230312123100.ts*
> -rw-r--r-- 1 mythtv mythtv 2605616080 Mar 12 22:14
/sg/tv3/tv/80020_20230312123100.ts
> -rw-rw-rw- 1 mythtv mythtv 9248 Apr 4 07:30
/sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
> -rw-rw-rw- 1 mythtv mythtv 1223367 Mar 21 21:23
/sg/tv3/tv/80020_20230312123100.ts.png
>
> Using mythweb I delete the recording
>
> Backend log says
>
> 2023-04-05 07:49:01.029878 I MainServer: MainServer::ANN Monitor
> 2023-04-05 07:49:01.029895 I MainServer: adding: mythtv(55d2a141f710)
as a client (events: 0)
> 2023-04-05 07:49:01.032603 D PortChecker::checkPort(): host database
port 3306 timeLimit 30000 linkLocalOnly 1
> 2023-04-05 07:49:01.260483 N ApplyRecordRecGroupChange: Default to
Deleted (3)
> 2023-04-05 07:49:01.261936 I Reschedule requested for CHECK 0 4277 0
DoHandleDelete1 | Vera | The Darkest Evening | During a violent storm, Vera
comes across an abandoned car with a baby inside and is forced to seek
refuge at Brockburn House, the Stanhope's ancestral pile. | EP025678420052
> 2023-04-05 07:49:01.263188 I Monitor sock(55d2a141f710) 'mythtv'
disconnected
> 2023-04-05 07:49:01.756887 I Scheduled 307 items in 0.4 = 0.00 match +
0.06 check + 0.34 place
>
>
> In mythweb the entry disappears only to reappear when the page is
refreshed
> the gui frontend is the same, will delete but reappears.
>
> Running backend with:
> root@mythtv:/var/log/apache2# ps -eaf|grep backend
> mythtv 25889 25846 0 07:41 pts/1 00:00:04 /usr/bin/mythbackend
--loglevel debug
> root 26477 26101 0 07:51 pts/2 00:00:00 grep backend
>
>
> root@mythtv:/var/log/apache2# /usr/bin/mythbackend --version
> Please attach all output as a file in bug reports.
> MythTV Version : v31.0+fixes.20200911.c4aa648-0ubuntu0
> MythTV Branch : fixes/31
> Network Protocol : 91
> Library API : 31.20200101-1
> QT Version : 5.11.3
> Options compiled in:
> linux profile use_hidesyms using_alsa using_oss using_pulse
using_pulseoutput using_backend using_bindings_perl using_bindings_python
using_bindings_php using_dvb using_firewire using_frontend using_hdhomerun
using_vbox using_ceton using_hdpvr using_ivtv using_joystick_menu
using_libcec using_libcrypto using_gnutls using_libdns_sd using_libfftw3
using_libxml2 using_lirc using_mheg using_opengl using_egl using_qtwebkit
using_qtscript using_qtdbus using_taglib using_v4l2 using_v4l2prime
using_x11 using_libbluray_external using_xrandr using_profiletype
using_systemd_notify using_systemd_journal using_drm using_bindings_perl
using_bindings_python using_bindings_php using_freetype2
using_mythtranscode using_opengl using_egl using_drm using_vaapi
using_nvdec using_vdpau using_ffmpeg_threads using_mheg using_libass
using_libxml2 using_libmp3lame
>
MariaDB 10.3.38? See this:
https://forum.mythtv.org/viewtopic.php?p=25746#p25746

--
Bill
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Unable to delete recordings [ In reply to ]
On 05/04/2023 08:17, Bill Meek wrote:
>
> On Tuesday 04 April 2023 06:56:27 PM (-05:00), stinga via mythtv-users
> wrote:
>
> > G'day all,
> > > This is a new issue that I have not had before...
> > I did have a power cut the other day and had to repair the database.
> > I did need to repair recordedseek but running mysqlcheck now shows
> no errors
> > > MariaDB [mythconverg]> select title,subtitle,basename from
> recorded where title like '%vera%'\G
> > *************************** 1. row ***************************
> >    title: Vera
> > subtitle: The Darkest Evening
> > basename: 80020_20230312123100.ts
> > 1 row in set (0.000 sec)
> > > root@mythtv:/var/log/apache2# locate 80020_20230312123100.ts
> > /home/mythtv/.mythtv/cache/remotecache/80020_20230312123100.ts.png
> >
> /home/mythtv/.mythtv/cache/thumbnails/-home-mythtv-.mythtv-cache-remotecache-80020_20230312123100.ts.png-masked-1229x660.png
>
>>
> /home/mythtv/.mythtv/cache/thumbnails/-sg-tv3-tv-80020_20230312123100.ts.png-masked-1229x660.png
>
>
>> /sg/tv3/tv/80020_20230312123100.ts
> > /sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
> > /sg/tv3/tv/80020_20230312123100.ts.png
> > > root@mythtv:/var/log/apache2# ll /sg/*/tv/80020_20230312123100.ts*
> > -rw-r--r-- 1 mythtv mythtv 2605616080 Mar 12 22:14
> /sg/tv3/tv/80020_20230312123100.ts
> > -rw-rw-rw- 1 mythtv mythtv       9248 Apr  4 07:30
> /sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
> > -rw-rw-rw- 1 mythtv mythtv    1223367 Mar 21 21:23
> /sg/tv3/tv/80020_20230312123100.ts.png
> > > Using mythweb I delete the recording
> > > Backend log says
> > > 2023-04-05 07:49:01.029878 I  MainServer: MainServer::ANN Monitor
> > 2023-04-05 07:49:01.029895 I  MainServer: adding:
> mythtv(55d2a141f710) as a client (events: 0)
> > 2023-04-05 07:49:01.032603 D  PortChecker::checkPort(): host
> database port 3306 timeLimit 30000 linkLocalOnly 1
> > 2023-04-05 07:49:01.260483 N  ApplyRecordRecGroupChange: Default to
> Deleted (3)
> > 2023-04-05 07:49:01.261936 I  Reschedule requested for CHECK 0 4277
> 0 DoHandleDelete1 | Vera | The Darkest Evening | During a violent
> storm, Vera comes across an abandoned car with a baby inside and is
> forced to seek refuge at Brockburn House, the Stanhope's ancestral
> pile. | EP025678420052
> > 2023-04-05 07:49:01.263188 I  Monitor sock(55d2a141f710) 'mythtv'
> disconnected
> > 2023-04-05 07:49:01.756887 I  Scheduled 307 items in 0.4 = 0.00
> match + 0.06 check + 0.34 place
> > > > In mythweb the entry disappears only to reappear when the page
> is refreshed
> > the gui frontend is the same, will delete but reappears.
> > > Running backend with:
> > root@mythtv:/var/log/apache2# ps -eaf|grep backend
> > mythtv   25889 25846  0 07:41 pts/1    00:00:04 /usr/bin/mythbackend
> --loglevel debug
> > root     26477 26101  0 07:51 pts/2    00:00:00 grep backend
> > > > root@mythtv:/var/log/apache2# /usr/bin/mythbackend --version
> > Please attach all output as a file in bug reports.
> > MythTV Version : v31.0+fixes.20200911.c4aa648-0ubuntu0
> > MythTV Branch : fixes/31
> > Network Protocol : 91
> > Library API : 31.20200101-1
> > QT Version : 5.11.3
> > Options compiled in:
> >  linux profile use_hidesyms using_alsa using_oss using_pulse
> using_pulseoutput using_backend using_bindings_perl
> using_bindings_python using_bindings_php using_dvb using_firewire
> using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr
> using_ivtv using_joystick_menu using_libcec using_libcrypto
> using_gnutls using_libdns_sd using_libfftw3 using_libxml2 using_lirc
> using_mheg using_opengl using_egl using_qtwebkit using_qtscript
> using_qtdbus using_taglib using_v4l2 using_v4l2prime using_x11
> using_libbluray_external using_xrandr using_profiletype
> using_systemd_notify using_systemd_journal using_drm
> using_bindings_perl using_bindings_python using_bindings_php
> using_freetype2 using_mythtranscode using_opengl using_egl using_drm
> using_vaapi using_nvdec using_vdpau using_ffmpeg_threads using_mheg
> using_libass using_libxml2 using_libmp3lame
> > MariaDB 10.3.38?  See this:
> https://forum.mythtv.org/viewtopic.php?p=25746#p25746
>

G'day Bill,

Had you spotted something that maybe causing the issue?

--
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email:stinga+mythtv@wolf-rock.com o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------
Re: Unable to delete recordings [ In reply to ]
On Tuesday 04 April 2023 07:56:08 PM (-05:00), stinga via mythtv-users
wrote:

> On 05/04/2023 08:17, Bill Meek wrote:
> >
> > On Tuesday 04 April 2023 06:56:27 PM (-05:00), stinga via mythtv-users
wrote:
> >
> > > G'day all,
> > > > This is a new issue that I have not had before...
> > > I did have a power cut the other day and had to repair the database.
> > > I did need to repair recordedseek but running mysqlcheck now shows
no errors
> > > > MariaDB [mythconverg]> select title,subtitle,basename from
recorded where title like '%vera%'\G
> > > *************************** 1. row ***************************
> > > title: Vera
> > > subtitle: The Darkest Evening
> > > basename: 80020_20230312123100.ts
> > > 1 row in set (0.000 sec)
> > > > root@mythtv:/var/log/apache2# locate 80020_20230312123100.ts
> > > /home/mythtv/.mythtv/cache/remotecache/80020_20230312123100.ts.png
> > >
/home/mythtv/.mythtv/cache/thumbnails/-home-mythtv-.mythtv-cache-remotecache-80020_20230312123100.ts.png-masked-1229x660.png

> >
> >>
> >
/home/mythtv/.mythtv/cache/thumbnails/-sg-tv3-tv-80020_20230312123100.ts.png-masked-1229x660.png

> >
> >> /sg/tv3/tv/80020_20230312123100.ts
> > > /sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
> > > /sg/tv3/tv/80020_20230312123100.ts.png
> > > > root@mythtv:/var/log/apache2# ll /sg/*/tv/80020_20230312123100.ts*
> > > -rw-r--r-- 1 mythtv mythtv 2605616080 Mar 12 22:14
/sg/tv3/tv/80020_20230312123100.ts
> > > -rw-rw-rw- 1 mythtv mythtv 9248 Apr 4 07:30
/sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
> > > -rw-rw-rw- 1 mythtv mythtv 1223367 Mar 21 21:23
/sg/tv3/tv/80020_20230312123100.ts.png
> > > > Using mythweb I delete the recording
> > > > Backend log says
> > > > 2023-04-05 07:49:01.029878 I MainServer: MainServer::ANN Monitor
> > > 2023-04-05 07:49:01.029895 I MainServer: adding:
mythtv(55d2a141f710) as a client (events: 0)
> > > 2023-04-05 07:49:01.032603 D PortChecker::checkPort(): host
database port 3306 timeLimit 30000 linkLocalOnly 1
> > > 2023-04-05 07:49:01.260483 N ApplyRecordRecGroupChange: Default to
Deleted (3)
> > > 2023-04-05 07:49:01.261936 I Reschedule requested for CHECK 0 4277
0 DoHandleDelete1 | Vera | The Darkest Evening | During a violent storm,
Vera comes across an abandoned car with a baby inside and is forced to seek
refuge at Brockburn House, the Stanhope's ancestral pile. | EP025678420052
> > > 2023-04-05 07:49:01.263188 I Monitor sock(55d2a141f710) 'mythtv'
disconnected
> > > 2023-04-05 07:49:01.756887 I Scheduled 307 items in 0.4 = 0.00
match + 0.06 check + 0.34 place
> > > > > In mythweb the entry disappears only to reappear when the page
is refreshed
> > > the gui frontend is the same, will delete but reappears.
> > > > Running backend with:
> > > root@mythtv:/var/log/apache2# ps -eaf|grep backend
> > > mythtv 25889 25846 0 07:41 pts/1 00:00:04 /usr/bin/mythbackend
--loglevel debug
> > > root 26477 26101 0 07:51 pts/2 00:00:00 grep backend
> > > > > root@mythtv:/var/log/apache2# /usr/bin/mythbackend --version
> > > Please attach all output as a file in bug reports.
> > > MythTV Version : v31.0+fixes.20200911.c4aa648-0ubuntu0
> > > MythTV Branch : fixes/31
> > > Network Protocol : 91
> > > Library API : 31.20200101-1
> > > QT Version : 5.11.3
> > > Options compiled in:
> > > linux profile use_hidesyms using_alsa using_oss using_pulse
using_pulseoutput using_backend using_bindings_perl using_bindings_python
using_bindings_php using_dvb using_firewire using_frontend using_hdhomerun
using_vbox using_ceton using_hdpvr using_ivtv using_joystick_menu
using_libcec using_libcrypto using_gnutls using_libdns_sd using_libfftw3
using_libxml2 using_lirc using_mheg using_opengl using_egl using_qtwebkit
using_qtscript using_qtdbus using_taglib using_v4l2 using_v4l2prime
using_x11 using_libbluray_external using_xrandr using_profiletype
using_systemd_notify using_systemd_journal using_drm using_bindings_perl
using_bindings_python using_bindings_php using_freetype2
using_mythtranscode using_opengl using_egl using_drm using_vaapi
using_nvdec using_vdpau using_ffmpeg_threads using_mheg using_libass
using_libxml2 using_libmp3lame
> >
>> MariaDB 10.3.38? See this:
https://forum.mythtv.org/viewtopic.php?p=25746#p25746
> >
>
> G'day Bill,
>
> Had you spotted something that maybe causing the issue?


The opinion on the forum is that it has to do with MariaDB not handling the
specific query
used for the delete. As you probably read, downgrading the version of
MariaDB allowed
the deletes to work. There was an alternate solution, that alters the DB
and I don't suggest
doing that.


If mysql --version doesn't show 10.3.28, this isn't the same issue.

--
Bill
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Unable to delete recordings [ In reply to ]
On 05/04/2023 09:11, Bill Meek wrote:
>
>
>
> On Tuesday 04 April 2023 07:56:08 PM (-05:00), stinga via mythtv-users
> wrote:
>
> > On 05/04/2023 08:17, Bill Meek wrote:
> > >
> > > On Tuesday 04 April 2023 06:56:27 PM (-05:00), stinga via
> mythtv-users wrote:
> > >
> > > > G'day all,
> > > > > This is a new issue that I have not had before...
> > > > I did have a power cut the other day and had to repair the
> database.
> > > > I did need to repair recordedseek but running mysqlcheck now
> shows no errors
> > > > > MariaDB [mythconverg]> select title,subtitle,basename from
> recorded where title like '%vera%'\G
> > > > *************************** 1. row ***************************
> > > >    title: Vera
> > > > subtitle: The Darkest Evening
> > > > basename: 80020_20230312123100.ts
> > > > 1 row in set (0.000 sec)
> > > > > root@mythtv:/var/log/apache2# locate 80020_20230312123100.ts
> > > > /home/mythtv/.mythtv/cache/remotecache/80020_20230312123100.ts.png
> > > >
> /home/mythtv/.mythtv/cache/thumbnails/-home-mythtv-.mythtv-cache-remotecache-80020_20230312123100.ts.png-masked-1229x660.png
>
>> >
> > >
> /home/mythtv/.mythtv/cache/thumbnails/-sg-tv3-tv-80020_20230312123100.ts.png-masked-1229x660.png
>
>> >
> > > > /sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
> > > > /sg/tv3/tv/80020_20230312123100.ts.png
> > > > > root@mythtv:/var/log/apache2# ll
> /sg/*/tv/80020_20230312123100.ts*
> > > > -rw-r--r-- 1 mythtv mythtv 2605616080 Mar 12 22:14
> /sg/tv3/tv/80020_20230312123100.ts
> > > > -rw-rw-rw- 1 mythtv mythtv       9248 Apr  4 07:30
> /sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
> > > > -rw-rw-rw- 1 mythtv mythtv    1223367 Mar 21 21:23
> /sg/tv3/tv/80020_20230312123100.ts.png
> > > > > Using mythweb I delete the recording
> > > > > Backend log says
> > > > > 2023-04-05 07:49:01.029878 I  MainServer: MainServer::ANN Monitor
> > > > 2023-04-05 07:49:01.029895 I  MainServer: adding:
> mythtv(55d2a141f710) as a client (events: 0)
> > > > 2023-04-05 07:49:01.032603 D PortChecker::checkPort(): host
> database port 3306 timeLimit 30000 linkLocalOnly 1
> > > > 2023-04-05 07:49:01.260483 N ApplyRecordRecGroupChange: Default
> to Deleted (3)
> > > > 2023-04-05 07:49:01.261936 I  Reschedule requested for CHECK 0
> 4277 0 DoHandleDelete1 | Vera | The Darkest Evening | During a violent
> storm, Vera comes across an abandoned car with a baby inside and is
> forced to seek refuge at Brockburn House, the Stanhope's ancestral
> pile. | EP025678420052
> > > > 2023-04-05 07:49:01.263188 I  Monitor sock(55d2a141f710)
> 'mythtv' disconnected
> > > > 2023-04-05 07:49:01.756887 I  Scheduled 307 items in 0.4 = 0.00
> match + 0.06 check + 0.34 place
> > > > > > In mythweb the entry disappears only to reappear when the
> page is refreshed
> > > > the gui frontend is the same, will delete but reappears.
> > > > > Running backend with:
> > > > root@mythtv:/var/log/apache2# ps -eaf|grep backend
> > > > mythtv   25889 25846  0 07:41 pts/1    00:00:04
> /usr/bin/mythbackend --loglevel debug
> > > > root     26477 26101  0 07:51 pts/2    00:00:00 grep backend
> > > > > > root@mythtv:/var/log/apache2# /usr/bin/mythbackend --version
> > > > Please attach all output as a file in bug reports.
> > > > MythTV Version : v31.0+fixes.20200911.c4aa648-0ubuntu0
> > > > MythTV Branch : fixes/31
> > > > Network Protocol : 91
> > > > Library API : 31.20200101-1
> > > > QT Version : 5.11.3
> > > > Options compiled in:
> > > >  linux profile use_hidesyms using_alsa using_oss using_pulse
> using_pulseoutput using_backend using_bindings_perl
> using_bindings_python using_bindings_php using_dvb using_firewire
> using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr
> using_ivtv using_joystick_menu using_libcec using_libcrypto
> using_gnutls using_libdns_sd using_libfftw3 using_libxml2 using_lirc
> using_mheg using_opengl using_egl using_qtwebkit using_qtscript
> using_qtdbus using_taglib using_v4l2 using_v4l2prime using_x11
> using_libbluray_external using_xrandr using_profiletype
> using_systemd_notify using_systemd_journal using_drm
> using_bindings_perl using_bindings_python using_bindings_php
> using_freetype2 using_mythtranscode using_opengl using_egl using_drm
> using_vaapi using_nvdec using_vdpau using_ffmpeg_threads using_mheg
> using_libass using_libxml2 using_libmp3lame
> > >
> >> MariaDB 10.3.38?  See this:
> https://forum.mythtv.org/viewtopic.php?p=25746#p25746
> > >
> > > G'day Bill,
> > > Had you spotted something that maybe causing the issue?
>
>
> The opinion on the forum is that it has to do with MariaDB not
> handling the specific query
> used for the delete. As you probably read, downgrading the version of
> MariaDB allowed
> the deletes to work. There was an alternate solution, that alters the
> DB and I don't suggest
> doing that.
>
>
> If mysql --version doesn't show 10.3.28, this isn't the same issue.
>
root@octopus:/var/log# mysql --version
mysql  Ver 15.1 Distrib 10.5.16-MariaDB, for debian-linux-gnu (x86_64)
using readline 5.2

--
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email:stinga+mythtv@wolf-rock.com o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------