Insertion error: Duplicate entry '5' for key 'PRIMARY'

I'm getting this error when creating a new site:

Insertion Error: Duplicate entry '5' for key 'PRIMARY' - The template was not applied. (New Blog Templates - While copying posts)

Any idea what's happening here?