I started getting the above error while trying to add a record to the database. The corresponding column is set to "auto_increment" and has a data type of "INT" with a length of 10.
Looking around the network, I see that this error can occur when an automatically growing column reaches its upper limit - however, in this case the table contains only 6342 records, and the column should be able to hold much more.
Indeed, the application in question is used in several installations, and in some cases an equivalent table with the same structure has many more records than this without an error.
Stranger, when I changed the data type of this column to "BIGINT", he solved the problem - although on other installations he remained the same with a lot of records.
Can anyone suggest any reasons why this problem could happen?
Thanks in advance.
source share