Get a list of the Videopreviewthumbnail generation queue

Plex Media Server Desktops & Laptops
1

Hey

Is there a way to query the api for the videopreviewthumbnail queue which is done via scheduled tasks?

1 Like
2

There is no endpoint published that I know of (I’m looking at the current list).
You’re asking to query the queue in real-time and get current queue contents?

3

Basically yes, looking for a way to determine how many items are left to generate thumbnails for.

4

I thought that is what you’re requesting.
There isn’t an endpoint available to even look at. I took a peek and there’s no method defined which outputs anything even close to any endpoint. It stays internal to the scanner and database when the butler runs. The database keeps track of completed thumbnails because that’s considered metadata

5

Any chance I can extract that from the .db?

6

I"m not entirely sure. How comfy are you with SQLITE on a live DB?

7

Downloaded the database backup so comfort level there is good. Looked at the tables but nothing screams “look here” to me :slight_smile:

SQL comfort level overall is around standing in front of a class room naked and realising it is not a dream. I assume its not as easy as select from tablewhatever where haspreviewthumbnails=no?

8

All I can do is to say "go with what you know and you’ll get there. "

9

Will do, thanks for your time, appreciate it.

10

hm, you gave me an idea. Assuming videopreviewthumbnails are stored in /var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Media/localhost/*/*/Contents/Indexes/whatever.bif ?

So if anyone stumbled across this thread:

expr `find /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Media/localhost/ -maxdepth 2 -mindepth 2 -type d |wc -l` - `find /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Media/localhost/ -name "*.bif"|wc -l`
1269

1269 items to go, roughly. I guess.

11

There is also this bif.stats.tar.gz (840 Bytes)

12

And ExportTools will tell you if a bif file is avail

13

And adding to self


Movie level 5, column Part Indexed

14

Thank you both, bif.stats show like 2/3 of my library not index, which is really possible.

Does plex periodically refresh the preview thumbnails?

15

No. That would be madness. :slight_smile:

Unless you regularly empty out your library and fill it fresh. (which can happen if your media storage is not internal to the Plex server device. Disable ‘Empty trash automatically after every scan’ if you use a NAS or external hard drives for media storage.)

16

Na its more or less internal. But the *.bifs are on the disk, 1161 dirs don’t have .bifs,
bifstats says though:

Completed Indexes Remaining Indexes Total Items

5678 9649 15327

it also says:

Currently creating index for:
Current index completion: %
Current index speed: x

17

Seems broken, several episodes more processed but Remaining Indexes did not change

Edit: Now it actually got more (no new files or library scan)

18

So since the bifstats.sql is not (no longer?) working I looked over it a bit and came to the conclusion that my sql skills are very limited. Anyhow this should give a somewhat? accurate count of remaining and failed items:

SELECT count(*) FROM media_parts INNER JOIN media_items ON media_parts.media_item_id = media_items.id INNER JOIN metadata_items ON media_items.metadata_item_id=metadata_items.id WHERE file NOT LIKE '' AND media_parts.extra_data NOT LIKE '%indexes=sd%'

If anyone with some knowledge of the layout and sql could look over it, would be appreciated.

1 Like
19

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.