[mythtv-users] Unable to delete recordings

[Bill Meek]

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

-- 
Bill