Rt max ticket id

RT Users
1

Hi,
Maybe that sound as a stupid question but can you tell me what is the MAX value for a ticket ID? Is there a end-of-the-world ticket id limit?
I have been asked for this question and pretty sure that at 100000 it will still works but can find a way to confirm this.
If anyone can tell me it will be greatly appreciated.
Thanks!

Romain Pelissier

2

Hi,
Maybe that sound as a stupid question but can you tell me what is the MAX value for a ticket ID? Is there a end-of-the-world ticket id limit?
I have been asked for this question and pretty sure that at 100000 it will still works but can find a way to confirm this.
If anyone can tell me it will be greatly appreciated.
Thanks!

Romain Pelissier

Hi Romain,

According to the DB schema for PostgreSQL the ticket ID is defined to be
an integer which in SQL has a maximum of (2^31 - 1) which is the max. You
would need to log a lot of tickets to reach that. I do not know if there
are coding assumptions within RT that would preclude increasing that to
a bigint with a max of (2^63 -1).

Cheers,
Ken

3

Hi,
Maybe that sound as a stupid question but can you tell me what is the MAX value for a ticket ID? Is there a end-of-the-world ticket id limit?
I have been asked for this question and pretty sure that at 100000 it will still works but can find a way to confirm this.
If anyone can tell me it will be greatly appreciated.

I have instances with 300K tickets. And there is someone on this list
that send a setup around 1M tickets :wink:

So don’t worry …yet :wink:

Easter-eggs Sp�cialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - M�tro Gait�
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

4

Correct me if i’m wrong, but the Tickets id Field is int(11), this means: 99999999999 → 99.999.999.999 should be enough for this first time

Btw, we do around 1.000.000 Tks per week and still far away from this counter :wink:

torsten-----Ursprüngliche Nachricht-----
Von: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] Im Auftrag von Emmanuel Lacour
Gesendet: Mittwoch, 12. Juni 2013 09:33
An: rt-users@lists.bestpractical.com
Betreff: Re: [rt-users] RT MAX TICKET ID

On Tue, Jun 11, 2013 at 03:57:00PM -0400, romain.pelissier@bell.ca wrote:

Hi,
Maybe that sound as a stupid question but can you tell me what is the MAX value for a ticket ID? Is there a end-of-the-world ticket id limit?
I have been asked for this question and pretty sure that at 100000 it will still works but can find a way to confirm this.
If anyone can tell me it will be greatly appreciated.

I have instances with 300K tickets. And there is someone on this list that send a setup around 1M tickets :wink:

So don’t worry …yet :wink:

Easter-eggs Spécialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

RT Training in Seattle, June 19-20: http://bestpractical.com/training

Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius, Reiner Heiken, Holger Ketz (Stellv.), Jan-Hendrik Köstergarten (Stellv.), Bruno Mang, Christian Marnetté, Jens Wollesen, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Karl Gernandt

5

Hi,

Emmanuel is correct. I don’t see any problems in switching id column to
64bit integer type, use perl with 64bit integers and you
get 9,223,372,036,854,775,807 as max value.

For 32bit integer you get 2,147,483,647.On Wed, Jun 12, 2013 at 12:43 PM, Brumm, Torsten / Kuehne + Nagel / Ham GI-ID torsten.brumm@kuehne-nagel.com wrote:

Correct me if i’m wrong, but the Tickets id Field is int(11), this means:
99999999999 → 99.999.999.999 should be enough for this first time

Btw, we do around 1.000.000 Tks per week and still far away from this
counter :wink:

torsten

-----Ursprüngliche Nachricht-----
Von: rt-users-bounces@lists.bestpractical.com [mailto:
rt-users-bounces@lists.bestpractical.com] Im Auftrag von Emmanuel Lacour
Gesendet: Mittwoch, 12. Juni 2013 09:33
An: rt-users@lists.bestpractical.com
Betreff: Re: [rt-users] RT MAX TICKET ID

On Tue, Jun 11, 2013 at 03:57:00PM -0400, romain.pelissier@bell.ca wrote:

Hi,
Maybe that sound as a stupid question but can you tell me what is the
MAX value for a ticket ID? Is there a end-of-the-world ticket id limit?
I have been asked for this question and pretty sure that at 100000 it
will still works but can find a way to confirm this.
If anyone can tell me it will be greatly appreciated.

I have instances with 300K tickets. And there is someone on this list that
send a setup around 1M tickets :wink:

So don’t worry …yet :wink:

–
Easter-eggs Spécialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

–
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann
(Vors.), Dirk Blesius, Reiner Heiken, Holger Ketz (Stellv.), Jan-Hendrik
Köstergarten (Stellv.), Bruno Mang, Christian Marnetté, Jens Wollesen,
Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878,
Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz:
Contern/Luxemburg Geschäftsführender Verwaltungsrat: Karl Gernandt

–
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Best regards, Ruslan.

6

Hi,
Thanks for the information :slight_smile:
Romain

-----Message d’origine-----De : ktm@rice.edu [mailto:ktm@rice.edu]
Envoyé : 11 juin 2013 16:16
À : Pelissier, Romain (6045822)
Cc : rt-users@lists.bestpractical.com
Objet : Re: [rt-users] RT MAX TICKET ID

Hi,
Maybe that sound as a stupid question but can you tell me what is the MAX value for a ticket ID? Is there a end-of-the-world ticket id limit?
I have been asked for this question and pretty sure that at 100000 it will still works but can find a way to confirm this.
If anyone can tell me it will be greatly appreciated.
Thanks!

Romain Pelissier

Hi Romain,

According to the DB schema for PostgreSQL the ticket ID is defined to be
an integer which in SQL has a maximum of (2^31 - 1) which is the max. You
would need to log a lot of tickets to reach that. I do not know if there
are coding assumptions within RT that would preclude increasing that to
a bigint with a max of (2^63 -1).

Cheers,
Ken