[mythtv-users] Deleted Recordings Not Being Removed

[Jay Foster]

On 4/21/21 9:49 AM, Peter Bennett wrote:
> If deletion fails due to a permission problem or other issue, the 
> recordings can be left in a delete pending state. Displays of their 
> state will be inconsistent.
>
> See If this select shows anything:
>
> select deletepending, recgroup, count(*) from recorded group by 
> deletepending, recgroup;
>
> Fix this by using this with the backend down:
>
> UPDATE recorded SET deletepending = 0 where recgroup = 'Deleted';
>
> After starting the backend they should delete normally, as long as the 
> ownership of the recordings and their directory is correct
>
> Peter
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

The query produced the following output:

+---------------+----------+----------+
| deletepending | recgroup | count(*) |
+---------------+----------+----------+
|             0 | Default  |      727 |
|             0 | Deleted  |       15 |
|             1 | Default  |       15 |
+---------------+----------+----------+
This is after I deleted the deleted recordings using mythweb. Note that 
recordings recorded, watched, and deleted in the last two days (15) were 
not deleted by mythweb, they should get deleted automatically after 7 
days (what I configured).

Since no recordings in the Deleted recgroup have a non-zero 
deletepending, I don't think the second SQL command will accomplish 
anything.

Jay