The hard rock guitar legend had been suffering from cancer