Sir Elton John has cancelled a second concert at short notice after doctors advised he was too ill to perform.