I have a few projects which I cannot delete. If I execute the delete project function in JIRA, the site loads forever and nothing happens. My user has JIRA System Administrators privileges and the correct schema is assigned to the projects as well. The projects are pretty small and dosen't contain a lot of issues.I already tried following:Restart JIRA (Windows Service)Integrity CheckCreate new IndexI don't find any exceptions messages like "Unable to delete ..." in the log file.What else can I do to delete those projects?Edit 1It seams like JIRA producing a deadlock. As soon as I click on delete, I find following in my MSSQL database:101 JIRA.BWOR.Test worklog 1358627883 KEY X (@P0 bigint,@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000))SELECT SOURCE_NODE_ID, SOURCE_NODE_ENTITY, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE FROM dbo.nodeassociation WHERE SOURCE_NODE_ID= @P0 AND SOURCE_NODE_ENTITY= @P1 AND SINK_NODE_ENTITY= @P2 AND ASSOCIATION_TYPE= @P3 jira GRONJIRA1 1 implicit_transaction SQL 101 JIRA.BWOR.Test worklog 1358627883 KEY X (@P0 bigint,@P1 nvarchar(4000),@P2 nvarchar(4000),@P3 nvarchar(4000))SELECT SOURCE_NODE_ID, SOURCE_NODE_ENTITY, SINK_NODE_ID, SINK_NODE_ENTITY, ASSOCIATION_TYPE, SEQUENCE FROM dbo.nodeassociation WHERE SOURCE_NODE_ID= @P0 AND SOURCE_NODE_ENTITY= @P1 AND SINK_NODE_ENTITY= @P2 AND ASSOCIATION_TYPE= @P3 jira GRONJIRA1 1 implicit_transaction SQLFind more information here . It also happens, if I delte an issue from those projects.Edit 2After further research, I notice that only issues with sub issues are affected. Even if I try to delete a sub issue, JIRA creats the deadlock. If I convert the sub issue to a regular issue, everything works fine.

Community
Q&A
Jira
Questions
Cannot delete projects (deadlock)

Les ticket sont terminés mais ne sont pas résolus. Savez-vous pourquoi?

Bonjour,

Nous n'arrivons pas à passer en état "résolu" nos tickets qui sont pourtant terminé. Cf ci-dessous. Savez-vous comment faire pour modifier la résolution ?

Merci pour votre aide !

3 answers

1 accepted

0 votes

Answer accepted

I disabled auto commit autoCommit=false for MSSQL in the dbconfig.xml, the issue never occured again. You will find further information in this KB283640022.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

@Chander Inguva I did. Have a look at my edit. It seams like a deadlock.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Did you try https://confluence.atlassian.com/display/JIRAKB/JIRA+times+out+when+deleting+project

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Les ticket sont terminés mais ne sont pas résolus. Savez-vous pourquoi?

3 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events