Stale entries in database - with or without files

[cornflake]

I am doing some database maintenance and found these entries. None of these show as available to view on the frontend.

Code: Select all

MariaDB [mythconverg]> SELECT starttime,hostname,title,recgroup,basename FROM recorded WHERE recgroup = 'LiveTV';
+---------------------+-----------+---------------------------+----------+-------------------------+
| starttime           | hostname  | title                     | recgroup | basename                |
+---------------------+-----------+---------------------------+----------+-------------------------+
| 2011-07-12 10:01:24 | localhost | Newswatch 16 This Morning | LiveTV   | 1161_20110712060124.mpg |
| 2011-08-02 03:04:19 | localhost | Access Hollywood          | LiveTV   | 1221_20110801230419.mpg |
| 2011-12-08 23:02:24 | localhost | Newswatch 16 at 6pm       | LiveTV   | 1161_20111208180224.mpg |
| 2012-10-06 03:35:00 | Papi      | Nightline                 | LiveTV   | 2161_20121005233500.mpg |
| 2012-10-06 03:36:15 | Papi      | The Office                | LiveTV   | 2561_20121005233615.mpg |
| 2012-10-06 03:36:24 | Papi      | American Dad!             | LiveTV   | 2563_20121005233624.mpg |
| 2012-10-06 03:36:25 | Papi      | American Dad!             | LiveTV   | 2563_20121005233625.mpg |
+---------------------+-----------+---------------------------+----------+-------------------------+
7 rows in set (0.000 sec)

The first three have no associated file, while the rest do, with some of the files taking up space.

Code: Select all

ls: cannot access '1161_20110712060124.mpg': No such file or directory
ls: cannot access '1221_20110801230419.mpg': No such file or directory
ls: cannot access '1161_20111208180224.mpg': No such file or directory
-rw-r--r-- 1 mythtv users 128M Oct  5  2012 2161_20121005233500.mpg
-rw-r--r-- 1 mythtv users    0 Oct  5  2012 2561_20121005233615.mpg
-rw-r--r-- 1 mythtv users    0 Oct  5  2012 2563_20121005233624.mpg
-rw-r--r-- 1 mythtv users 8.4M Oct  5  2012 2563_20121005233625.mpg

What could be causing this?

[cornflake]

Nevermind, found the "deletepending" column and they are the only ones set to 1. Proceeding to delete them manually.