Unions representing Northern Rail workers are backing cross party calls for an inquiry into whether operator Arriva should be stripped of the franchise.