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 │[email protected]
ELITT
8 rue Léopold Sédar-Senghor - 14460 Colombelles - France │www.elitt.com

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs