[mythtv-users] Database damage?

Craig Treleaven ctreleaven at cogeco.ca
Sat Feb 13 01:23:05 UTC 2021

> On Feb 10, 2021, at 9:08 PM, Stephen Worthington <stephen_agent at jsw.gen.nz> wrote:
> On Wed, 10 Feb 2021 19:37:39 -0500, you wrote:
>>> On Feb 10, 2021, at 12:56 PM, Stephen Worthington <stephen_agent at jsw.gen.nz> wrote:
>> Upfront, I really appreciate your detailed response.  Unfortunately I’m not quite there yet.
>>> On Wed, 10 Feb 2021 11:44:30 -0500, you wrote:

Stephen, thank you again for all the suggestions and ideas.  To close the loop on my trials...

In the end, it was mostly a hardware problem.  I finally determined that I could no longer record from one of my old HDHomerun units even though the power and network lights were lit.  As others have experienced, the power supply had apparently weakened such that it could not successfully tune and stream to myth.  Incidentally, this unit has been powered through a UPS for most of its life.  I have it back up running on a universal supply for the time being and I’ve reached out to SiliconDust about getting a replacement.  After all, it is only 10 years old!  ;)

The other issue is that I had nearly 700 recordings that were orphaned.  The find_orphans.py script would not get rid of them.  After a small test, I noticed that if I created a zero byte file (with touch), then find_orphans.py happily deleted such zero byte recordings.  At least with the 4 I tested.  (This is foreshadowing!)  So with the output from find_orphans.py and a little massaging with awk, xargs and touch, I created zero byte ‘recordings’ for the nearly 700 remaining problems.  That’s too many.  When I ask find_orphans.py to delete them, the script crashes.  It also crashed mythbackend a couple of times.  A few (maybe 40) recordings got deleted at some point.  So I still have around 750 zero byte recordings.  I can probably delete the files in batches (how many per batch?) and eventually get rid of them.  However, at this point, I’m so sick of messing with this shi|t that I don’t want to deal with it.

Sometimes, Myth is more work than it is worth.


More information about the mythtv-users mailing list