DataImportHandler Error (SEVERE: Ignoring Error when closing connection)

2009-11-09 Thread Pradeep Pujari
I am getting the following error in solr/trunk code while do a full-dataimport 
from db2 database.

INFO: Read dataimport.properties
Nov 9, 2009 1:02:55 PM org.apache.solr.handler.dataimport.SolrWriter persist
INFO: Wrote last indexed time to dataimport.properties
Nov 9, 2009 1:02:55 PM org.apache.solr.handler.dataimport.DocBuilder execute
INFO: Time taken = 0:0:2.704
Nov 9, 2009 1:02:55 PM org.apache.solr.handler.dataimport.JdbcDataSource 
closeConnection
SEVERE: Ignoring Error when closing connection
com.ibm.db2.jcc.a.SqlException: java.sql.Connection.close() requested while a 
transaction is in progress on the connection.The transaction remains active, 
and the connection cannot be closed.
at com.ibm.db2.jcc.a.p.r(p.java:1385)
at com.ibm.db2.jcc.a.p.u(p.java:1419)
at com.ibm.db2.jcc.a.p.s(p.java:1395)
at com.ibm.db2.jcc.a.p.close(p.java:1378)
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:173)
at 
org.apache.solr.handler.dataimport.DataConfig.clearCaches(DataConfig.java:331)
at 
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:339)
at 
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
at 
org.apache.solr.handler.dataimport.DataImporter$3.run(DataImporter.java:370)




Re: DataImportHandler Error (SEVERE: Ignoring Error when closing connection)

2009-11-09 Thread Noble Paul നോബിള്‍ नोब्ळ्
this should not cause any harm. it is just closing the connection at
the end of the process. But the stacktrace could be avoided

On Tue, Nov 10, 2009 at 2:39 AM, Pradeep Pujari prade...@rocketmail.com wrote:
 I am getting the following error in solr/trunk code while do a 
 full-dataimport from db2 database.

 INFO: Read dataimport.properties
 Nov 9, 2009 1:02:55 PM org.apache.solr.handler.dataimport.SolrWriter persist
 INFO: Wrote last indexed time to dataimport.properties
 Nov 9, 2009 1:02:55 PM org.apache.solr.handler.dataimport.DocBuilder execute
 INFO: Time taken = 0:0:2.704
 Nov 9, 2009 1:02:55 PM org.apache.solr.handler.dataimport.JdbcDataSource 
 closeConnection
 SEVERE: Ignoring Error when closing connection
 com.ibm.db2.jcc.a.SqlException: java.sql.Connection.close() requested while a 
 transaction is in progress on the connection.The transaction remains active, 
 and the connection cannot be closed.
        at com.ibm.db2.jcc.a.p.r(p.java:1385)
        at com.ibm.db2.jcc.a.p.u(p.java:1419)
        at com.ibm.db2.jcc.a.p.s(p.java:1395)
        at com.ibm.db2.jcc.a.p.close(p.java:1378)
        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:173)
        at 
 org.apache.solr.handler.dataimport.DataConfig.clearCaches(DataConfig.java:331)
        at 
 org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:339)
        at 
 org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
        at 
 org.apache.solr.handler.dataimport.DataImporter$3.run(DataImporter.java:370)






-- 
-
Noble Paul | Principal Engineer| AOL | http://aol.com