It tears me up, it makes me very sad, and it's eating me up all definitely convey the same meaning.
It is eating me alive, however, also carries suggestions of being physically eaten.
However, if you were to say "(this painful situation) is eating me alive" it would be obvious what you meant, although I am not sure that the usage is so common.