There is no need to dump the whole table. The offending rows can be cleanly identified and selectively removed. – As long as one can still work with the database and it’s not damaged.
DELETE FROM STATISTICS_MEDIA WHERE account_id IS NULL;
Please see Plex Database sqlite file has more than doubled in 10 days for the complete procedure.
How big is the file when you compress it with ZIP or RAR (before removing the NULL rows)? Just in case, the developer likes to take a look.
