OTRS6 - Upgrade from v5 to v6. article ID has changed

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 ? When I ran a SQL query about it, I can see the result below (SELECT * FROM article) : ID TICKET_ID ARTICLE_SENDER_TYPE_ID COMMUNICATION_CHANNEL_ID IS_VISIBLE_FOR_CUSTOMER SEARCH_INDEX_NEEDS_REBUILD INSERT_FINGERPRINT CREATE_TIME CREATE_BY CHANGE_TIME CHANGE_BY 1 235 1 1 1 0 15165-oE7fivzjkn1S57A8MZ2o9QfFsHXLZnHK 2018-05-25 18:11:30 3 2018-05-25 18:11:30 3 2 235 1 1 1 0 15147-LaE2kJ2uQoRK1vcL6ZHirYOYLWRUFnyU 2018-05-25 18:11:45 3 2018-05-25 18:11:45 3 3 235 1 1 1 0 1654-mEmoCnIgHweBLCSzJVdMBGMEHXyCA4Vl 2018-05-25 18:22:10 3 2018-05-25 18:22:10 3 … … … … … … … … … … … 31 1537 3 1 1 0 30105-qXC8qf4D9JOtxu5kSP1u6zrhJdG6wfKv 2018-05-28 14:40:15 1 2018-05-28 14:40:15 1 32 1862 1 1 1 0 28719-2qM68hcyIBkmBOBgGPXO5MR7fYKZL9nJ 2018-05-28 15:00:46 3 2018-05-28 15:00:46 3 327 194 1 1 1 0 NULL 2015-02-19 15:04:53 5 2015-02-19 15:04:53 5 328 195 1 1 1 0 NULL 2015-02-19 15:10:49 5 2015-02-19 15:10:49 5 329 196 1 1 1 0 NULL 2015-02-19 15:21:44 4 2015-02-19 15:21:44 4 330 197 1 1 1 0 NULL 2015-02-19 15:30:46 4 2015-02-19 15:30:46 4 … … … … … … … … … … … 9973 235 1 1 1 0 NULL 2018-05-25 16:34:04 3 2018-05-25 16:34:04 3 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 │egareg.jaouen@elitt.com ELITT 8 rue Léopold Sédar-Senghor - 14460 Colombelles - France │www.elitt.com

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
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 │egareg.jaouen@elitt.com mailto:egareg.jaouen@elitt.com 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
participants (2)
-
JAOUEN Egareg
-
Juan Manuel Clavero Almirón