A massive train strike across greater Sydney has been sensationally called off after the union and the NSW government met for crucial talks in the eleventh hour.