数据库异常——超出列范围

发布时间:2020-08-15 05:54:23 作者:yerikyu
来源:网络 阅读:535

最近遇到的一个坑,我开发的项目竟然遇到了字符串过长的坑,先看下日志

9/19/2019 5:27:35 org.springframework.beans.BeanInstantiationException: Failed to instantiate : Constructor threw exception; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute query; SQL [select business0_.id as id119, business0_.b_id as b_id219, business0_.branch as branch419, business0_.description as descript419, business0_.jhi_level as jhi_leve519, business0_.name as name619, business0_.parent_id as parent_i819, business0_.tag as tag719 from business business0_]; nested exception is org.hibernate.exception.DataException: could not execute query
9/19/2019 5:27:35 PMCaused by: java.sql.SQLException: Out of range value for column 'parent_i819' : value
9/19/2019 5:27:35 PM at org.mariadb.jdbc.internal.com.read.resultset.rowprotocol.TextRowProtocol.getInternalLong(TextRowProtocol.java:312)
9/19/2019 5:27:35 PM at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getLong(SelectResultSet.java:1004)
9/19/2019 5:27:35 PM at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getLong(SelectResultSet.java:996)
9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterChainImpl.resultSet_getLong(FilterChainImpl.java:1184)
9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterAdapter.resultSet_getLong(FilterAdapter.java:1655)
9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterChainImpl.resultSet_getLong(FilterChainImpl.java:1180)
9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterAdapter.resultSet_getLong(FilterAdapter.java:1655)
9/19/2019 5:27:35 PM at com.alibaba.druid.filter.FilterChainImpl.resultSet_getLong(FilterChainImpl.java:1180)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.getRow(Loader.java:1562)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:732)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.proce***esultSet(Loader.java:991)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.doQuery(Loader.java:949)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
9/19/2019 5:27:35 PM at org.hibernate.loader.Loader.doList(Loader.java:2692)

日志中说到数据库值过大,看的我一愣一愣的,什么鬼!一个id居然过大??明明记得我在数据库设置的字符长度为512啊!不管了,面向谷歌运维

推荐阅读:
  1. 数据库连接异常
  2. 查看exchange用户邮箱数据库大小,并导出列表

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

数据库 列限制 字段过长

上一篇:独家揭秘 | 阿里怎么做双11全链路压测?

下一篇:一份针对160家企业公司采用SD-WAN调查报告

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》