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

This widget could not be displayed.

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.

This widget could not be displayed.

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

This widget could not be displayed.
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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

55 views 1 0
Join discussion

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