Fall back to direct cache write if tempfile creation on the same fs fails

Fall back to direct cache write if tempfile creation on the same fs fails #4430