The commissioner of the Tennessee Department of Correction has resigned following a botched execution attempt where death row inmate Christa Pike was administered lethal injection twice but did not die.