Issue
- When trying to start a clean Liferay bundle with the Hypersonic database and no portal-ext.properties, the following exception is being encountered:
2024-07-22 18:47:13.741 ERROR [http-nio-8080-exec-6][BatchingBatch:134] HHH000315: Exception executing batch [java.sql.BatchUpdateException: integrity constraint violation: unique constraint or index violation: IX_D5E35599], SQL: insert into PortalPreferenceValue (mvccVersion, companyId, portalPreferencesId, index_, key_, largeValue, namespace, smallValue, portalPreferenceValueId) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
2024-07-22 18:47:13.748 ERROR [http-nio-8080-exec-6][SqlExceptionHelper:142] integrity constraint violation: unique constraint or index violation: IX_D5E35599
2024-07-22 18:47:13.790 ERROR [http-nio-8080-exec-6][AuthVerifierFilter:53] java.util.ConcurrentModificationException
java.util.ConcurrentModificationException: null
at com.liferay.portlet.PortalPreferencesImpl._retryableStore(PortalPreferencesImpl.java:518) ~[portal-impl.jar:?]
at com.liferay.portlet.PortalPreferencesImpl.setValue(PortalPreferencesImpl.java:304) ~[portal-impl.jar:?]
at com.liferay.portlet.PortalPreferencesImpl.setValues(PortalPreferencesImpl.java:334) ~[portal-impl.jar:?]
at com.liferay.enterprise.product.notification.web.internal.EPNManager.confirm(EPNManager.java:41) ~[?:?]
Environment
- Liferay 7.4+
Resolution
- This is an intermittent issue that should be resolved with the following steps:
1. Delete Liferay_Home > Data > Hypersonic folder
2. Restart the Tomcat