634810060 发表于 2020-5-15 10:11:32

链接mysql后，新增人员信息时候报错，

Out of sort memory, consider increasing server sort buffer size {prepstmnt 736505380 SELECT DISTINCT t0.xid, t0.xgenderType, t0.xsignature, t0.xpinyin, t0.xpinyinInitial, t0.xdescription, t0.xname, t0.xemployee, t0.xunique, t0.xdistinguishedName, t0.xorderNumber, t0.xsuperior, t0.xpasswordExpiredTime, t0.xchangePasswordTime, t0.xlastLoginTime, t0.xlastLoginAddress, t0.xlastLoginClient, t0.xmail, t0.xweixin, t0.xqq, t0.xmobile, t0.xhiddenMobile, t0.xofficePhone, t0.xboardDate, t0.xbirthday, t0.xage, t0.xdingdingId, t0.xdingdingHash, t0.xzhengwuDingdingId, t0.xzhengwuDingdingHash, t0.xqiyeweixinId, t0.xqiyeweixinHash, t0.xopen1Id, t0.xopen2Id, t0.xopen3Id, t0.xopen4Id, t0.xopen5Id, t0.xfailureTime, t0.xfailureCount, t0.xcreateTime, t0.xupdateTime, t0.xsequence FROM ORG_PERSON t0 ORDER BY t0.xsequence DESC LIMIT ?, ?}

634810060 发表于 2020-5-15 12:03:48

好的，谢谢

论坛管理员 发表于 2020-5-15 10:20:59

您好：
code=1038, state=HY00
1038 好像是你mysql 服务器内存不足，用于排序的内存不足,请增大排序缓冲区
页: [1]
查看完整版本: 链接mysql后，新增人员信息时候报错，