[mythtv-users] MythArchive only sees 10 out of 100s of recordings

[stuart]

Michael T. Dean wrote:
> On 11/14/2009 06:47 PM, stuart wrote:
>> Playing w/SQL data queries has uncovered the real culprit. My MBE data 
>> base of recordings is missing over 100 recordings.  I can find over 
>> 150 recordings all of non-zero length in the appropriate directory.
>>
>>> MBE:/space/recordings> ls *.mpg | wc
>>>     153     153    3672 
>>
>> However a SQL query only finds 11!:
>>
>>> mysql> SELECT title, subtitle, starttime, endtime, chanid, basename 
>>> FROM recorded WHERE hostname='MBE';
>>> +--------------------------------+------------------<stuff deleted>
>>> | title                          | subtitle         <stuff deleted>
>>> +--------------------------------+------------------<stuff deleted>
>> <stuff deleted>
>>> | The Office                     | Murder           <stuff deleted>
>>> +--------------------------------+------------------<stuff deleted>
>>> 11 rows in set (0.00 sec) 
>>
>> At this point I'd like to dump the data base and start over.  But it 
>> appears to be doing a better job of tracking recordings on the SBE 
>> machine.  There the data base has 213 lines.  However, I can only find 
>> 162 files.  Ha, the reverse problem!  I can not find 51 files on the SBE.
>>
>> Clearly I have issues.
>>
>> Given that the MFEs lists the missing files by name and date (I 
>> tracked one such file that exists on the MBE but is not in the data 
>> base) there must be a way to find the missing data that goes beyond 
>> the broken SQL data base. To be clear, the MFEs can not play such 
>> shows as they are reported missing.  I'm hoping I can repair the data 
>> base and restore the data for over 100 recordings that, apparently, 
>> both exist and show up in the MFEs list of recordings but not the SQL 
>> data base.
>>
>> Any ideas on how to do that? 
> 
> Did you move recording files that were recorded on the master backend to 
> the remote backend?  If so, the database would need to be updated iff 
> the filesystem to which you moved the recording files is not accessible 
> from the master backend.
> 
> So, if that's the case, you can either mount the remote filesystem using 
> NFS or CIFS on the master backend or fix the hostname for the 
> appropriate recordings in the database.
> 
> You should really do the query above to show a) without any WHERE 
> hostname clause, b) with WHERE hostname = 'MBE', c) with WHERE hostname 
> = 'SBE', /and/ d) with WHERE hostname NOT IN ('MBE', 'SBE');
> 
> Don't give up on your DB just yet.
> 
> Mike

Wow, unscrambling this is harder then a game of Sudoku!  The short 
answer is that I am still working on it - but may soon give up and wipe 
out the orphaned recordings as well as the orphaned data base entries.

---

To answer your question, yes - I did move some recordings between the 
MBE and SBE mythtv boxes - last time I swapped out the HDD for more 
space on the MBE.

I don't believe I have ever NFS'ed the MBE recordings to the SBE or the 
SBE recordings to the MBE.  (I do, however, NFS export the MBE video 
files to the SBE.)  Those mythtv recordings I moved were probably no 
longer playable back then - I just didn't realize it at the time - as 
they still showed up in the MFE listings - I assume, if I had tried 
playing them, I would have seen a pop-up saying the files could not be 
found.

Going forward, I started looking for files on the MBE (recall there are 
over 100 but only 10 show up in the data base) which are not in the data 
base.  I figured I could then query the data base using the basename and 
discover that the data base thought these files to be on the SBE.  After 
spot checking several files. I could then, like you said, move them the 
the correct BE or change their data base entry.  No such luck.

Then I remembered I had previously used myth data base scripts to clean 
up orphaned files and data base entries.  In other words, I am probably 
so far down an obfuscated rabbit hole w/no "undo" key that there is 
little chance that a one or two step process can be whipped up to solve 
this mythtv data base problem.

I'll keep looking for a pattern.  Maybe I'll be able to recover some of 
the files in some sort of batch process.  But at this point I am 
thinking I'll just save a few important recordings as videos using 
readable file names - removing them from the myth data base paradigm 
forever.

-thanks for your help