Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Reindex error after deleting subtasks via postfunction

We recently upgraded our Jira Server instance from 7.2.7 with Scriptrunner 5.4.28, and are now using Jira Server 8.13.3 with Scriptrunner 6.27.0.

I have a transition in a workflow which sends the issue back to draft status. One of the post functions is a ScriptRunner script that deletes all subtasks. There are a few other post functions performed after this, and then the transition is completed.

The transition worked perfectly without errors until we upgraded. Now it completes, and all post functions are performed successfully, including the deletion of the subtasks, but an error appears indicating indexing errors for the subtasks which were just deleted. This error prevents me from doing anything at all (not even acknowledging/dismissing the error) until I refresh the page. When I do refresh, everything appears to be good with the issue. All subtasks are gone, all all other changes were made successfully.

Please see this previous post I made regarding this problem.

Scriptrunner delete subtasks showing indexing errors... 

I am beginning to suspect that there is actually nothing wrong with the Scriptrunner post function, since the subtasks do get deleted.

I have run the integrity checker, with no errors found. I have run all the SQL checks that I've seen suggested here and there, and the only one that has returned any results is:

SELECT * from issue_version where deleted = 'Y';

The issues returned are in fact the subtasks I just deleted. But they DO NOT appear in the [jiraissue] table.

This is where I am stuck. Not sure if they're supposed to still be showing up in the [issue_version] table, or if them still being there is part of the problem.

0 answers

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

📅 Partner Webinar & Events Opportunities: July 2022

Hi community 👋, Here is another monthly roundup of the partner-organized events in July 2022. If there is any event missing please let me know in the comments below 🙏 If you're looking for Atla...

18 views 0 1
Read article

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