Known issue with the clustermessage table in Assets for Data Center
This can now be configured directly in Jira from version 8.13:
- From the Jira Admin page select System > Advanced > Services.
- Set up cluster messaging flush service retention period.
There is a known issue with importing large datasets in Assets for Data Center in a short period of time. Assets is using Atlassian Cache API to replicate data between nodes, where the Jira table "clustermessage" can fill up with data and cause performance issues in Jira. Since the Jira default retention period is very high (30 days) we recommend to delete the Assets-related messages from that table every 24 hours.
Below is an example of the Assets-related messages that should be deleted. Doing so won't affect your Assets data in any way.
10255 | jira-cluster-7120-node1 | ALL|| INSIGHT_DATA_CACHE:-OBJECT_UPDATED_10|2019-05-14 11:19:08.427+00 10255 | jira-cluster-7120-node1 | ALL||INSIGHT_DATA_CACHE:-OBJECT_REMOVED_10|2019-05-14 11:19:08.427+00
A query example that can be used in order to clean the messages is the following:
DELETE FROM clustermessage WHERE message like '%INSIGHT%'