I've wasted 2 months of distributed computing time on just bad assumptions made by mistakes I made, so as noted below, in the big picture, that's a relatively minor loss. Does it set back science. Of course, but is it catastrophic, no.

As someone pointed out above, in fields where you collection and analysis times are measured in years if not decades you could run into trouble, but for chemistry and biology where you are at significantly shorter collection timescales, it isn't that big of an issie