2025-12-02 16:41:42,656 - ERROR - 单条记录写入失败：(pymysql.err.OperationalError) (1241, 'Operand should contain 1 column(s)')
[SQL: INSERT IGNORE INTO jira_task_bsw_deal (`Summary`, `Issue key`, `Issue id`, `Parent id`, `Issue Type`, `Status`, `Project key`, `Project name`, `Project type`, `Project lead`, `Project description`, `Project url`, `Priority`, `Resolution`, `Assignee`, `Reporter`, `Creator`, `Created`, `Updated`, `Last Viewed`, `Resolved`, `Affects Version/s`, `Fix Version/s`, `Component/s`, `Due Date`, `Labels`, `Description`, `Environment`, `Watchers`, `Log Work`, `Security Level`, total, `Custom field (Control No)`, `Custom field (Custom_1)`, `Custom field (Custom_2)`, `Custom field (Date of first Response)`, `Custom field (Experience Owner)`, `Custom field (Fixed in release)`, `Custom field (Found By)`, `Custom field (Found in HW version)`, `Custom field (Found in SW version)`, `Custom field (KOCHI Issue Type)`, `Custom field (KOCHI Issue Type Transition)`, `Custom field (Last Comment)`, `Custom field (Matter)`, `Custom field (Project Number)`, `Custom field (Rank)`, `Custom field (Realisation planned)`, `Custom field (Report Number)`, `Custom field (Report Type)`, `Custom field (Reported By)`, `Custom field (Risk)`, `Custom field (Start Date)`, `Custom field (Team)`, `Comment`, `Involvement of BSW`, `Date`, `ProjectNum`, `BSW Issue`, `Stack BSW Analyzed`, `Stack BSW Unanalyzed`, `Stack Total`, `BSW Involve`, `BSW Involve Unclosed`, `HorizontalExpansion Count`, `HorizontalExpansion PN`, `HorizontalExpansion Unfinished`, `HorizontalExpansion Delay`, `BSW Analysis Conclusions`, `Stack Classification`, `BSW Reason Classification`, `BSW Staff List`, `Found By Classification`, `High Priority Unanalyzed`, update_over_15, update_over_7, `Responsible`, `Email`, `BSW Analyzed`, `BSW Unanalyzed`) VALUES (%(Summary)s, %(Issue_key)s, %(Issue_id)s, %(Parent_id)s, %(Issue_Type)s, %(Status)s, %(Project_key)s, %(Project_name)s, %(Project_type)s, %(Project_lead)s, %(Project_description)s, %(Project_url)s, %(Priority)s, %(Resolution)s, %(Assignee)s, %(Reporter)s, %(Creator)s, %(Created)s, %(Updated)s, %(Last_Viewed)s, %(Resolved)s, %(Affects_Version/s)s, %(Fix_Version/s)s, %(Component/s)s, %(Due_Date)s, %(Labels)s, %(Description)s, %(Environment)s, %(Watchers)s, %(Log_Work)s, %(Security_Level)s, %(total)s, %(Custom_field_AControl_NoZ)s, %(Custom_field_ACustom_1Z)s, %(Custom_field_ACustom_2Z)s, %(Custom_field_ADate_of_first_ResponseZ)s, %(Custom_field_AExperience_OwnerZ)s, %(Custom_field_AFixed_in_releaseZ)s, %(Custom_field_AFound_ByZ)s, %(Custom_field_AFound_in_HW_versionZ)s, %(Custom_field_AFound_in_SW_versionZ)s, %(Custom_field_AKOCHI_Issue_TypeZ)s, %(Custom_field_AKOCHI_Issue_Type_TransitionZ)s, %(Custom_field_ALast_CommentZ)s, %(Custom_field_AMatterZ)s, %(Custom_field_AProject_NumberZ)s, %(Custom_field_ARankZ)s, %(Custom_field_ARealisation_plannedZ)s, %(Custom_field_AReport_NumberZ)s, %(Custom_field_AReport_TypeZ)s, %(Custom_field_AReported_ByZ)s, %(Custom_field_ARiskZ)s, %(Custom_field_AStart_DateZ)s, %(Custom_field_ATeamZ)s, %(Comment)s, %(Involvement_of_BSW)s, %(Date)s, %(ProjectNum)s, %(BSW_Issue)s, %(Stack_BSW_Analyzed)s, %(Stack_BSW_Unanalyzed)s, %(Stack_Total)s, %(BSW_Involve)s, %(BSW_Involve_Unclosed)s, %(HorizontalExpansion_Count)s, %(HorizontalExpansion_PN)s, %(HorizontalExpansion_Unfinished)s, %(HorizontalExpansion_Delay)s, %(BSW_Analysis_Conclusions)s, %(Stack_Classification)s, %(BSW_Reason_Classification)s, %(BSW_Staff_List)s, %(Found_By_Classification)s, %(High_Priority_Unanalyzed)s, %(update_over_15)s, %(update_over_7)s, %(Responsible)s, %(Email)s, %(BSW_Analyzed)s, %(BSW_Unanalyzed)s)]
[parameters: {'Summary': '[ProjectIssue]AUTOEVER包+AUTOEVER HSM，OTA SWAP失败[AEB_FBL_TEAM][HKMC_JG_P08878_SHVU_Appl/trunk]', 'Issue_key': 'KOCHI_PL-1316', 'Issue_id': '1234660', 'Parent_id': '1213479.0', 'Issue_Type': 'Sub-task', 'Status': 'Done', 'Project_key': 'P08878', 'Project_name': 'KOCHI_Software_Platform', 'Project_type': 'software', 'Project_lead': 'zhu44', 'Project_description': '', 'Project_url': '', 'Priority': 'Medium', 'Resolution': 'Done', 'Assignee': 'xia003', 'Reporter': 'xia003', 'Creator': 'xia003', 'Created': Timestamp('2025-02-25 03:42:00'), 'Updated': Timestamp('2025-08-20 06:02:00'), 'Last_Viewed': Timestamp('2025-12-01 19:26:00'), 'Resolved': Timestamp('2025-04-29 04:45:00'), 'Affects_Version/s': '', 'Fix_Version/s': '', 'Component/s': 'HorizontalExpansion_ProjectIssue', 'Due_Date': Timestamp('2025-03-25 00:00:00'), 'Labels': 'AEB_FBL_TEAM||CheckItOnOtherProject||HKMC_JG_P08878_SHVU_Appl/trunk||IssueManagement||KOCHI_PIKOSAR|', 'Description': '请查看关联的主Issue获取问题报告和解决策略', 'Environment': '', 'Watchers': '', 'Log_Work': '', 'Security_Level': '', 'total': 0, 'Custom_field_AControl_NoZ': '', 'Custom_field_ACustom_1Z': '', 'Custom_field_ACustom_2Z': '', 'Custom_field_ADate_of_first_ResponseZ': None, 'Custom_field_AExperience_OwnerZ': '', 'Custom_field_AFixed_in_releaseZ': '', 'Custom_field_AFound_ByZ': '', 'Custom_field_AFound_in_HW_versionZ': '', 'Custom_field_AFound_in_SW_versionZ': '', 'Custom_field_AKOCHI_Issue_TypeZ': '', 'Custom_field_AKOCHI_Issue_Type_TransitionZ': '', 'Custom_field_ALast_CommentZ': '', 'Custom_field_AMatterZ': '', 'Custom_field_AProject_NumberZ': '', 'Custom_field_ARankZ': '1|i3unj4:', 'Custom_field_ARealisation_plannedZ': '', 'Custom_field_AReport_NumberZ': '', 'Custom_field_AReport_TypeZ': '', 'Custom_field_AReported_ByZ': '', 'Custom_field_ARiskZ': '', 'Custom_field_AStart_DateZ': '', 'Custom_field_ATeamZ': '', 'Comment': '29.04.2025 04:44;yang002;此项目芯片也是S32K3，用的HSM不是AUTOEVER的，所以也不适用;;;||29.04.2025 04:45;yang002;不适用;;;', 'Involvement_of_BSW': 'error', 'Date': Timestamp('2025-12-02 02:27:31'), 'ProjectNum': 'P08878', 'BSW_Issue': 0, 'Stack_BSW_Analyzed': 0, 'Stack_BSW_Unanalyzed': 0, 'Stack_Total': 0, 'BSW_Involve': 0, 'BSW_Involve_Unclosed': 0, 'HorizontalExpansion_Count': 1, 'HorizontalExpansion_PN': 'P08878', 'HorizontalExpansion_Unfinished': 0, 'HorizontalExpansion_Delay': 0, 'BSW_Analysis_Conclusions': None, 'Stack_Classification': None, 'BSW_Reason_Classification': 'Analyzing-Unclassified', 'BSW_Staff_List': 'Yes', 'Found_By_Classification': None, 'High_Priority_Unanalyzed': 0, 'update_over_15': 0, 'update_over_7': 0, 'Responsible': '游承峰', 'Email': ['chengfeng.you@kostal.com', 'baokun.dong@kostal.com', 'dingfeng.she@kostal.com', 'yingying.shi@kostal.com', 'feng.yang@kostal.com', 'y2.zheng@external.kostal.com', 'xiaolong.liang@kostal.com'], 'BSW_Analyzed': 0, 'BSW_Unanalyzed': 0}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)，数据：{'Summary': '[ProjectIssue]AUTOEVER包+AUTOEVER HSM，OTA SWAP失败[AEB_FBL_TEAM][HKMC_JG_P08878_SHVU_Appl/trunk]', 'Issue key': 'KOCHI_PL-1316', 'Issue id': '1234660', 'Parent id': '1213479.0', 'Issue Type': 'Sub-task', 'Status': 'Done', 'Project key': 'P08878', 'Project name': 'KOCHI_Software_Platform', 'Project type': 'software', 'Project lead': 'zhu44', 'Project description': '', 'Project url': '', 'Priority': 'Medium', 'Resolution': 'Done', 'Assignee': 'xia003', 'Reporter': 'xia003', 'Creator': 'xia003', 'Created': Timestamp('2025-02-25 03:42:00'), 'Updated': Timestamp('2025-08-20 06:02:00'), 'Last Viewed': Timestamp('2025-12-01 19:26:00'), 'Resolved': Timestamp('2025-04-29 04:45:00'), 'Affects Version/s': '', 'Fix Version/s': '', 'Component/s': 'HorizontalExpansion_ProjectIssue', 'Due Date': Timestamp('2025-03-25 00:00:00'), 'Labels': 'AEB_FBL_TEAM||CheckItOnOtherProject||HKMC_JG_P08878_SHVU_Appl/trunk||IssueManagement||KOCHI_PIKOSAR|', 'Description': '请查看关联的主Issue获取问题报告和解决策略', 'Environment': '', 'Watchers': '', 'Log Work': '', 'Security Level': '', 'Custom field (Control No)': '', 'Custom field (Custom_1)': '', 'Custom field (Custom_2)': '', 'Custom field (Date of first Response)': None, 'Custom field (Experience Owner)': '', 'Custom field (Fixed in release)': '', 'Custom field (Found By)': '', 'Custom field (Found in HW version)': '', 'Custom field (Found in SW version)': '', 'Custom field (KOCHI Issue Type)': '', 'Custom field (KOCHI Issue Type Transition)': '', 'Custom field (Last Comment)': '', 'Custom field (Matter)': '', 'Custom field (Project Number)': '', 'Custom field (Rank)': '1|i3unj4:', 'Custom field (Realisation planned)': '', 'Custom field (Report Number)': '', 'Custom field (Report Type)': '', 'Custom field (Reported By)': '', 'Custom field (Risk)': '', 'Custom field (Start Date)': '', 'Custom field (Team)': '', 'Comment': '29.04.2025 04:44;yang002;此项目芯片也是S32K3，用的HSM不是AUTOEVER的，所以也不适用;;;||29.04.2025 04:45;yang002;不适用;;;', 'Involvement of BSW': 'error', 'Date': Timestamp('2025-12-02 02:27:31'), 'HorizontalExpansion PN': 'P08878', 'HorizontalExpansion Count': 1, 'HorizontalExpansion Unfinished': 0, 'total': 0, 'ProjectNum': 'P08878', 'BSW Staff List': 'Yes', 'BSW Involve': 0, 'BSW Involve Unclosed': 0, 'BSW Analyzed': 0, 'BSW Unanalyzed': 0, 'BSW Reason Classification': 'Analyzing-Unclassified', 'BSW Issue': 0, 'High Priority Unanalyzed': 0, 'update_over_15': 0, 'update_over_7': 0, 'Stack Total': 0, 'Stack BSW Analyzed': 0, 'Stack BSW Unanalyzed': 0, 'HorizontalExpansion Delay': 0, 'BSW Analysis Conclusions': None, 'Stack Classification': None, 'Found By Classification': None, 'Responsible': '游承峰', 'Email': ['chengfeng.you@kostal.com', 'baokun.dong@kostal.com', 'dingfeng.she@kostal.com', 'yingying.shi@kostal.com', 'feng.yang@kostal.com', 'y2.zheng@external.kostal.com', 'xiaolong.liang@kostal.com']}
最新发布
扫一扫
1505
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
