A second attack at the Fort Hood base revives memories of 2009 with the gunman – who took his own life – said to be US soldier who served in Iraq in 2011