It happens, even with a resource officer. See this LancasterOnLine post.

“The School Resource Officer reported the active shooter incident, but was not apparently in a position to fire his weapon before the killer committed suicide.” – bearingarms.com

Great response by the School District; immediate post at the Website.