Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-2733

DIH - "Ignoring Error when closing connection" when send command "abort" in jdbc 5.1.17

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • 3.3
    • None
    • None
    • solr 3.3 , mysql 5.0 , jdbc 5.1.17

    Description

      When I "abort" command in dataimport handler. I get avobe error.
      I can't get this error in jdbc 5.1.12 but occure in 5.1.13

      Aug 29, 2011 10:10:19 PM org.apache.solr.handler.dataimport.JdbcDataSource closeConnection
      SEVERE: Ignoring Error when closing connection
      java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@11d8b7e4 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:2735)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1899)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
      at com.mysql.jdbc.ConnectionImpl.rollbackNoChecks(ConnectionImpl.java:4830)
      at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4716)
      at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4325)
      at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1557)
      at org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:401)
      at org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:392)
      at org.apache.solr.handler.dataimport.DataConfig$Entity.clearCache(DataConfig.java:171)
      at org.apache.solr.handler.dataimport.DataConfig.clearCaches(DataConfig.java:340)
      at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:367)
      at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:427)
      at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:408)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              fjvrln a
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: