Let's take the simplest relation you know : the equality relation ($x \mathcal{R} y \Leftrightarrow x = y$).
Obviously this relation is transitive and is not acyclic.
More generally, if your relation is an equivalence relation, it is then transitive and symetric, so it cannot be acyclic.