[mythtv-users] Unable to delete recordings

[stinga]

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?

-- 
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email:stinga+mythtv at 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.           \\\
---------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230405/7b849d23/attachment.htm>