Pessimistic locking fails with ObjectOptimisticLockingFailureException

Question

I use Spring Data JPA with Hibernate as persistence provider over PostgreSQL. I'm trying to provide pessimistic locking:

public interface MediaRepository extends JpaRepository<Media, Long>, MediaRepositoryCustom {
Long countByCreatedBy(User creator);

@Query("select m from Media m where m.id = ?1")
@Lock(LockModeType.PESSIMISTIC_WRITE)
Media findOneAndLock(Long id);
}

I try to call findOneAndLock from 2 threads. I expect that if Thread A locks object, Thread B should wait until the lock is released. But instead Thread B throws org.springframework.orm.ObjectOptimisticLockingFailureException.

I'm sure that both threads performs select for update (2 such records in database log).

score 1 · Answer 1 · answered May 28 '15 at 14:19

1

The default behavior is to not wait. You need to specify the wait period in the persistence.xml

<properties>
   <property name="javax.persistence.lock.timeout" value="1000"/>
</properties>

answered May 28 '15 at 14:19

Rohit

2,132
1
15
24

Whats the value? And the second thread will only wait for the configured time and NOT indefinitely. – Rohit May 28 '15 at 14:32
10000. Again, I catch org.springframework.orm.ObjectOptimisticLockingFailureException. – skozlov May 28 '15 at 14:37
Does this exception occur immediately or after 10 seconds? – Rohit May 28 '15 at 14:41
It occurs immediately and it's stack trace includes call to `findOneAndLock` – skozlov May 28 '15 at 14:43
Yes because its a hint and may not be applied always. read [here](https://docs.oracle.com/javaee/6/tutorial/doc/gkjiu.html). – Rohit May 28 '15 at 14:45
also [this](http://stackoverflow.com/questions/19266015/jpa-pessimistic-lock-attempt-never-times-out) – Rohit May 28 '15 at 14:48
I don't understand how that links relate to my problem – skozlov May 29 '15 at 08:24

Pessimistic locking fails with ObjectOptimisticLockingFailureException

1 Answers1