<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 05/04/2023 09:11, Bill Meek wrote:<br>
</div>
<blockquote type="cite"
cite="mid:1680656662086.1225843323.2875505398@gmail.com">
<br>
<br>
<br>
On Tuesday 04 April 2023 07:56:08 PM (-05:00), stinga via
mythtv-users wrote:
<br>
<br>
> On 05/04/2023 08:17, Bill Meek wrote:
<br>
> >
<br>
> > On Tuesday 04 April 2023 06:56:27 PM (-05:00), stinga
via mythtv-users wrote:
<br>
> >
<br>
> > > G'day all,
<br>
> > > > This is a new issue that I have not had
before...
<br>
> > > I did have a power cut the other day and had to
repair the database.
<br>
> > > I did need to repair recordedseek but running
mysqlcheck now shows no errors
<br>
> > > > MariaDB [mythconverg]> select
title,subtitle,basename from recorded where title like '%vera%'\G
<br>
> > > *************************** 1. row
***************************
<br>
> > > title: Vera
<br>
> > > subtitle: The Darkest Evening
<br>
> > > basename: 80020_20230312123100.ts
<br>
> > > 1 row in set (0.000 sec)
<br>
> > > > root@mythtv:/var/log/apache2# locate
80020_20230312123100.ts
<br>
> > >
/home/mythtv/.mythtv/cache/remotecache/80020_20230312123100.ts.png
<br>
> > >
/home/mythtv/.mythtv/cache/thumbnails/-home-mythtv-.mythtv-cache-remotecache-80020_20230312123100.ts.png-masked-1229x660.png<br>
<br>
<blockquote type="cite">>
<br>
</blockquote>
> >>
<br>
> >
/home/mythtv/.mythtv/cache/thumbnails/-sg-tv3-tv-80020_20230312123100.ts.png-masked-1229x660.png
<br>
<blockquote type="cite">>
<br>
</blockquote>
> >> /sg/tv3/tv/80020_20230312123100.ts
<br>
> > > /sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
<br>
> > > /sg/tv3/tv/80020_20230312123100.ts.png
<br>
> > > > root@mythtv:/var/log/apache2# ll
/sg/*/tv/80020_20230312123100.ts*
<br>
> > > -rw-r--r-- 1 mythtv mythtv 2605616080 Mar 12 22:14
/sg/tv3/tv/80020_20230312123100.ts
<br>
> > > -rw-rw-rw- 1 mythtv mythtv 9248 Apr 4 07:30
/sg/tv3/tv/80020_20230312123100.ts.-1.100x56.png
<br>
> > > -rw-rw-rw- 1 mythtv mythtv 1223367 Mar 21 21:23
/sg/tv3/tv/80020_20230312123100.ts.png
<br>
> > > > Using mythweb I delete the recording
<br>
> > > > Backend log says
<br>
> > > > 2023-04-05 07:49:01.029878 I MainServer:
MainServer::ANN Monitor
<br>
> > > 2023-04-05 07:49:01.029895 I MainServer: adding:
mythtv(55d2a141f710) as a client (events: 0)
<br>
> > > 2023-04-05 07:49:01.032603 D
PortChecker::checkPort(): host database port 3306 timeLimit 30000
linkLocalOnly 1
<br>
> > > 2023-04-05 07:49:01.260483 N
ApplyRecordRecGroupChange: Default to Deleted (3)
<br>
> > > 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
<br>
> > > 2023-04-05 07:49:01.263188 I Monitor
sock(55d2a141f710) 'mythtv' disconnected
<br>
> > > 2023-04-05 07:49:01.756887 I Scheduled 307 items
in 0.4 = 0.00 match + 0.06 check + 0.34 place
<br>
> > > > > In mythweb the entry disappears only to
reappear when the page is refreshed
<br>
> > > the gui frontend is the same, will delete but
reappears.
<br>
> > > > Running backend with:
<br>
> > > root@mythtv:/var/log/apache2# ps -eaf|grep backend
<br>
> > > mythtv 25889 25846 0 07:41 pts/1 00:00:04
/usr/bin/mythbackend --loglevel debug
<br>
> > > root 26477 26101 0 07:51 pts/2 00:00:00
grep backend
<br>
> > > > > root@mythtv:/var/log/apache2#
/usr/bin/mythbackend --version
<br>
> > > Please attach all output as a file in bug reports.
<br>
> > > MythTV Version :
v31.0+fixes.20200911.c4aa648-0ubuntu0
<br>
> > > MythTV Branch : fixes/31
<br>
> > > Network Protocol : 91
<br>
> > > Library API : 31.20200101-1
<br>
> > > QT Version : 5.11.3
<br>
> > > Options compiled in:
<br>
> > > 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
<br>
> >
<br>
>> MariaDB 10.3.38? See this:
<a class="moz-txt-link-freetext" href="https://forum.mythtv.org/viewtopic.php?p=25746#p25746">https://forum.mythtv.org/viewtopic.php?p=25746#p25746</a>
<br>
> >
<br>
> > G'day Bill,
<br>
> > Had you spotted something that maybe causing the issue?
<br>
<br>
<br>
The opinion on the forum is that it has to do with MariaDB not
handling the specific query
<br>
used for the delete. As you probably read, downgrading the version
of MariaDB allowed
<br>
the deletes to work. There was an alternate solution, that alters
the DB and I don't suggest
<br>
doing that.
<br>
<br>
<br>
If mysql --version doesn't show 10.3.28, this isn't the same
issue.
<br>
<br>
</blockquote>
root@octopus:/var/log# mysql --version<br>
mysql Ver 15.1 Distrib 10.5.16-MariaDB, for debian-linux-gnu
(x86_64) using readline 5.2<br>
<br>
<pre class="moz-signature" cols="72">--
'ooroo
Stinga...(:)-)
---------------------------------------------------
Email: <a class="moz-txt-link-abbreviated" href="mailto:stinga+mythtv@wolf-rock.com">stinga+mythtv@wolf-rock.com</a> 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. \\\
---------------------------------------------------</pre>
</body>
</html>