Non-perturbative stability of supergravity and superstring vacua