Hello,
Yesterday we install the plugin Agile in a production instance, and at the first moment all works fine. Before we test it in the developer instance. But yesterday the jira instance start to work too slow.
We try diferent acctons:
- Disable and disinstall the Agile Plugin
- restart the jira instance.
- restart the machine.
- Execute Integrity Checked.
The instance remain run slow, specialy in some projects.
And we found the big problem when we try to execute reindex. We execute a reindex biweekly and takes arround an hour and a half, but today I ejecute the reindex and after a hour only ejecute a 1%.
We stop it and try diferents actions:
- we Follow the intructions of https://confluence.atlassian.com/jirakb/unable-to-rebuild-jira-application-indexes-228623566.html.\\ - Ejecute a integrity check again.
- Ejecute the querries to check the data:
SELECT id,issuenum,project FROM jiraschema.jiraissue WHERE issuenum IS NULL;
SELECT * FROM jiraschema.issuelink WHERE linktype NOT IN (SELECT id FROM jiraschema.issuelinktype);
select * from jiraschema.changegroup where created is null order by issueid;
But when rerun the index the result is the same, 1% after 25 minutes.
Cuold anybody help?
