lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jak Akdemir <jakde...@gmail.com>
Subject Re: DIH MySQLNonTransientConnectionException
Date Mon, 03 Jan 2011 15:52:01 GMT
Hi Mark,
I am not sure but, did you try to set datasource url parameter
autoReconnect=true in data-config.xml? It should be something like
jdbc:mysql://localhost:3306?...&autoReconnect=true

Sincerely,
Jak Akdemir

On Sun, Jan 2, 2011 at 4:32 AM, Mark <static.void.dev@gmail.com> wrote:

> I have recently been receiving the following errors during my DIH
> importing. Has anyone ran into this issue before? Know how to resolve it?
>
> Thanks!
>
> Jan 1, 2011 4:51:06 PM org.apache.solr.handler.dataimport.JdbcDataSource
> closeConnection
> SEVERE: Ignoring Error when closing connection
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
> Communications link failure during rollback(). Transaction resolution
> unknown.
>    at sun.reflect.GeneratedConstructorAccessor29.newInstance(Unknown
> Source)
>    at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>    at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
>    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
>    at com.mysql.jdbc.Util.getInstance(Util.java:382)
>    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
>    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
>    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
>    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
>    at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4751)
>    at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4345)
>    at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1564)
>    at
> org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:399)
>    at
> org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:390)
>    at
> org.apache.solr.handler.dataimport.DataConfig$Entity.clearCache(DataConfig.java:174)
>    at
> org.apache.solr.handler.dataimport.DataConfig$Entity.clearCache(DataConfig.java:165)
>    at
> org.apache.solr.handler.dataimport.DataConfig.clearCaches(DataConfig.java:332)
>    at
> org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:360)
>    at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:391)
>    at
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
> Jan 1, 2011 4:51:06 PM org.apache.solr.handler.dataimport.JdbcDataSource
> closeConnection
> SEVERE: Ignoring Error when closing connection
> java.sql.SQLException: Streaming result set
> com.mysql.jdbc.RowDataDynamic@71f18c82 is still active. No statements may
> be issued when any streaming result sets are open and in use on a given
> connection. Ensure that you have called .close() on any active streaming
> result sets before attempting more queries.
>    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934)
>    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
>    at
> com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:2724)
>    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1895)
>    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
>    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
>    at
> com.mysql.jdbc.ConnectionImpl.rollbackNoChecks(ConnectionImpl.java:4854)
>    at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4737)
>    at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4345)
>    at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1564)
>    at
> org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:399)
>    at
> org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:390)
>    at
> org.apache.solr.handler.dataimport.DataConfig$Entity.clearCache(DataConfig.java:174)
>    at
> org.apache.solr.handler.dataimport.DataConfig.clearCaches(DataConfig.java:332)
>    at
> org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:360)
>    at
> org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:391)
>    at
> org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message