Delete Movie Entry?

[jondough]

Stumbled upon this (#321) discussion while trying to delete a test entry I made.

Is there a way we can run the cronjob manually that removes the entries based on the conditions you posted above? I have now waited two days and the test entry I made (through Plex) is still available? Also tried logging into the docker image but there is no sh or bash. Given that the buttons have been lessened to just 4 now on the actions screen would it not be possible to have a red delete button? It seems only right if there is an add button to also have a delete button from a ui perspective.

P.S. - Under Summary the movie count never changes (currently shows 1 Movies, 2 hours 22 minutes) but when I click into the movies it shows four movies found. I've tried to run regenerate summaries but it does not change. Again, these 4 movies have now been there for two days or more.

Running version 3.4.8 with a Postgres db both in docker.

Thanks.

[IgnisDa]

I think there's a bigger problem to be addressed than the movies not disappearing from the list pages. Summary calculation not working is a bug.

Can you turn on trace logging RUST_LOG=ryot=trace env variable and show me the logs around midnight (or whatever you have set your timezone to)?

ALso the logs when you regenerate the summary.

[jondough]

Sure, let me figure out how to connect to the docker instance pg db and I'll do a dump for you.

[jondough]

DB dump sent.

[IgnisDa]

Not sure what you used to generate the export. Can you use pg_dump which generates a single SQL file?

[jondough]

I used pg_dump to create a tar file of the db (ex: pg_dump -U postgres -W -F t postgres > db.tar). You should be able to import from that. I'll send you a single sql file just in case you have any issues though.

[IgnisDa]

ah yes, you have exported it in tar format, I would prefer the default.

[IgnisDa]

@jondough Thanks for bringing this up. There was a bug. I will publish v3.4.10 soon which should fix the cleanup logic.

Regarding your original question, I don't want to introduce new buttons to the UI. But you can change the schedule in which the cleanup cron job gets triggered by setting the SCHEDULER_USER_CLEANUP_EVERY env variable to 1. Default is 12, which means it gets triggered every 12 hrs.

[IgnisDa]

As for the summary being "incorrect", Ryot only counts media items with 100% progress, so your movies in progress were not being counted. I plan to fix this behavior, but there's some other major refactors I want to address before I get around to it.

[jondough]

Just tested with v3.4.10 and it did clean up the movie at 12am. Thanks again for the quick fix.