You are viewing a plain text version of this content. The canonical link for it is here.

Posted to solr-user@lucene.apache.org by Mark <st...@gmail.com> on 2011/01/02 03:32:19 UTC

DIH MySQLNonTransientConnectionException

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)

Re: DIH MySQLNonTransientConnectionException

Posted by Jak Akdemir <ja...@gmail.com>.

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 <st...@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)
>
>