It sucks!
Beware of this when you want to use SELECT FOR UPDATE for pessimistic lock. without NOWAIT options, threads might be blocked due to locks.
Workaround: add timeout control in application level.
It sucks!
Beware of this when you want to use SELECT FOR UPDATE for pessimistic lock. without NOWAIT options, threads might be blocked due to locks.
Workaround: add timeout control in application level.