A standoff between oil-producing nations and those demanding a transition from fossil fuels saw negotiations collapse two days into overtime at the UN climate talks.