mySQL error in logs; FAILED TRYING TO EXECUTE ON CONNECTION glide.6 (connpid=1106786): INSERT INTO ... java.sql.BatchUpdateException: (conn=1106786) Duplicate entry - Support and Troubleshooting

mySQL error in logs; FAILED TRYING TO EXECUTE ON CONNECTION glide.6 (connpid=1106786): INSERT INTO ... java.sql.BatchUpdateException: (conn=1106786) Duplicate entry Issue when some transaction happens we get the following type of MySQL error in the system logs or node logs:

FAILED TRYING TO EXECUTE ON CONNECTION glide.6 (connpid=1106786): INSERT INTO sys_metadata (`sys_updated_on`,`sys_class_name`,`sys_id`,`sys_updated_by`,`sys_created_on`,`sys_name`,`sys_scope`,`sys_created_by`,`sys_mod_count`,`sys_package`,`sys_update_name`,`sys_policy`) VALUES('2020-03-27 11:51:42','sys_dictionary_override','149e98f5737b0010491d235f04f6a783','admin','2020-03-27 09:36:59','assignment_group','global','admin',5,'ad08e515dba52018404d6e03ca9619ef','sys_dictionary_override_149e98f5737b0010491d235f04f6a783',NULL),INSERT INTO sys_dictionary_override (`calculation`,`read_only_override`,`mandatory`,`default_value_override`,`display_override`,`sys_id`,`base_table`,`calculation_override`,`read_only`,`dependent`,`element`,`mandatory_override`,`attributes_override`,`default_value`,`dependent_override`,`reference_qual_override`,`name`,`attributes`,`reference_qual`) VALUES(NULL,0,0,0,0,'149e98f5737b0010491d235f04f6a783','task',0,0,NULL,'assignment_group',0,1,NULL,0,0,'change_request','tree_picker=true,field_decorations=change_success_score',NULL) java.sql.BatchUpdateException: (conn=1106786) Duplicate entry 'change_request-assignment_group' for key 'name' Cause When submitting say a record or cat item When installing a plugin etc The problem is that the record already exists in the database and there is another process trying to insert the same record Resolution if the issue happens when you submit a record and can be reproduced, set the stack trace business rule on the table on record insert&update reproduce the issue and observe the stack trace of how the record was insert one stack trace should be out of the box process and another possibly custom

For the MySQL error in the description, the issue is that during plugin installation, the plugin installer was trying to insert a [sys_dictionary_override] record for a record that already existed in the table. The resolution would be to delete the record and reinstall the plugin.