Software is not supposed to be super stressful — the machines should do the heavy lifting
I’m sure there are a zillion exceptions to this that ppl will point out
Their boss demands unrealistic timelines, actively undermines them, their coworkers are difficult to deal with, etc. I've never met anybody that works as an SWE that is stressed out because they have to fix bugs or manually migrate DBs all the time, its nearly always the environment that is the root cause.
It's not really "exceptions" that will be pointed out. The reality is that someone if going to have to stop automating\simplifying and actually fix the bug or implement the feature. Or in the worst case debug the "brilliant" automation from the really chill guy that left the company last year :)