Why recurrence disgusted Nietzsche

We meet with several puzzles here. Zarathustra calls himself the advocate of the circle (the Eternal Recurrence of all things), and he calls this doctrine his abysmal thought. In the last verse of the first paragraph, however, after hailing his deepest thought, he cries: “Disgust, disgust, disgust!” We know Nietzsche’s ideal man was that “world-approving, exuberant, and vivacious creature, who has not only learnt to compromise and arrange with that which was and is, but wishes to have it again, AS IT WAS AND IS, for all eternity insatiably calling out da capo, not only to himself, but to the whole piece and play” (see Note on Chapter XLII.). But if one ask oneself what the conditions to such an attitude are, one will realise immediately how utterly different Nietzsche was from his ideal. The man who insatiably cries da capo to himself and to the whole of his mise-en-scene, must be in a position to desire every incident in his life to be repeated, not once, but again and again eternally. Now, Nietzsche’s life had been too full of disappointments, illness, unsuccessful struggles, and snubs, to allow of his thinking of the Eternal Recurrence without loathing—hence probably the words of the last verse.