It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Inject fields from FieldIndexers - Slow

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?

1 answer

Anyone!?!?

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

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you