Inject fields from FieldIndexers - Slow

[Alvis Kūms]

Hello,

i'm struggling with slow Jira for long time, but finally found something in profiler

2019-06-17 15:52:33,040 | http-nio-8080-exec-12 | 952x2537x1 | alvis.kums | 5c8rt5
[24624.7ms] - QuickCreateIssue.execute()
[95.4ms] - DefaultIssueService.validateCreate
[16288.3ms] - DefaultIssueService.create
[4161.5ms] - DefaultIssueManager.reIndexIssues
[4157.0ms] - DefaultIssueIndexer.perform()
[4155.3ms] - Reindex issue(LINDA-8)
[4149.6ms] - Create issue document
[4103.1ms] - Inject fields from FieldIndexers
[45.4ms] - IssuePropertySearchExtractor.indexEntity()
[3.2ms] - Waiting for indexing result
[8032.2ms] [count: 2, avg: 4016.1ms] - DefaultIssueManager.reIndexIssues
[8029.8ms] [count: 2, avg: 4014.9ms] - DefaultIssueIndexer.perform()
[8028.3ms] [count: 2, avg: 4014.1ms] - Reindex issue(LINDA-8)
[8027.3ms] [count: 2, avg: 4013.6ms] - Create issue document
[8020.7ms] [count: 2, avg: 4010.4ms] - Inject fields from FieldIndexers
[3.0ms] [count: 2, avg: 1.5ms] - DevSummaryIssueSearchExtractor.indexEntity()
[3.3ms] [count: 2, avg: 1.7ms] - IssuePropertySearchExtractor.indexEntity()
[4017.8ms] - DefaultIssueManager.reIndexIssues
[4014.3ms] - DefaultIssueIndexer.perform()
[4013.6ms] - Reindex issue(LINDA-8)
[4013.5ms] - Create issue document
[4010.5ms] - Inject fields from FieldIndexers
[1.5ms] - DevSummaryIssueSearchExtractor.indexEntity()
[1.4ms] - IssuePropertySearchExtractor.indexEntity()
[2.2ms] - Waiting for indexing result

As i understand, Inject fields from FieldIndexers is the problem?

Also i found in logs, that Jira trying to do something with project, that is deleted, and i found in database lot of references of not existing project

2019-06-17 16:06:44,396 SdOffThreadEventJobRunner:thread-11 ERROR user.name 966x2599x1 1eyt3le 192.168.99.1 /secure/QuickCreateIssue.jspa [c.a.s.p.a.modules.rulewhen.ServiceDeskCommentCreatedEventWhenHandler] isApplicableProject failed
com.atlassian.servicedesk.api.BadRequestException: Error retrieving ProjectContext, project '10018' does not exist

Can that be somehow with that Inject fields?

[Alvis Kūms]

Anyone!?!?

[Alvis Kūms]

I will update this later,, maybe somebody else will get in this trouble and Jira support will ignore, as me, even if i'm paying them...

so..

I somehow went that this could be related with custom fields or LexoRank.

Used SQL profiling fount that for 3-4 seconds about there was about 600 request to databese about Lexorank. Its like its went in some stupid cycle.

So then i just did random things, and one that worked, i looked in LexoRank which Issue is with highest rank length and deleted that issue. Thats it.. Its stupid, because i lost Issue, but..that helped. Before that balanced, checked integrity and so on..and nothing helped... Delete issue and now jira fly in terms of speed