Jira のインデックス作成や課題の複製で "Indexing Completed with 1 errors" が返される
問題
症状 1
When cloning an issue, Jira throws the following exception but the cloned issue is created successfully:
Exception: com.atlassian.jira.index.IndexingFailureException: Indexing completed with 1 errorsAdditionally, the cloned issue contains a number of history items marked as completed "Just now" instead of the expected date and time and the following appears in the atlassian-jira.log file:
2015-03-03 09:48:31,927 http-bio-7615-exec-18 WARN sysadmin 588x145x1 1yymjr3 127.0.0.1 /secure/CloneIssueDetails.jspa [atlassian.jira.index.AccumulatingResultBuilder] Indexing failed for Issue - '213918'
2015-03-03 09:48:31,927 http-bio-7615-exec-18 WARN sysadmin 588x145x1 1yymjr3 127.0.0.1 /secure/CloneIssueDetails.jspa [atlassian.jira.index.AccumulatingResultBuilder] com.atlassian.jira.util.dbc.Assertions$NullArgumentException: parameter should not be null!
java.lang.RuntimeException: com.atlassian.jira.util.dbc.Assertions$NullArgumentException: parameter should not be null!
at com.atlassian.jira.index.DefaultIndex$Failure.<init>(DefaultIndex.java:123)
at com.atlassian.jira.issue.index.DefaultIssueIndexer$2.perform(DefaultIssueIndexer.java:208)
at com.atlassian.jira.issue.index.DefaultIssueIndexer$4$1.get(DefaultIssueIndexer.java:337)
at com.atlassian.jira.issue.index.DefaultIssueIndexer$4$1.get(DefaultIssueIndexer.java:333)
at com.atlassian.jira.index.SimpleIndexingStrategy.get(SimpleIndexingStrategy.java:9)
at com.atlassian.jira.index.SimpleIndexingStrategy.get(SimpleIndexingStrategy.java:5)
...
Caused by: com.atlassian.jira.util.dbc.Assertions$NullArgumentException: parameter should not be null!
at com.atlassian.jira.util.dbc.Assertions.notNull(Assertions.java:38)
at com.atlassian.jira.issue.changehistory.ChangeHistoryItem$Builder.on(ChangeHistoryItem.java:440)
at com.atlassian.jira.issue.changehistory.DefaultChangeHistoryManager.getAllChangeItems(DefaultChangeHistoryManager.java:204)
at com.atlassian.jira.issue.index.DefaultChangeHistoryRetriever.apply(DefaultChangeHistoryRetriever.java:44)原因
The changegroup table has an empty CREATED column.
症状 2
Reindexing Jira throws IndexingFailureException and the following appears in the atlassian-jira.log file:
2015-02-19 19:37:30,778 JiraTaskExectionThread-1 WARN sysadmin 1048x628x1 pkp67f 127.0.0.1 /secure/admin/IndexReIndex.jspa [atlassian.jira.index.AccumulatingResultBuilder] com.atlassian.jira.util.dbc.Assertions$NullArgumentException: parameter should not be null!
2015-02-19 19:38:31,244 JiraTaskExectionThread-1 ERROR sysadmin 1048x628x1 pkp67f 127.0.0.1 /secure/admin/IndexReIndex.jspa [jira.util.index.CompositeIndexLifecycleManager] Reindex All FAILED. Indexer: DefaultIndexManager: paths: [/opt/jira/jira_home/caches/indexes/comments, /opt/jira/jira_home/caches/indexes/issues, /opt/jira/jira_home/caches/indexes/changes]
com.atlassian.jira.index.IndexingFailureException: Indexing completed with 99 errors
at com.atlassian.jira.index.AccumulatingResultBuilder$CompositeResult.await(AccumulatingResultBuilder.java:192)
at com.atlassian.jira.issue.index.DefaultIndexManager.doIndexIssuesInBatchMode(DefaultIndexManager.java:1021)
at com.atlassian.jira.issue.index.DefaultIndexManager.doStopTheWorldReindex(DefaultIndexManager.java:988)
at com.atlassian.jira.issue.index.DefaultIndexManager.access$300(DefaultIndexManager.java:92)
...原因
The changegroup table has an empty CREATED column.
症状 3
Reindexing Jira throws IndexingFailureException and the following appears in the atlassian-jira.log file:
2021-12-15 00:53:34,510+0000 IssueIndexer:thread-3 WARN sysadmin 950x6571x1 1diaqq5 127.0.0.1 /secure/admin/IndexReIndex!reindex.jspa [c.a.jira.index.AccumulatingResultBuilder] com.atlassian.jira.util.dbc.Assertions$NullArgumentException: parameter should not be null!
java.lang.RuntimeException: com.atlassian.jira.util.dbc.Assertions$NullArgumentException: parameter should not be null!
at com.atlassian.jira.index.DefaultIndex$Failure.<init>(DefaultIndex.java:100)
at com.atlassian.jira.issue.index.DefaultIssueIndexer$EntityOperation.lambda$perform$6(DefaultIssueIndexer.java:858)
at java.base/java.util.HashMap.forEach(HashMap.java:1336)
at com.atlassian.jira.issue.index.DefaultIssueIndexer$EntityOperation.perform(DefaultIssueIndexer.java:858)
at com.atlassian.jira.issue.index.DefaultIssueIndexer.lambda$processBatch$2(DefaultIssueIndexer.java:334)
at com.atlassian.jira.index.SimpleIndexingStrategy.apply(SimpleIndexingStrategy.java:7)
at com.atlassian.jira.index.SimpleIndexingStrategy.apply(SimpleIndexingStrategy.java:5)
at com.atlassian.jira.index.MultiThreadedIndexingStrategy$1.call(MultiThreadedIndexingStrategy.java:47)
at com.atlassian.jira.index.MultiThreadedIndexingStrategy$1.call(MultiThreadedIndexingStrategy.java:43)
at com.atlassian.jira.util.concurrent.BoundedExecutor$2.call(BoundedExecutor.java:68)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: com.atlassian.jira.util.dbc.Assertions$NullArgumentException: parameter should not be null!
at com.atlassian.jira.util.dbc.Assertions.notNull(Assertions.java:32)
at com.atlassian.jira.issue.changehistory.ChangeHistoryItem$Builder.on(ChangeHistoryItem.java:381)
at com.atlassian.jira.issue.history.AbstractDateRangeBuilder.changeItemBuilder(AbstractDateRangeBuilder.java:97)
at com.atlassian.jira.issue.history.VersionDateRangeBuilder.createInitialChangeItem(VersionDateRangeBuilder.java:69)原因
The jiraissue table has an empty CREATED column.
Diagnostic Steps
症状 1
Run the following query, replacing <ISSUENUM> and <PKEY> with the respective issue key and PKEY of the project:
select * from changegroup where CREATED is null and issueid in (select id from jiraissue where issuenum=<ISSUENUM> and project in (select id from project where pkey='<PKEY>'));If the query returns any entries, the instance is affected by this problem.
The Issue - '213918' record in the log snippet above corresponds to issue ID in the jiraissue table.
症状 2
次のクエリを実行します。
select distinct issueid from changegroup where CREATED is null;If the query returns any entries, the instance is affected by this problem.
症状 3
次のクエリを実行します。
select * from jiraissue where created IS NULLIf the query returns any entries, the instance is affected by this problem.
ソリューションまたは回避策
Before your begin
Back up the database so that the changes can be rolled back in case of any problems.
Resolving the cause of symptoms 1 and 2
If your instance is displaying symptoms 1 or 2, do the following:
- Jira インスタンスを停止します。
Manually update the changegroup table with a date value to retain history. For example:
update changegroup set CREATED='2015-01-01 00:00:00' where CREATED is null;- Jira を起動します。
- If required, perform reindexing.
Resolving the cause of symptom 3
If your instance is displaying symptom 3, do the following:
- Jira インスタンスを停止します。
From the Jira user interface, delete the issues listed in the output of the diagnostic step for symptom 3.
If Jira does not allow you to remove the issues, run the following database query, replacing
<ISSUE_IDs>with a comma-separated list of the issue IDs obtained in the output of the diagnostic step:delete from jiraissue where id in (<ISSUE_IDs>);例:
delete from jiraissue where id in (10101, 10102, 10103, 10104, 10105);- Jira を起動します。
- If required, perform reindexing.