RandyWang 1 Posted May 11, 2017 Share Posted May 11, 2017 Hi: eset remote administrator server trace.log show "Error: Service [Thread c20]: Kernel start: Last starting module failed with: [MySQL][ODBC 5.1 Driver][mysqld-5.5.27]Duplicate entry '398-1048568' for key 'PRIMARY' (1062)" Does anyone know how to solve this problem? Thank you for your reply Link to comment Share on other sites More sharing options...
ESET Staff Thomas Fecke 3 Posted May 12, 2017 ESET Staff Share Posted May 12, 2017 (edited) The reason why the error has been generated is because there is already an existing value of 398-1048568 for the column ID in which you define it as PRIMARY KEY (values are unique) in the table you are inserting. Do you have any Problems with ERA? If not, just ignore it? If u want to solve the issue, Open the Database, check the Entry and maybe delete it. !!!BUT! Please Care, if u delete the wrong Entry, ERA will not work anymore!!!! Edited May 12, 2017 by Thomas Fecke Link to comment Share on other sites More sharing options...
RandyWang 1 Posted June 15, 2017 Author Share Posted June 15, 2017 hi Thomas Fecke First thank you for your reply, in fact, in my.cnf added SET GLOBAL general_log = 1, found '398-1048568' is in "tbld_computers_name" this table, as you expressed because the relationship is the primary key, not sure whether Deleting the entire table will solve the problem. And this problem occurred in the ERA6.4 upgrade to ERA6.5 ?, resulting in the user login when the database information asymmetry, can not login. Please tell me if there is a solution Thx Link to comment Share on other sites More sharing options...
ESET Staff janoo 11 Posted June 30, 2017 ESET Staff Share Posted June 30, 2017 Hi RandyWang, I am not sure if this could help to you, but for certain cases of failed database migration 6.4->6.5 there is a process how to fix it: http://help.eset.com/era_install/65/en-US/index.html?crashed_database.htm This is rather experimental/advanced process, so be careful and do not forget to backup your database before. Link to comment Share on other sites More sharing options...
RandyWang 1 Posted July 21, 2017 Author Share Posted July 21, 2017 hi janoo thank you for your reply, Hope that this piece of rest crushing database after upgrade from 6.4 to 6.5 can solve this problem, thank you again. Link to comment Share on other sites More sharing options...
Recommended Posts