nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to resolve Database Deadlock on Jira?

Nguyễn Thành Hải_csv3l4

Hello,

I have some problems about the configuration Isolation level for Jira database. My Jira version is JIRA v7.10.1 and database is MSSQL 2012, I configed mode READ_COMMITTED_SNAPSHOT is ON recording by recommend Instance health checks. But there are many problems of data deadlock like attachment. Please help me to resolve this!!

Many thanks!

https://confluence.atlassian.com/jirakb/health-check-database-isolation-834225506.html?_ga=2.181695520.643115483.1561897842-508274146.1561897842

Instance health checks after configuration DB:

Troubleshooting and support tools.PNG

Accepted answers

Nic Brough -Adaptavist-

What is your connection string in the dbconfig.xml file?

Nguyễn Thành Hải_csv3l4

I created new database with isolation level of READ_COMMITTED_SNAPSHOT is ON and Jira is working well now. I have checked the data integrity and it's okie.

Thanks @Nic Brough -Adaptavist-

All comments

Nic Brough -Adaptavist-

What is your connection string in the dbconfig.xml file?

Nguyễn Thành Hải_csv3l4

dear Nic:

mssql jdbc:sqlserver://x.x.x.x;databaseName=JIRA_DB;autoCommit=false

Nic Brough -Adaptavist-

Ok, what SQL driver are you using? Should be able to see it in the system information page.

Nguyễn Thành Hải_csv3l4

I created new database with isolation level of READ_COMMITTED_SNAPSHOT is ON and Jira is working well now. I have checked the data integrity and it's okie.

Thanks @Nic Brough -Adaptavist-

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira