Recently upgraded from 5.0 to 5.5.1 After successful upgrade I was reviewing the logs and found :
Mon Mar 14 22:33:21 2011 [12841][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:33:21 2011 [20643][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:33:21 2011 [12839][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:33:22 2011 [15715][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:33:33 2011 [15714][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:33:46 2011 [20640][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:33:46 2011 [20641][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:34:03 2011 [20648][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:34:03 2011 [20648][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:34:04 2011 [20642][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:38:11 2011 [12841][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:38:12 2011 [20643][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:44:23 2011 [15715][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
Mon Mar 14 22:44:23 2011 [23794][-none-][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
I can't track down when its happening because it's constant! Does the first [..] give me useful info to track this down. The second [..] happens to be my UserID. I fear this is severely slowing down my system and may be causing some of my other gliches.
Linux Fedora 11
MySQL 5.1.47
PHP 5.2.13
I get so much great info from these forums but I had to post.
Did some research in the MySQL Forum and found this:
mysqlcheck --auto-repair=true -uroot -p <dbname>
Found the errors and corrected them. No more complaints from sugar![]()


LinkBack URL
About LinkBacks




Reply With Quote
Bookmarks