Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.

Error: Duplicate entry '2147483647' for key 'PRIMARY'



We recently ran into an issue in which when we try to add a test case, an error modal would appear with the following:

Duplicate entry ‘2147483647’ for key ‘PRIMARY’

After doing some initial research, it appears the problem is related to the TestRail database. Googling the above error returns this StackOverflow thread[0] in which the problem was the maximum value for the INT type was being reached for a specific column in the database.

What needs to be done in order to fix this issue?