Hi Jaouen,

I don't think you need to be worried: probably the alter table resetted the 
autoincrement value but the database is still preventing any collision, it's 
just filling the empty values (autoincrement normally doesn't fill all the 
values, sometimes there are gaps between IDs)

Worry if you get an actual duplicate ID

Juan Clavero | Perl Developer

> On 30. May 2018, at 09:41, JAOUEN Egareg <[email protected]> wrote:
> 
> Hi,
>  
>  
> After the upgrade from OTRS v5 to OTRS v6.0.7, I have noticed a change in the 
> article view : new articles are shown after the oldest one. After a little 
> investigation, new articles seem to have id with a lower value than older 
> articles.
> How is it possible ?
>  
> My older articles IDs start from value 327. And the newest articles IDs start 
> from 1 to 32 (for the moment).
> I am expecting some troubles when the article ID will reach the value 327…
> How to fix that point ?
>  
> My highest value for article ID is 9973 and the change appears exactly when I 
> migrated from v5.0.27 to v6.0.1.
>  
> Thanks,
>  
> Egareg  JAOUEN
> Ingénieur Recherche&Développement
> Tel : +33 2 31 35 34 81 │[email protected] 
> <mailto:[email protected]>
> ELITT
> 8 rue Léopold Sédar-Senghor - 14460 Colombelles - France │www.elitt.com 
> <http://www.elitt.com/>---------------------------------------------------------------------
> OTRS mailing list: otrs - Webpage: http://otrs.org/ <http://otrs.org/>
> Archive: http://lists.otrs.org/pipermail/otrs 
> <http://lists.otrs.org/pipermail/otrs>
> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs 
> <http://lists.otrs.org/mailman/listinfo/otrs>
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

Reply via email to