200w条数据创建索引所遇问题二

最新推荐文章于 2024-05-26 16:36:18 发布

未具名

最新推荐文章于 2024-05-26 16:36:18 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏：错误笔记文章标签： lucene 索引

本文链接：https://blog.youkuaiyun.com/qq_26684469/article/details/80318461

错误笔记专栏收录该内容

46 篇文章

订阅专栏

本文介绍了当尝试从MySQL数据库中检索数据时遇到的数据包过大错误，并提供了详细的堆栈跟踪来定位问题。该错误通常发生在数据量超出服务器设置的最大允许包大小时。文章还提供了调整服务器设置以解决此问题的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误原因，请求数据量超过设定值

解决方案

Exception in thread "main" java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)
Caused by: org.hibernate.exception.GenericJDBCException: Unable to release JDBC Connection
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
	at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:208)
	at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.afterTransaction(LogicalConnectionManagedImpl.java:171)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.afterTransaction(JdbcCoordinatorImpl.java:282)
	at org.hibernate.internal.SessionImpl.afterOperation(SessionImpl.java:557)
	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1906)
	at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:366)
	at com.dht.main.LuceneIndex.main(LuceneIndex.java:20)
	... 5 more
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (13730769 > 10485760). You can change this value on the server by setting the max_allowed_packet' variable.
	at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:604)
	at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:407)
	at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2534)
	at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1749)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2159)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
	at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4916)
	at org.hibernate.engine.jdbc.connections.internal.PooledConnections.add(PooledConnections.java:68)
	at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.closeConnection(DriverManagerConnectionProviderImpl.java:195)
	at org.hibernate.internal.NonContextualJdbcConnectionAccess.releaseConnection(NonContextualJdbcConnectionAccess.java:46)
	at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:205)
	... 11 more