It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

AO - what happens when int Id's are exhausted?

AO ID are integers, as shown.

Out of curiosity, what happens to AO if you exhaust its postive ID range of 2,147,483,647, does it rollover and start using negatives or does the sky fall? Sure I could look at the source, but just maybe others might find this interesting?

2 answers

1 accepted

3 votes
Answer accepted

The short answer is: I don't know. Good question. Maybe we could warn or do some check of some sort… What were you thinking should happen?

Do you have a concrete use case where you fear you might reach this limit?

In any case, nothing prevents you from using Long for you entity IDs. For example I know the GreenHopper developers defined their own Entity parent class as:

public interface Entity extends RawEntity<Long>
	public long getID();

This should give you some room up to 9,223,372,036,854,775,807 ;-)

Note that AO is capable of migrating int IDs to long IDs if necessary, however I would advise choosing the type that will suit your expected usage as soon as possible. Of course.

Hmm, yes, that seems like a good thing, thanks for the pointer. Given JIRA uses long types, wouldnt it be consistent to default AO objects to use them for ID's by default too, ints just stand out...

Well, int has been the default ID type for AO for a little while, so I didn't want to change that. Maybe I should have…

Kudos to the AO developers if they have code that specifically addresses this situation. Anyway, it's likely that the database would die long before IDs are exhausted ;)

That is irrelevant if the codebase is incompatible because it uses int instead of long!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Teamwork

Listening out loud: how Fabian Lopez works on distributed teams

The start of the COVID-19 pandemic served as a forcing function to re-evaluate the way teams worked together. In fact, many companies are re-learning how to collaborate with their teams. As some move...

58 views 2 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