This is not exactly what Griffiths states.
By blowing up at infinity, do you mean a real-valued function [itex]f[/itex] of a real variable such that
[tex]\lim_{x \rightarrow \infty} f \left( x \right) = \infty?[/tex]
More precisely, this means that for every [itex]L > 0[/itex], there exists an [itex]x_0 > 0[/itex] with [itex]f \left( x \right) > L[/itex] whenever [itex]x > x_0.[/itex]
Using this property, it is fairly easy to show that [itex]\left| f \left( x \right) \right|^2[/itex] is a positive function that blows up at infinity, and that any positive function with this property is not integrable.
Or do you mean for every [itex]L > 0[/itex], there exists an [itex]x_0 > 0[/itex] with [itex]f \left( x \right) > L[/itex] for some [itex]x > x_0[/itex]?
There are lots of square-integrable functions with this property. For example, consider the real-valued function of a real variable that is zero except when [itex]x[/itex] is a rational number, and has [itex]f \left( x \right) = x[/itex] when [itex]x[/itex] is a rational number. Then, [itex]\left| f \left( x \right) \right|^2[/itex] integrates to zero. The function in this example is actually (a representative of) the zero vector in Hilbert space, since it differs from the zero function only on a set of measure zero,