SBM: Notification server gives error "CannotAcquireLockException" and "LockAcquisitionException"

ID:    D27932
Published:    30 January 2023
Updated:    16 February 2023

Defect Id


Originally Reported Against

SBM 12.0

Resolved In

SBM 12.0 Hotfix


This happens when the database is used as the dump storage. This setting is in Configurator under Mail Servers > Notification Server > Other Settings. The setting is called "Dump files storage type" with the option "Database".

The error in the ns.log is:
ERROR 04-11-2022 01:36:26 [Notifications] -- While processing changes.   
org.springframework.dao.CannotAcquireLockException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.LockAcquisitionException: could not execute statement
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException( ~[spring-orm-5.3.22.jar:5.3.22]
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible( ~[spring-orm-5.3.22.jar:5.3.22]
at org.springframework.orm.jpa.JpaTransactionManager.doCommit( ~[spring-orm-5.3.22.jar:5.3.22]

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs