[mythtv-users] mythbackend --printexpire including some deleted recordings but not others

[Peter Bennett]

On 05/17/2017 09:05 AM, Brian J. Murrell wrote:
> mythbackend --printexpire seems to be including some deleted recordings
> but not all.  First, observe two recorded (but Deleted) episodes in my
> database:
>
> $ echo 'select autoexpire,title,subtitle,starttime,basename,recgroup from recorded where subtitle = "Serena; Hani; Life of a Soldier";' | mysql -h pvr -u mythtv -pxxx mythconverg
> autoexpire	title	subtitle	starttime	basename	recgroup
> 9999	W5	Serena; Hani; Life of a Soldier	2017-04-16 16:59:00	3006_20170416165900.mkv	Deleted
>
> and:
>
> $ echo "select autoexpire,title,subtitle,season,episode,basename,recgroup from recorded where subtitle = \"Sorry Not Sorry\";" | mysql -N -h pvr -u mythtv -pxxx mythconverg
> autoexpire	title	subtitle	season	episode	basename	recgroup
> 9999	The Middle	Sorry Not Sorry	8	14	3776_20170215010000.mkv	Deleted
>
> Yet "mythbackend --printexpire" only reports on one of them:
>
> $ mythbackend --printexpire | grep -e "Serena; Hani; Life of a Soldier" -e "Sorry Not Sorry"
> W5:"Serena; Hani; Life of a Soldier"      628 MB 2017-04-16T16:59:00Z     [  0]
>
> Any ideas why this would be?
>
> Cheers,
> b.
>
>

It could be that deletepending is not zero on that recording. This can 
happen if there is a crash during delete. Check the database for any 
recordings with deletepending != 0 in the Deleted group. If this is so, 
those will be in limbo for ever, I suggest you shut down the backend and 
reset the deletepending to 0.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170517/ccd4ac95/attachment.html>