[mythtv-users] Unable to delete recordings

Wed Apr 5 01:11:55 UTC 2023

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 at 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 at 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 at 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 at 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