生产环境MySql1054

最新推荐文章于 2023-12-22 14:29:02 发布

Nolan_hu

最新推荐文章于 2023-12-22 14:29:02 发布

阅读量269

点赞数

分类专栏：技术总结文章标签： mysql java 运维

本文链接：https://blog.csdn.net/hu00848/article/details/109015753

版权

博客分析了在生产环境中遇到的MySQL1054错误，详细介绍了错误原因：参数错误，使用了未带引号的非数字参数以及查询中不存在的字段。通过排查确认，问题2是引发错误的主要原因。

摘要由CSDN通过智能技术生成

生产环境MySql1054

错误如下
- 分析
- 结论

错误如下

mservice-fi:(conn=3232237) Unknown error 1054
RequestContext: tenantId=cmhk-ierp, accountId=772929891338290176
SQL:  /*ORM*/  SELECT T2.faccttableid,T1.fvalue,T1.faccountpart,T1.flosscarryto,T1.fcopyfrom,T1.FOrgID,T1.fdpropertyid2,T1.fdpropertyid3,T1.fdpropertyid4,T1.fdpropertyid5,T1.fdpropertyid6,T1.fdpropertyid7,T1.fdpropertyid8,T1.fdpropertyid9,T1.fdpropertyid10,T1.fdpropertyid1,T1.FModelID,T1.FDimensionID,T1.FMemberID,T1.FDisablerID,T1.fparentid,T1.fmodifierid,T1.fcreatorid,T1.fentryrate,T2.fdataresource,T2.facctformula,T1.fislosscarry,T1.fexchange,T1.fshareall,T1.FIsYearEndCarried,T1.FIsRelateOrg,T1.FIsParticipMerge,T1.FDataType,T1.FDrCRDirect,T1.FAccountType,T1.FAccountUse,T1.fsimplename,T1.FSeq,T1.FIsSysMember,T1.FDescription,T1.FAggOprt,T1.FStorageType,T1.FDisableDate,T1.fisleaf,T1.flevel,T1.flongnumber,T1.fmasterid,T1.fmodifytime,T1.fcreatetime,T1.fenable,T1.fstatus,T1.fname,T1.fnumber,T1.FId FROM  T_BCM_StructOfAccount T1 LEFT JOIN T_BCM_StructOfAccount_S T2 ON T1.FId = T2.FId  WHERE  T1.FId= ? 
Parameters: [983127256563979264]
Key: btnok
TraceId：2e6b501d48b97065
Instance：mservice-fi-4401078016
发生时间：Sun Oct 11 15:52:03 GMT+08:00 2020
===================================================
调用堆栈：
java.sql.SQLException: (conn=3232237) Unknown error 1054
RequestContext: tenantId=cmhk-ierp, accountId=772929891338290176
SQL:  /*ORM*/  SELECT T2.faccttableid,T1.fvalue,T1.faccountpart,T1.flosscarryto,T1.fcopyfrom,T1.FOrgID,T1.fdpropertyid2,T1.fdpropertyid3,T1.fdpropertyid4,T1.fdpropertyid5,T1.fdpropertyid6,T1.fdpropertyid7,T1.fdpropertyid8,T1.fdpropertyid9,T1.fdpropertyid10,T1.fdpropertyid1,T1.FModelID,T1.FDimensionID,T1.FMemberID,T1.FDisablerID,T1.fparentid,T1.fmodifierid,T1.fcreatorid,T1.fentryrate,T2.fdataresource,T2.facctformula,T1.fislosscarry,T1.fexchange,T1.fshareall,T1.FIsYearEndCarried,T1.FIsRelateOrg,T1.FIsParticipMerge,T1.FDataType,T1.FDrCRDirect,T1.FAccountType,T1.FAccountUse,T1.fsimplename,T1.FSeq,T1.FIsSysMember,T1.FDescription,T1.FAggOprt,T1.FStorageType,T1.FDisableDate,T1.fisleaf,T1.flevel,T1.flongnumber,T1.fmasterid,T1.fmodifytime,T1.fcreatetime,T1.fenable,T1.fstatus,T1.fname,T1.fnumber,T1.FId FROM  T_BCM_StructOfAccount T1 LEFT JOIN T_BCM_StructOfAccount_S T2 ON T1.FId = T2.FId  WHERE  T1.FId= ? 
Parameters: [983127256563979264]
	at kd.bos.db.AbstractDBImpl.rethrow(AbstractDBImpl.java:400)
	at kd.bos.db.XDBImpl.query(XDBImpl.java:167)
	at kd.bos.db.AbstractDBImpl.query(AbstractDBImpl.java:140)
	at kd.bos