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

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


#1

Hello,

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?

0: https://stackoverflow.com/questions/20442140/error-1062-23000-duplicate-entry-2147483647-for-key-primary