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).

Rohit · Accepted Answer · 2015-05-28 14:19:48Z

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, 2015 at 14:19

Rohit

2,1621 gold badge15 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Rohit Over a year ago

Whats the value? And the second thread will only wait for the configured time and NOT indefinitely.

skozlov Over a year ago

10000. Again, I catch org.springframework.orm.ObjectOptimisticLockingFailureException.

Rohit Over a year ago

Does this exception occur immediately or after 10 seconds?

skozlov Over a year ago

It occurs immediately and it's stack trace includes call to findOneAndLock

Rohit Over a year ago

Yes because its a hint and may not be applied always. read here.

|

Collectives™ on Stack Overflow

Pessimistic locking fails with ObjectOptimisticLockingFailureException

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related