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


Description

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

Resolution