Continue watching gone in 10.9.11

[Khisanth Xanadu]

I just updated to the most recent version from 10.9.8 and when I go to the main page via chrome the continue watching section is completely gone.  Here's the pastebin, any ideas on how I can troubleshoot this?

https://pastebin.com/qp66ZvCx

[TheDreadPirate]

I see a lot of database error messages in the log, but those could be from the playback reporting plugin's database. Disable the playback reporting plugin, restart jellyfin, ctrl+f5 on the jellyfin home screen. Does anything change?

[Khisanth Xanadu]

Nope, nothing changed. When I go to plugin playback reporting says "status restart" and that's it. But continue watching doesn't show.

[TheDreadPirate]

Do the following.

Code:

sudo systemctl stop jellyfin
cd /var/lib/jellyfin/plugins/
sudo rm -rf "Playback Reporting*"  # There will likely be several of these folders, one for each version you've had in the past
cd /etc/jellyfin
sudo mv playback_reporting.xml playback_reporting.xml.bak
sudo systemctl start jellyfin

ctrl+f5 on the home page again. If that doesn't work, can you share a fresh jellyfin log? If there are still database errors, the DB may be corrupt. Possible from before you upgraded.

Has your disk with the database ever filled up? Or was jellyfin ever interrupted on the first start up after an upgrade?

[Khisanth Xanadu]

Okay, so the command to remove the folders didn't work, maybe I did something wrong but there were only two versions of the plugin folder, so I rm'd those manually. When I went to /etc/jellyfin there were no playback reporting xml files. I started the jellyfin service again, refreshed, and no change.

So, I didn't interrupt an upgrade. However, I did have a problems with my shares. I had them on a truenas and the lsi controller died on me, so I switched the share location for the movies to my backup nas (I know strange that I backup all my movies), I think at this point I still had continue watching, but I'm not 100% sure. When I got my trunas working again, I changed the share location of the movies, back to the original location.

The Jellyfin vm itself is kept on local storage, so I imagine the db would have been too?

Fresh logs:
https://pastebin.com/qN7N090H

[TheDreadPirate]

One thing I'm noticing now that I didn't see before was that the database errors are always preceded by an access to the "Resume" endpoint. I'm assuming that is the api endpoint that populates the continue watching row. And is not related to the playback reporting plugin.

My guess is that table is borked for some reason. Possibly from your shifting things around. Possibly not. Hard to say.

Hypothetically, if the move is "transparent" it shouldn't affect Jellyfin. Transparent meaning that the mount location, while going to different destinations, stays at the same location on the host running jellyfin. Ideally, the switch from one NAS to the other would have happened while Jellyfin was shutdown to ensure it didn't attempt to access that path while you were migrating.

I'm not sure what the least intrusive way you would "fix" this. If you know what WAS in continue watching, you could try going to each movie/show/episode and marking it as "watched".

[Khisanth Xanadu]

Sometimes ... the things you forget make you feel real dumb. I did not shut down jellyfin when I was changing the shares. So, I may have borked the DB and will restore a backup (yay for proxmox).

However, I just wanted to clarify, then whenever I watch a show or movie, it's never on the main page to allow me to resume from where I left off. Even if I find that episode and watch it, it always starts from the beginning. I will try the restore, and then update again of course.

[Khisanth Xanadu]

It was a corrupted database, as you suspected. The restore, well, restored everything. Thanks for your help and quick responses!