INTERACT FORUM

Windows => Television => Topic started by: BryanC on February 24, 2019, 06:33:27 pm

Title: Old TV timeshifting directories not being removed from database
Post by: BryanC on February 24, 2019, 06:33:27 pm

My current MC (Linux) library was created using a library backup from an old Windows machine several aeons ago. I have auto-import set to "fix broken links." Yet I am seeing some cruft in the logs from MC trying to parse my old TV timeshifting Windows directories. It looks like these are never removed from the database (one directory is from 2012!). My guess is that they are never removed at all, even on Windows machines. I've tried searching the database for missing files, but it looks like these are pretty well hidden. This probably results in a minuscule performance hit but I think that they should be removed if TV functionality is disabled or if the user changes the timeshifting directory (etc.).

Code: [Select]

0012734: 140207917623040: Import: GetNewFiles: Searching: /home/bryan/Downloads/complete/
0012734: 140207917623040: Import: GetNewFiles: Searching: /home/bryan/Documents/music/
0012736: 140207917623040: Import: GetNewFiles: Finish (7120 ms)
0012736: 140207917623040: Import: GetMissingAndUpdateFiles: Start
0012736: 140207917623040: Import: GetMissingAndUpdateFiles: Getting files
0012740: 140207917623040: Import: GetMissingAndUpdateFiles: Sorting files
0012744: 140207917623040: Database: CMediaInfoArraySort::Sort: Files: 601; Elapsed ms: 3.884
0012744: 140207917623040: Import: GetMissingAndUpdateFiles: Looping 601 files
0012755: 140207917623040: General: CFileSystemManager::AnalyzeDrive: Drive does not exist (drive: C:, filename: C:\Users\Bryan\Videos\JRiver TimeShifting Temp\6-1 WBRC -  2017-09-10 13-25\NFL Football - Seattle Seahawks at Green Bay Packers 2017-09-10.jtv)
0012771: 140207917623040: General: CFileSystemManager::AnalyzeDrive: Drive does not exist (drive: F:, filename: F:\TV Recordings\6-1 WBRC 2012-02-19 22-7\6-1 WBRC 2012-02-19 22-7 - Saved Time-shifting.jtv)
0012771: 140207917623040: General: CFileSystemManager::AnalyzeDrive: Drive does not exist (drive: M:, filename: M:\Downloads\Complete\tv\10-2 WBIQ D1 2015-09-18 19-4\10-2 WBIQ D1 2015-09-18 19-4 - Saved Time-shifting.jtv)
0012772: 140207917623040: General: CFileSystemManager::AnalyzeDrive: Drive does not exist (drive: Q:, filename: Q:\Video\JRiver\TV Recording\6-1 WBRC 2015-09-20 15-44\6-1 WBRC 2015-09-20 15-44 - Saved Time-shifting.jtv)

Title: Re: Old TV timeshifting directories not being removed from database
Post by: Yaobing on February 24, 2019, 07:02:05 pm

The folders are not automatically cleaned up.  You can run "Clean up time-shifting folders" from time to time.  However, the tool only cleans up folder with incomplete files.  Folders  that appear to contain a complete set of time-shifting files will be assumed to contain valid video and will not be cleaned.

Title: Re: Old TV timeshifting directories not being removed from database
Post by: BryanC on February 24, 2019, 07:17:01 pm

TV is not included in the MC for Linux feature set, so I cannot use the "clean up time-shifting folders" tool there.

I had to stop using the TV feature due to my region going encrypted so it is disabled on my Windows machines.

As a test, I re-enabled the TV feature on my Windows machine and ran the "clean up time-shifting folders" tool, yet according to the log it did not remove the offending stale database entries.

Code: [Select]

0011391: 8488: Import: GetNewFiles: Searching: M:\TV\
0011453: 8488: Import: GetNewFiles: Searching: M:\Movies\
0011516: 8488: Import: GetNewFiles: Searching: M:\Downloads\Complete\
0011578: 8488: Import: GetNewFiles: Finish (4953 ms)
0011578: 8488: Import: GetMissingAndUpdateFiles: Start
0011578: 8488: Import: GetMissingAndUpdateFiles: Getting files
0011578: 8488: Import: GetMissingAndUpdateFiles: Sorting files
0011578: 8488: Database: CMediaInfoArraySort::Sort: Files: 621; Elapsed ms: 2.062
0011578: 8488: Import: GetMissingAndUpdateFiles: Looping 621 files
0011641: 8488: General: CFileSystemManager::AnalyzeDrive: Drive does not exist (drive: F:, filename: F:\TV Recordings\6-1 WBRC 2012-02-19 22-7\6-1 WBRC 2012-02-19 22-7 - Saved Time-shifting.jtv, type: 1, attributes: 4294967295)
0011657: 8488: General: CFileSystemManager::AnalyzeDrive: Drive does not exist (drive: Q:, filename: Q:\Video\JRiver\TV Recording\6-1 WBRC 2015-09-20 15-44\6-1 WBRC 2015-09-20 15-44 - Saved Time-shifting.jtv, type: 1, attributes: 4294967295)
0011657: 8488: Import: GetMissingAndUpdateFiles: Finish (79 ms)

Title: Re: Old TV timeshifting directories not being removed from database
Post by: Yaobing on February 24, 2019, 08:56:22 pm

Sorry, my misunderstanding.

"Clean up time-shifting folders" tool cleans up your physical drive, not your database entries.  If a "... - saved time-shifting.jtv" entry exists in your database, it would appear under Video (occasionally under Documents).  You should find them and delete them, as they are your media files.

Title: Re: Old TV timeshifting directories not being removed from database
Post by: BryanC on February 25, 2019, 09:52:30 am

That's the problem, I cannot seem to find them at all.

I've tried creating a smartlist using

Code: [Select]

[=ismissing([filename])]=1 to find missing files but they are not there either.

Title: Re: Old TV timeshifting directories not being removed from database
Post by: Yaobing on February 25, 2019, 03:28:46 pm

Well, the log lines were produced when processing missing files.

Try this as a custom rule:

[=IsMissing()]=1

Title: Re: Old TV timeshifting directories not being removed from database
Post by: BryanC on February 25, 2019, 03:46:20 pm

I just tried

Code: [Select]

[=IsMissing()]=1 to no avail. Do you want me to e-mail you a copy of my library?

Title: Re: Old TV timeshifting directories not being removed from database
Post by: Yaobing on February 25, 2019, 04:25:36 pm

Yeah, please do.

Title: Re: Old TV timeshifting directories not being removed from database
Post by: Yaobing on February 25, 2019, 08:54:57 pm

Those files are in "Removed" database.  See attached screenshot.

TV recordings are put in Removed database when they are deleted so that MC knows not to record the same shows again.

You can create a smartlist using the rules as shown in the screenshot and delete the entries (since you no longer use the TV feature).

Title: Re: Old TV timeshifting directories not being removed from database
Post by: BryanC on February 25, 2019, 09:19:44 pm

TIL about the "Removed" database, thanks so much!