过客的博客

你所浪费的今天,是昨天死去的人奢望的明天.你所厌恶的现在,是未来的你回不去的曾经...

200w条数据创建索引所遇问题一
下面问题在数据量较小时不会出现,是偶发事件,尝试第二次启动项目,没有报该错误,第三次启动filed'1995'变成了filed'24904',第四次又变成了filed'13369'
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: java.sql.SQLException: Unknown character set index for field '1995' received from server.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
	at com.mysql.jdbc.ConnectionImpl.getCharsetNameForIndex(ConnectionImpl.java:2824)
	at com.mysql.jdbc.Field.<init>(Field.java:198)
	at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:757)
	at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:408)
	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

阅读更多
版权声明:大家一起交流啊 https://blog.csdn.net/qq_26684469/article/details/80318412
文章标签: lucene 索引
个人分类: 错误笔记
想对作者说点什么? 我来说一句

JAVAEE开发中要注意的10个问题

2010年10月05日 123KB 下载

没有更多推荐了,返回首页

不良信息举报

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

最多只允许输入30个字

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭