Pike survived a botched execution attempt in Tennessee on September 30 after receiving two doses of the lethal injection drug pentobarbital