Non-virgins, I need your advice!

I tried having sex for the first time with my boyfriend, I've never had sex before but I wasn't nervous or scared, I was actually really turned on and excited, but he couldn't put it in, the harder he tried, the more it hurt me, he just couldn't put anything in more than a finger. I'm really sad and upset with myself. is this normal on your first time?