<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>The Z in the time indicates that the time listed is in Zulu
(Greenwich Mean Time).<br>
</p>
<div class="moz-cite-prefix">On 4/12/23 17:27, Ross Boylan wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAK3NTRCnBt8N0mVr1q19c5OPdqHX9y1bihQZ7T8YVT3gGbWQwg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>I tried manually deleting one of the records with type 33
in recordedmarkup. The deletion worked. Another theory
apparently shot down.</div>
<div><br>
</div>
<div>The forum post was about deleting recordings from the
client; my speculation was about failed deletion of individual
database records. So somewhat different.</div>
<div><br>
</div>
<div>The Z in the time is kind of weird, since, as I found, it
is not legal input syntax. But I think that's just an output
formatting issue, since the errors I'm seeing are duplicate
key errors, not invalid data format errors.</div>
<div>Ross<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Apr 11, 2023 at
7:48 PM stinga via mythtv-users <<a
href="mailto:mythtv-users@mythtv.org" moz-do-not-send="true"
class="moz-txt-link-freetext">mythtv-users@mythtv.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div>On 12/04/2023 10:41, Ross Boylan wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Mon, Apr 10, 2023
at 6:24 PM Stephen Worthington <<a
href="mailto:stephen_agent@jsw.gen.nz"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">stephen_agent@jsw.gen.nz</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">On Mon, 10 Apr
2023 14:08:45 -0700, you wrote:<br>
<br>
>Stopped mythbackend and performed the repair
steps<br>
><br>
>> sudo mysqlcheck --repair mythconverg
recordedseek<br>
>> sudo mysqlcheck --optimize mythconverg
recordedseek<br>
>> sudo mysqlcheck --analyze mythconverg
recordedseek<br>
>><br>
>No errors reported. Did same for
recordedmarkup, also no errors.<br>
><br>
>Then I tried (had to delete the final Z in the
timestamp)<br>
>INSERT INTO recordedseek (chanid, starttime,
type, mark, `offset`) VALUES<br>
>(10501,'2023-04-08T04:59:00',9,0,376);<br>
>result:<br>
>MariaDB [mythconverg]> ERROR 1062 (23000):
Duplicate entry<br>
>'10501-2023-04-08 04:59:00-9-0' for key
'PRIMARY'<br>
>I verified that there was an existing entry
already. As with the<br>
>duplicates in recordedmark, this doesn't
actually seem to be a problem with<br>
>the database, but a problem with the program or,
in this case, me, for<br>
>trying to insert a duplicate.<br>
<br>
Using mythcommflag --rebuild should not cause
duplicates, as<br>
mythcommflag deletes all recordedseek rows that
match the recording<br>
before it creates the new ones. </blockquote>
<div><br>
</div>
<div>Since mythcommflag shouldn't cause duplicates but
it does apparently, several possibilities occur:</div>
<div>1. The delete operations that clear things out
are failing, in part or in full.<br>
</div>
<div>2. The delete operations are not getting
sequenced by the db ahead of the subsequent writes.</div>
<div>3. mythcommflag is producing duplicates. As odd
as that sounds, it's the same thing that seems to be
happening with the original problems of duplicates
in the recordedmarkup table, which is somehow
getting attempted writes of 2 different times for
total duration.</div>
<div>4. My manual experiment got a duplicate warning
because the bulk insert from which the single insert
was taken succeeded partially. So that particular
record was written. That leaves the source of the
original errors unclear.<br>
</div>
<div>5. The duplicate warning is itself spurious. <br>
</div>
<div><br>
</div>
<div>I'm having trouble imagining how a problem with
the database would cause the program to start
producing duplicates, if it is not a failed
deletion. Then again, I'm having trouble imagining
why it would produce 2 different total durations at
all.</div>
<div><br>
</div>
<div>It might be relevant that I run commercial
flagging while recording the show. The end of the
recording and of the processing of the commercials
may happen fairly soon after one another, and I
suppose each could generate a total time for the
recording. But wouldn't it be the same total time?<br>
</div>
<div><br>
</div>
</div>
</div>
</blockquote>
I wonder if this is related to <a
href="https://forum.mythtv.org/viewtopic.php?f=36&t=5349"
target="_blank" moz-do-not-send="true">https://forum.mythtv.org/viewtopic.php?f=36&t=5349</a>
"No longer able to delete recordings from Mythfrontend"<br>
<br>
The Z on the end of the date could be the issue, which is
unsupported in mysql.<br>
<pre cols="72">--
'ooroo
Stinga...(:)-)
---------------------------------------------------
Email: <a href="mailto:stinga+mythtv@wolf-rock.com" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">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>
</div>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">mythtv-users@mythtv.org</a><br>
<a
href="http://lists.mythtv.org/mailman/listinfo/mythtv-users"
rel="noreferrer" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette"
rel="noreferrer" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org"
rel="noreferrer" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://forum.mythtv.org</a><br>
</blockquote>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
</blockquote>
</body>
</html>