Duplicate entry for key ‘group_key’

by

Your issue seems like a MySQL bug. I was reviewing the logs for our production server the other day and the error logs were filled with this error. I used the workaround below and the errors are gone.

SET SESSION max_heap_table_size=536870912;

SET SESSION tmp_table_size=536870912;

Source: http://bugs.mysql.com/bug.php?id=58081

More Related Contents:

  1. Get the new record primary key ID from MySQL insert query?
  2. Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?
  3. Is the primary key automatically indexed in MySQL?
  4. SQL keys, MUL vs PRI vs UNI
  5. What’s the difference between using INDEX vs KEY in MySQL?
  6. Multi-Column Primary Key in MySQL 5
  7. How do I specify unique constraint for multiple columns in MySQL?
  8. Select all columns except one in MySQL?
  9. MYSQL OR vs IN performance
  10. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  11. MySQL Conditional Insert
  12. Is there a MySQL option/feature to track history of changes to records?
  13. MySQL JOIN ON vs USING?
  14. How to store IPv6-compatible address in a relational database
  15. MySQL: View with Subquery in the FROM Clause Limitation
  16. MySql export schema without data
  17. Scaling solutions for MySQL (Replication, Clustering)
  18. MySQL show status – active or total connections?
  19. mysql check if numbers are in a comma separated list
  20. mySQL DataSource on Visual Studio 2012
  21. MySQL update case help
  22. limiting the rows to where the sum a column equals a certain value in MySQL
  23. Dump a mysql database to a plaintext (CSV) backup from the command line
  24. Mysql select distinct
  25. How would I use ON DUPLICATE KEY UPDATE in my CodeIgniter model?
  26. GROUP_CONCAT equivalent in Django
  27. Transpose rows into columns in MySQL
  28. Case Expression vs Case Statement
  29. Why in SQL NULL can’t match with NULL?
  30. mySQL regex in the where clause

Leave a Comment