One thing I have been somewhat curious about is computing geodesic deviation for tidal effect. Specifically, given separation vector $\xi^a$ between two nearby timelike geodesics and $V^c$ the velocity vector fields tangent to the geodesics, we have \begin{equation} \frac{D\xi^a}{d\tau^2} = R^{a}_{\,\,bcd}V^bV^c\xi^d\,. \end{equation} Suppose I have a static spherically symmetric metric given by Schwarzschild metric, which only depends on radial coordinate $r$. The first step in computing tidal force, as is well-known, seems to be simplifying this expression. For example, if I wish to know how geodesics converge when two particles are placed side by side along $\phi$ direction, I expect that along this direction particles come closer together, as we expect from radial nature of gravity.
However, to do this explicitly, naively what I would do is to calculate for $\xi^\theta$, and in particular I choose $\xi^a$ such that initially only $\xi^\phi$ is nonzero. Then if pick $V^c$ such that the particles are initially at rest; this would lead to (?) \begin{equation} \frac{D\xi^\phi}{d\tau^2} = R^{\phi}_{\,\,tt\phi}\xi^\phi\,. \end{equation} Here is the problem: for Schwarzschild geometry, it can be shown that $R^{\phi}_{\,\,tt\phi}$ vanishes on the horizon of the black hole. This cannot be correct expression for tidal force, then, since it should be nonzero.
Curiously, repeating these calculations for weak-field limits (or far-distance limit of Schwarzschild black holes) do give the correct $r^{-3}$ dependence because the higher order terms can be neglected, and this expression seems to give reasonable tidal force if I am some distance away from the horizon (say, $2r_H$). This is true also for the "sphaghettification" scenario where instead one is interested in radial scenario; again, the same method (but now with different component of Riemann tensor) also leads to vanishing tidal force at the horizon, but good in weak field or some distance away from horizon. The problem arises because the component of Riemann tensor above also has a contribution at the order of $M^2/r^4$ which neatly cancels the usual "tidal" contribution at $r=r_H$. What is going on here?
I am aware of calculation methods using tetrads, but I am trying to stick this to elementary GR as much as I can.
Note: the (?) mark was meant to show that similar expression seems to appear if I do use tetrad formalism, and it might be possible that I am missing something, but I cannot tell why at the moment.
Update: I think I found the solution (thanks to comment from @A.V.S), but for personal reasons, I will write down the solution myself some time in April.