Suppose we have a random variable $$Y_i = i \text{ with probability } \frac{1}{i}$$ and $0$ otherwise. Here all the $Y_i$ are independent. We can redefine $X_i = Y_i -1 $ so that $E(X_i)=0$. Then the variance of $X_i$ is $(i-1)^2\cdot 1/i + (-1)\cdot(1-1/i) = i-1$ and $s_n=\sum_{i=1}^{n}(i-1)=\frac{n(n-1)}{2}$ Define $S_n = \sum_{i=1}^{n}X_i$.
One can check that the CLT does not apply here and that $\frac{S_n}{s_n}$ does not converge to the standard normal distribution.
Any thoughts on what is the limiting distribution and how to get it?




The Lindeberg Central Limit Theorem and Feller-Lévy condition establish that the limiting distribution is not a standard normal distribution. (Many thanks to @Q9y5 for pointing out the correct reading of the Lindeberg Central Limit Theorem vis-a-vis the Feller-Lévy condition).
The following statement of the Lindeberg Central Limit Theorem is based on Wikipedia (which cites Billingsley, 1986, p.369), but see also WolframMathWorld: Lindeberg-Feller Central Limit Theorem and WolframMathWorld: Lindeberg Condition.
Now you calculated $$\begin{align*} \sigma _{k}^{2} &= k - 1 \\ s_n^2 &= \frac{n(n-1)}{2} \end{align*}$$ So $$ \max _{k=1,\ldots ,n}{\frac {\sigma _{k}^{2}}{s_{n}^{2}}} = \frac{2(n-1)}{n(n-1)} = \frac{2}{n} \to 0 \quad \text{as $n \to \infty$} $$ hence the Feller-Lévy condition is satisfied.
But the Lindeberg condition does not hold for $\varepsilon = 1$, as follows: When $\varepsilon = 1$, note that if $n > 2$ then $$ \lvert n - 1 \rvert = \sqrt{(n-1)^2} = \sqrt{(n-1)(n-1)} > \sqrt{\frac{n}{2}(n-1)} = \varepsilon s_n $$ So for $n > 2$ $$\begin{align*} {E}\left[(X_{n}-\mu _{n})^{2}\cdot \mathbf{1}_{\left\{X_{n}:\left|X_{n}-\mu_{n}\right|>\varepsilon s_{n}\right\}}\right] &= {E}\left[(X_{n}-\mu _{n})^{2}\cdot \mathbf{1}_{\left\{X_{n} = n-1 \right\}}\right] \\&= (n-1)^2 \end{align*}$$ Therefore $$\begin{align*} \lim _{n\to \infty }{\frac {1}{s_{n}^{2}}}\sum _{i=1}^{n}\mathbb {E} \left[(X_{i}-\mu _{i})^{2}\cdot \mathbf {1} _{\left\{X_{i}:\left|X_{i}-\mu _{i}\right|>\varepsilon s_{n}\right\}}\right] &\geq \lim _{n\to \infty }{\frac{2(n-1)^2}{n(n-1)}} \\&= \lim _{n\to \infty }{2\frac{n^2 - 2n + 1}{n^2 - n}} > 0 \end{align*}$$