How often do promotions fuel attrition?

In theory, promotions should be a career highlight. A joyous occasion which is celebrated. A real...