KB Article #176742
"Duplicate entry '9223372036854775807' for key 1" error
Problem
On startup of SecureTransport, the following error is thrown repeatedly (and also shows up in the logs):SQLExecute failed.
The driver reported the following diagnostics whilst running (SQLExecute):
PID=32454: 01-14-2015 18:39:44..904545: 23000: 1: 1062: [MySQL][ODBC 3.51 Driver][mysqld-5.0.72-enterprise-log]Duplicate entry '9223372036854775807' for key 1
(Alternatively, the error may contain the number -9223372036854775808 instead.)
Resolution
This indicates an integer overflow. (The values above are, respectively, the max and min values of a 64-bit field.) The cause is that the logging_event table's ID incrementation has reached the maximum; this would occur if there are old entries that were not archived.
The fix for this is to truncate the following tables (back them up first, if you want):
logging_event
logging_event_exception
logging_event_property
and then restart the SecureTransport services.