recordings directory and storage

  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:e20bc78cbe0bc659433a34e8f70d2da4' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>Looks like I might have a storage issue. I have a total of 764 GB and for some reason it just seemed it was too full with the small amount of programs recorded so I did a comparison.</p>\n<p>1st comparison - MythFrontend - Manage Recordings - Delete Recordings (all)<br />\nI wrote down the size of every program and added them up.<br />\nThe total size for 101 recordings = 237.65 Gb</p>\n<p>2nd comparison - MythWeb - Recorded Programs (all)<br />\nAt the bottom it tells me, 101 programs, using 236 GB (2 days 21 hrs 31 mins) out of 764 GB (118 GB free). (Yes, I do have some videos which takes up space)</p>\n<p>3rd comparison - terminal windows, du -h in the /storage/recordings/ directory = 503Gb</p>\n<p>So du is telling me the recordings folder is holding 503Gb whereas methods 1 and 2 suggest about 236Gb. It appears I\'m being robbed of about 237Gb.</p>\n<p>Is there a way to clean up this folder without delete the recordings Myth shows?</p>\n<p>Thanks.</p>\n<p>DK</p>\n', created = 1368975538, expire = 1369061938, headers = '', serialized = 0 WHERE cid = '1:e20bc78cbe0bc659433a34e8f70d2da4' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:fd130b44c825987aaaf21a59846a9102' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>Okay, I did a google search and found the answer.</p>\n<p>myth.find_orphans.pl is a perl script in the contrib directory for finding orphaned rows in the recorded table (entries which don\'t have matching media files) and orphaned media files (potentially taking up gigabytes of otherwise usable disk space) which have no matching row in the recorded table.</p>\n<p>I ran this and it\'s all cleaned up now.</p>\n<p>perl /usr/share/doc/mythtv-docs-0.21/contrib/myth.find_orphans.pl --dodelete</p>\n', created = 1368975538, expire = 1369061938, headers = '', serialized = 0 WHERE cid = '1:fd130b44c825987aaaf21a59846a9102' in /var/www/mythdora/html/includes/cache.inc on line 109.

Looks like I might have a storage issue. I have a total of 764 GB and for some reason it just seemed it was too full with the small amount of programs recorded so I did a comparison.

1st comparison - MythFrontend - Manage Recordings - Delete Recordings (all)
I wrote down the size of every program and added them up.
The total size for 101 recordings = 237.65 Gb

2nd comparison - MythWeb - Recorded Programs (all)
At the bottom it tells me, 101 programs, using 236 GB (2 days 21 hrs 31 mins) out of 764 GB (118 GB free). (Yes, I do have some videos which takes up space)

3rd comparison - terminal windows, du -h in the /storage/recordings/ directory = 503Gb

So du is telling me the recordings folder is holding 503Gb whereas methods 1 and 2 suggest about 236Gb. It appears I'm being robbed of about 237Gb.

Is there a way to clean up this folder without delete the recordings Myth shows?

Thanks.

DK

myth.find_orphans.pl

Okay, I did a google search and found the answer.

myth.find_orphans.pl is a perl script in the contrib directory for finding orphaned rows in the recorded table (entries which don't have matching media files) and orphaned media files (potentially taking up gigabytes of otherwise usable disk space) which have no matching row in the recorded table.

I ran this and it's all cleaned up now.

perl /usr/share/doc/mythtv-docs-0.21/contrib/myth.find_orphans.pl --dodelete