>This means it will try 2 times, not 2 seconds. to be seconds it must have a SECONDS clause.
Thanks, I will add the SECONDS clause.
>Doesn't look ok to me. What happens if the RLOCK() fails all times? After all, it tries only 20 times. This is very fast and it will fail very easy.
>So, the REPLACE will fire the message you said.
Yes, but it is normal that Waiting for lock stays there endless?