Possible unique constraint violation IX_228562AD for WorkflowMetricsIndexCreator having more than one virtual instance

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.3.X, Master
• Fix Version/s: 7.3.10.3 DXP SP3, 7.3.X, 7.4.13 DXP GA1, Master
• Component/s: Portal Services > Background Tasks, Workflow > Metrics
• Labels:
  • ee-ts
  • liferay-dxp-73-sp3
  • liferay-fix-pack-dxp-3-7310
  • liferay-fixpack-dxp-3-7310
• Branch Version/s:
  7.3.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/liferay-workflow/liferay-portal/pull/386

Reproducing Steps

1. Start Liferay.
2. Go to Control Panel > SYSTEM > Virtual Instances and add a new virtual instance.
3. Restart Liferay.
4. Look at the startup log.
   Expected: The startup log shows no errors.
   Observed: The startup log can show an ERROR: duplicate key value violates unique constraint "ix_228562ad" related to background task WorkflowMetricsIndexCreator

   2021-05-31 15:01:22.196 ERROR [liferay/background_task-2][JDBCExceptionReporter:234] Batch entry 0 insert into Lock_ (mvccVersion, uuid_, companyId, userId, userName, createDate, className, key_, owner, inheritable, expirationDate, lockId) values (0, '01a0fdd6-0b92-f95f-fa4d-188a330ae57b', 20102, 0, NULL, '2021-05-31 15:01:22.097+00', 'com.liferay.portal.kernel.backgroundtask.BackgroundTaskExecutor', 'com.liferay.portal.workflow.metrics.internal.background.task.WorkflowMetricsReindexBackgroundTaskExecutor#WorkflowMetricsIndexCreator', 'WorkflowMetricsIndexCreator#79305', 'FALSE', NULL, 79307) was aborted: ERROR: duplicate key value violates unique constraint "ix_228562ad"_  Detail: Key (classname, key_)=(com.liferay.portal.kernel.backgroundtask.BackgroundTaskExecutor, com.liferay.portal.workflow.metrics.internal.background.task.WorkflowMetricsReindexBackgroundTaskExecutor#WorkflowMetricsIndexCreator) already exists.  Call getNextException to see other errors in the batch. [Sanitized]
   2021-05-31 15:01:22.197 ERROR [liferay/background_task-2][JDBCExceptionReporter:234] ERROR: duplicate key value violates unique constraint "ix_228562ad"_  Detail: Key (classname, key_)=(com.liferay.portal.kernel.backgroundtask.BackgroundTaskExecutor, com.liferay.portal.workflow.metrics.internal.background.task.WorkflowMetricsReindexBackgroundTaskExecutor#WorkflowMetricsIndexCreator) already exists. [Sanitized]
   2021-05-31 15:01:22.202 INFO  [liferay/background_task-2][LockLocalServiceImpl:308] Unable to acquire lock, retrying
   2021-05-31 15:01:22.261 INFO  [liferay/background_task-2][BackgroundTaskMessageListener:151] Unable to acquire lock, queuing background task 79305
   

Note: The problem is not systematic. An error in the logs can be forced with the attached script. WorkflowMetricsIndexCreatorRemoveCreateIndices.groovy