No passage in the repertoire should cause pain. A very small number of exceptions can cause some tension that might be unavoidable (looking at you, Erlkönig).
In my mind, any problems with pain or tension are caused by too much tension in too many muscles and movements that are not coordinated right. With relaxed and efficient use of the body, these issues can be avoided.