Defects
SBM: Notification server gives error "CannotAcquireLockException" and "LockAcquisitionException"
| ID: | D27932 | |
| Published: | 30 January 2023 | |
| Updated: | 16 February 2023 |
Defect Id
DEF347811
Originally Reported Against
SBM 12.0
Resolved In
SBM 12.0 Hotfix
Description
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(HibernateJpaDialect.java:267) ~[spring-orm-5.3.22.jar:5.3.22]
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233) ~[spring-orm-5.3.22.jar:5.3.22]
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:566) ~[spring-orm-5.3.22.jar:5.3.22]
