Upper limit for issue key / issue id in JIRA

Is there any limit on the number of issues in a project, what is the max number of issue id that jira supports ?

3 answers

1 accepted

agree there will be performance issues blocking the road before any one gets there, wanted to quick check if there is any other upper cap put by them on number of issues in the syste,.. anyways checked in table jiraissues as well where they store id and pkey.. id has datatype of number(18) which will verryy high from any organization's perspective. Thanks ofr your replies.

The ID is Long type, the answer would be (2^63)-1 as per javadoc,Long.MAX_VALUE = 9223372036854775807, Long.MIN_VALUE = -9223372036854775808

As Nic says you'll be dust before JIRA gets there (I dont believe there are any coded numeric limits on the ID, the reason being that you'll find scalability issues oh, just a little while before you get there), I can just imagine logging an issue "its the end of the world":

SUPPORT-9223372036854775807

Imagine 1K per issue. Thats still 8388608 TB of comment data :D

0 vote
Technically, it is only limited by the limits place on it by code, so a far higher number than you'll ever reach. In real life, your human usage will limit it well before the code.

yes that is what i want to know, what is the limit enforced by the code. You might be right that if limit is very high then it wont reach to that number/limit in our instance. but just want to know what that limit is.

I really don't know, but you don't stand a chance of getting anywhere near it. Millions is probably the easy, and very very understated answer. I'd guess at the code limit being whatever the highest number you can put in a java "long" object, but it really is one of those utterly pointless questions - the answer is irrelevant because you'll never get close to it.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

578 views 6 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you