For things like picking a lock or climbing, if there's no immediate pressure or consequence for failure (like guards approaching) I usually allow retries, but with the understanding that continuous failure means it's probably too difficult for them right now.
For knowledge checks, a failed...