查看: 4359|回复: 2

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

升级   0.26%

6

主题

3

回帖

26

积分

注册会员

Rank: 2

积分
26
发表于 2020-5-15 10:11:32 | 显示全部楼层 |阅读模式
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 ?, ?} [code=1038, state=HY00
回复

使用道具 举报

升级   0.26%

6

主题

3

回帖

26

积分

注册会员

Rank: 2

积分
26
发表于 2020-5-15 12:03:48 | 显示全部楼层
好的,谢谢
回复

使用道具 举报

升级   100%

139

主题

1万

回帖

4万

积分

超级版主

Rank: 8Rank: 8

积分
41458
发表于 2020-5-15 10:20:59 | 显示全部楼层
您好:
code=1038, state=HY00
1038 好像是你mysql 服务器内存不足,用于排序的内存不足,请增大排序缓冲区
回复

使用道具 举报

发表回复

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

联系客服 关注微信 下载APP 返回顶部 返回列表
viewthread