Unwanted mindfulness when you are trying to get into the flow state - also known to sports psychologists as "the yips".

Come to think of it, I wonder if coding burnouts / writer's block / analysis paralysis has the same underlying mechanism.