Optimize Database hangs half way through process

hey there guys. I’ve had an recurring issue lately, and it has to do with my TV Library. when I try to load my tv library, it will either return a “unexpected error loading library” or take a good solid minute to load. especially when I have it sorted by “most recently episode aired”. my movie libraries all load near instantly. long story short, as far as trouble shooting goes, I’ve tried running a repair on my database, restarting my server and computer, I’ve tried restoring from a backup database, I’ve even tried deleting the tv library altogether and starting fresh, but when I do, that fails as well. it gets stuck on “deleting section 6” also, as the title suggests, whenever I try optimizing the database, it gets halfway through the process. and just stops and never finishes… any tips on how to sort this out?

running pms on an iMac running Mac OS 11.5.2

here is a snap shot of my logs as Plex struggles to load the TV library