While generating a custom report connection to browser is closed

[Stavros Michael]

For the last 4 days several of our custom reports are failing to generate. After researching this is the outcome:

1. While generating a report (either html view or excel view) the connection to server is closed or a timeout error is shown.
2. From the logs I can see that the process of generating the data is keep working. Main loop on data is working until the end.
3. At the time that the connection to browser is closed a second loop on data (second execution on the report) is started automatically.
4. Once process is done from these zombie processes nothing is shown in browser or in excel as the connection to browser is lost.
5. As a result people are firing continusly the reports leading to many zombie processes on jira which at the end are consuming 100% CPU on the Linux machine.
6. Because of this JIRA is becoming unstable. People cannot navigate to pages, not able to search or do any activity.

Until now we hard restarted the machine, increase the db connection pool to 50 and delete and rebuild indexes.
We have no clue what is causing this and why is started suddently. No change done in our system prior this.

[Stavros Michael]

Our custom reports are several in-house developed JIRA Report Plugins. 

[GabrielleJ]

Who made those? Maybe they can help troubleshoot the issue

[Stavros Michael]

Hi Gab, I am the developer

[Volodymyr Krupach]

Probably the reason is that the server side code is slow and browser timeouts.

I suggest to debug the code to locate places that eat time. It can be that you need to add index to your plugin AO table or rewrite logic to optimize DB requests.