• chaorace@lemmy.sdf.org
    link
    fedilink
    English
    arrow-up
    2
    ·
    edit-2
    9 months ago

    There was a YouPoll outage that clogged up the bot, so a couple days worth of episode discussion posts got posted all at once. That alone wasn’t too bad, but… then I decided to load up the Fall 2023 episode config while I was at it and fat-fingered in the Winter 2023 episode config instead (AKA: the already finished season from 9 months ago). I’m ashamed to say that this led to posting hundreds of pointless threads from one of the most boring seasons in recent memory – an embarassing and strictly human error on my part.

    Unfortunately these posts can’t really be effectively deleted because the pre-existing holo code which Shinobu uses as a base will just go and regenerate the missing threads. This regenerating issue could have been avoided had I taken an SQLite database backup beforehand… but as evidenced by the posts still being up I clearly failed to do that.

    Moving forward, my plan is to A) aggressively take database backups when loading seasonal episode configs in the future & B) conduct a pre-load sanity check on the contents of each seasonal episode config file prior to importing it as an added precaution against misreading filenames.