[mythtv-users] Unable to delete recordings

Wed Apr 5 01:26:03 UTC 2023

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 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.
>
root at 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 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/b6bcf1da/attachment.htm>