Two US soldiers are killed when an Iraqi soldier opens fire on them during a training exercise in northern Iraq, US and Iraqi officials say.