Transcoding broken after latest update (only on certain files)

Plex Media Server NAS & Devices
21

Did you have top do anything special with the db or just be patient for a while on restart?

22

@esilberberg

Whenever you change versions, just be patient with that first-time startup on the changed version while the DB readjusts. (schema / trigger changes unique to the version)

23

Thanks Chuck.

Iā€™m doing an optimize, and a backup and about to patiently try a rollback to [1.29.2.6364-1-01] binhex-plexpass.

BTW I used your db tool the other day. Nice work.

24

Thanks.

Wait until you see the new tool release.

  1. Stop/Start PMS within the container.

  2. Command names instead of numbers

  3. ā€œAutomaticā€ mode.
    ā€“ DBRepair.sh stop auto start exit

  4. Date/Time stamping on all non-interactive output.

25

So much for patient. Iā€™m at 4 or 5 cycles of vacuumā€¦abort is that normal? About 11 minutes each.

snippet of 1 cycle follows.

SQLITE3:0x80000001, 17, statement aborts at 58: [select * from metadata_items limit 1] database schema has changed
Mar 13, 2023 14:33:08.996 [0x14d9db5410d0] INFO - Completed down migration 202212022100.
Mar 13, 2023 14:33:08.996 [0x14d9db5410d0] INFO - Running down migration 202212012300.031.
Mar 13, 2023 14:33:11.492 [0x14d9db5410d0] INFO - Completed down migration 202212012300.031.
Mar 13, 2023 14:33:11.492 [0x14d9db5410d0] INFO - Running down migration 202212012300.021.
Mar 13, 2023 14:33:11.493 [0x14d9db5410d0] INFO - Completed down migration 202212012300.021.
Mar 13, 2023 14:33:11.493 [0x14d9db5410d0] INFO - Running down migration 202212012300.011.
Mar 13, 2023 14:33:11.494 [0x14d9db5410d0] INFO - Completed down migration 202212012300.011.
Mar 13, 2023 14:33:11.494 [0x14d9db5410d0] INFO - Running down migration 202212012300.
Mar 13, 2023 14:33:11.496 [0x14d9db5410d0] INFO - Analyzing database.
Mar 13, 2023 14:33:11.727 [0x14d9db5410d0] INFO - Vacuuming database.

Longer version at plex rollback db logs - Google Docs

26

I gave up after an hour

27

Iā€™d still like to know what you think is broken with the transcoder.

(Sorry for being a bit confused as there only seems to be a few outlying cases now)

28

@ChuckPa Sorry I went dark, work has been crazy. Anywho, I just tested with the latest version and the files that didnā€™t work before now work.
Plex Version 1.31.2.6810
NVIDIA Driver version 525.78.01 (GTX 1660 Ti)

Last question, would it be advisable to update my NVIDIA driver? My choices are 525.89.02 or 530.30.02. Thanks!

29

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