Plex fails to start after latest container updated

Plex Media Server
1

Server Version#: Plex Media Server v1.43.1.10540-3972d551c
Player Version#: Not applicable

Post upgrade I found the below exception being thrown:

SQLITE3:0x80000001, 1, statement aborts at 19: [select distinct metadata_items.id, metadata_items.extra_data from media_items join media_streams on media_items.id=media_streams.media_item_id join metadata_items on metadata_items.id=media_items.metadata_item_id where media_streams.stream_type_id = 1 and ifnull(media_streams.extra_data ->> ‘ma:orientation’, ‘0’) in (‘6’, ‘8’)] malformed JSON

Using the DBRepair.sh tooling, I’ve done repairs, replaced to all 4 of the DB backups available (doing repairs before starting) but the problem is the same each time. I’ve moved backwards and forwards on PMS versions, but the issue remains.
Is there anyway to clean that data problem before I start from zero ?

2

Just stopped PMS, renamed the main DB (not the blobs DB), started PMS and added back the libraries.

  1. Each library was checked and all TV/Films rediscovered
  2. Continue Watching is blank now, which is fixable by watching an episode in each series again.
  3. Watched status of series and episodes is saved
  4. Intro and credits discovery still running.

But I’m happy to recover, but not sure how the DB issue wasn’t discovered by any of the scheduled tasks that touch the DB including optimize as my 4 backups are not valid. I have all scheduled tasks active. Perhaps shows that 12 days backups are not enough for discovering issues before its too late, will look at copying these backups into a longer term storage.
But for now I’ll live with the little issues remaining.