Hi All,
i am facing closed connection issue while doing dataimporter, any solution
to this> stack trace is as below
[3/27/17 8:54:41:399 CDT] 000000b4 OracleDataSto > findMappingClass for :
Entry
java.sql.SQLRecoverableException: Closed
Connection
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3640)
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680)
at
oracle.jdbc.OracleConnectionWrapper.commit(OracleConnectionWrapper.java:140)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1113)
at
org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:432)
at
org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:421)
at
com.ibm.commerce.solr.handler.SchemaJdbcDataSource.close(SchemaJdbcDataSource.java:289)
at
org.apache.solr.handler.dataimport.DocBuilder.closeEntityProcessorWrappers(DocBuilder.java:294)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:283)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
[3/27/17 8:54:41:399 CDT] 000000b4 OracleDataSto < findMappingClass return
Exit
class
com.ibm.websphere.ce.cm.StaleConnectionException
[3/27/17 8:54:41:401 CDT] 000000b4 StaleConnecti 3 The stack trace for
the staleConn is:
java.sql.SQLRecoverableException: Closed
Connection
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3640)
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680)
at
oracle.jdbc.OracleConnectionWrapper.commit(OracleConnectionWrapper.java:140)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1113)
at
org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:432)
at
org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:421)
at
com.ibm.commerce.solr.handler.SchemaJdbcDataSource.close(SchemaJdbcDataSource.java:289)
at
org.apache.solr.handler.dataimport.DocBuilder.closeEntityProcessorWrappers(DocBuilder.java:294)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:283)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
[3/27/17 8:54:41:401 CDT] 000000b4 GenericDataSt < mapExceptionHelper:
Mapping was done returning: Exit
com.ibm.websphere.ce.cm.StaleConnectionException: Closed Connection
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:620)
at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:682)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2112)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1047)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1151)
at
org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:432)
at
org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:421)
at
com.ibm.commerce.solr.handler.SchemaJdbcDataSource.close(SchemaJdbcDataSource.java:289)
at
org.apache.solr.handler.dataimport.DocBuilder.closeEntityProcessorWrappers(DocBuilder.java:294)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:283)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
---- Begin backtrace for Nested Throwables
java.sql.SQLRecoverableException: Closed Connection
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3640)
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680)
at
oracle.jdbc.OracleConnectionWrapper.commit(OracleConnectionWrapper.java:140)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1113)
at
org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:432)
at
org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:421)
at
com.ibm.commerce.solr.handler.SchemaJdbcDataSource.close(SchemaJdbcDataSource.java:289)
at
org.apache.solr.handler.dataimport.DocBuilder.closeEntityProcessorWrappers(DocBuilder.java:294)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:283)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
[3/27/17 8:54:41:401 CDT] 000000b4 AdapterUtil 3 mapped to
com.ibm.websphere.ce.cm.StaleConnectionException; original exception is:
SQL STATE: 08003
ERROR CODE: 17008
java.sql.SQLRecoverableException: Closed Connection
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3640)
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680)
at
oracle.jdbc.OracleConnectionWrapper.commit(OracleConnectionWrapper.java:140)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1113)
at
org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:432)
at
org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:421)
at
com.ibm.commerce.solr.handler.SchemaJdbcDataSource.close(SchemaJdbcDataSource.java:289)
at
org.apache.solr.handler.dataimport.DocBuilder.closeEntityProcessorWrappers(DocBuilder.java:294)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:283)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
[3/27/17 8:54:41:402 CDT] 000000b4 InternalGener >
isAnAuthorizationException: Entry
com.ibm.websphere.ce.cm.StaleConnectionException: Closed Connection
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:620)
at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:682)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2112)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1047)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1151)
at
org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:432)
at
org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:421)
at
com.ibm.commerce.solr.handler.SchemaJdbcDataSource.close(SchemaJdbcDataSource.java:289)
at
org.apache.solr.handler.dataimport.DocBuilder.closeEntityProcessorWrappers(DocBuilder.java:294)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:283)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
---- Begin backtrace for Nested Throwables
java.sql.SQLRecoverableException: Closed Connection
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3640)
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680)
at
oracle.jdbc.OracleConnectionWrapper.commit(OracleConnectionWrapper.java:140)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1113)
at
org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:432)
at
org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:421)
at
com.ibm.commerce.solr.handler.SchemaJdbcDataSource.close(SchemaJdbcDataSource.java:289)
at
org.apache.solr.handler.dataimport.DocBuilder.closeEntityProcessorWrappers(DocBuilder.java:294)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:283)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
[3/27/17 8:54:41:402 CDT] 000000b4 InternalGener <
isAnAuthorizationException Exit
false
[3/27/17 8:54:41:402 CDT] 000000b4 AdapterUtil 3 Detected a connection
error.
[3/27/17 8:54:41:403 CDT] 000000b4 InternalGener >
isAnAuthorizationException: Entry
java.sql.SQLRecoverableException: Closed
Connection
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3640)
at
oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680)
at
oracle.jdbc.OracleConnectionWrapper.commit(OracleConnectionWrapper.java:140)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1113)
at
org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:432)
at
org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:421)
at
com.ibm.commerce.solr.handler.SchemaJdbcDataSource.close(SchemaJdbcDataSource.java:289)
at
org.apache.solr.handler.dataimport.DocBuilder.closeEntityProcessorWrappers(DocBuilder.java:294)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:283)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
[3/27/17 8:54:41:403 CDT] 000000b4 InternalGener <
isAnAuthorizationException Exit
false
[3/27/17 8:54:41:403 CDT] 000000b4 WSManagedConn >
moveToNextFailoverServer Entry
0
[3/27/17 8:54:41:403 CDT] 000000b4 WSManagedConn <
moveToNextFailoverServer Exit
<null>
[3/27/17 8:54:41:403 CDT] 000000b4 WSJdbcConnect > close Entry
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@2d3f2d3f
[3/27/17 8:54:41:403 CDT] 000000b4 WSJdbcConnect 1 state --> CLOSED
[3/27/17 8:54:41:403 CDT] 000000b4 WSJdbcConnect 3 Closing child wrappers
[3/27/17 8:54:41:403 CDT] 000000b4 WSJdbcStateme > close Entry
com.ibm.ws.rsadapter.jdbc.WSJdbcStatement@48674867
[3/27/17 8:54:41:403 CDT] 000000b4 WSJdbcStateme 1 state --> CLOSED
[3/27/17 8:54:41:403 CDT] 000000b4 WSJdbcStateme 3 Closing child wrapper
[3/27/17 8:54:41:403 CDT] 000000b4 WSJdbcResultS > close Entry
com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet@36163616
[3/27/17 8:54:41:403 CDT] 000000b4 WSJdbcResultS 1 state --> CLOSED
[3/27/17 8:54:41:405 CDT] 000000b4 WSJdbcResultS < close Exit
[3/27/17 8:54:41:405 CDT] 000000b4 WSJdbcStateme < close Exit
[3/27/17 8:54:41:405 CDT] 000000b4 GenericDataSt 3
doConnectionCleanupPerCloseConnection is not implemented
oracle.jdbc.driver.LogicalConnection@2e552e55
false
<null>
[3/27/17 8:54:41:405 CDT] 000000b4 WSJdbcConnect 3
doConnectionCleanupPerCloseConnection on [helper, mc, sqlCon, returned
value]
com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper@44ab44ab
WSRdbManagedConnectionImpl@3a4c3a4c
oracle.jdbc.driver.LogicalConnection@2e552e55
false
[3/27/17 8:54:41:405 CDT] 000000b4 WSJdbcConnect < close Exit
[3/27/17 8:54:41:405 CDT] 000000b4 WSRdbManagedC 1 Firing
CONNECTION_ERROR_OCCURRED event for handle:
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@2d3f2d3f
WSRdbManagedConnectionImpl@3a4c3a4c
[3/27/17 8:54:41:405 CDT] 000000b4 ConnectionEve > connectionErrorOccurred
eventID = 5 Entry
[3/27/17 8:54:41:405 CDT] 000000b4 ConnCloseLogi 3 Connection Error
Request Stack:
java.lang.Throwable
at
com.ibm.ejs.j2c.ConnectionEventListener.connectionErrorOccurred(ConnectionEventListener.java:441)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionErrorOccurredEvent(WSRdbManagedConnectionImpl.java:2438)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1919)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.fireConnectionErrorEvent(WSJdbcConnection.java:1971)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2210)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1047)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:1151)
at
org.apache.solr.handler.dataimport.JdbcDataSource.closeConnection(JdbcDataSource.java:432)
at
org.apache.solr.handler.dataimport.JdbcDataSource.close(JdbcDataSource.java:421)
at
com.ibm.commerce.solr.handler.SchemaJdbcDataSource.close(SchemaJdbcDataSource.java:289)
at
org.apache.solr.handler.dataimport.DocBuilder.closeEntityProcessorWrappers(DocBuilder.java:294)
at
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:283)
at
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
at
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
at
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
[3/27/17 8:54:41:406 CDT] 000000b4 ConnectionEve 3 ***Connection Error
Request*** Handle Name: com.ibm.ws.rsadapter.jdbc.WSJdbcConnection@2d3f2d3f,
Connection Pool: PoolManager name:jdbc/WebSphere Commerce Search Oracle
DataSource RBPRSTG
PoolManager object:1295600953
Total number of connections: 3 (max/min 55/0, reap/unused/aged 180/1800/0,
connectiontimeout/purge 180/EntirePool)
(testConnection/inteval false/0, stuck
timer/time/threshold 0/0/0, surge time/connections 0/-1)
Shared Connection information (shared partitions 200)
No shared connections
Free Connection information (free distribution table/partitions 27/1)
(0)(0)MCWrapper id 7cc87cc8 Managed connection
WSRdbManagedConnectionImpl@e870e87 State:STATE_ACTIVE_FREE
(0)(0)MCWrapper id 68b068b Managed connection
WSRdbManagedConnectionImpl@fdd0fdd State:STATE_ACTIVE_FREE
Total number of connection in free pool: 2
UnShared Connection information
MCWrapper id 2d232d23 Managed connection
WSRdbManagedConnectionImpl@3a4c3a4c State:STATE_ACTIVE_INUSE Thread Id:
000000b4 Thread Name: Thread-92 Handle count 1 Start time inuse Mon Mar 27
08:48:49 CDT 2017 Time inuse 351 (seconds)
Total number of connection in unshared pool: 1
Connection Leak Logic Information:
MCWrapper id 2d232d23 Managed connection
WSRdbManagedConnectionImpl@3a4c3a4c State:STATE_ACTIVE_INUSE Thread Id:
000000b4 Thread Name: Thread-92 Handle count 1
Start time inuse Mon Mar 27 08:48:49 CDT 2017 Time inuse 351 (seconds)
Last allocation time Mon Mar 27 08:48:49 CDT 2017
getConnection stack trace information:
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:900)
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:668)
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:635)
org.apache.solr.handler.dataimport.JdbcDataSource$1.getFromJndi(JdbcDataSource.java:213)
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:139)
org.apache.solr.handler.dataimport.JdbcDataSource$1.call(JdbcDataSource.java:129)
com.ibm.commerce.solr.handler.SchemaJdbcDataSource$1.call(SchemaJdbcDataSource.java:189)
com.ibm.commerce.solr.handler.SchemaJdbcDataSource$1.call(SchemaJdbcDataSource.java:1)
org.apache.solr.handler.dataimport.JdbcDataSource.getConnection(JdbcDataSource.java:392)
org.apache.solr.handler.dataimport.JdbcDataSource.access$200(JdbcDataSource.java:40)
org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:266)
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:236)
org.apache.solr.handler.dataimport.JdbcDataSource.getData(JdbcDataSource.java:40)
org.apache.solr.handler.dataimport.SqlEntityProcessor.initQuery(SqlEntityProcessor.java:59)
org.apache.solr.handler.dataimport.SqlEntityProcessor.nextRow(SqlEntityProcessor.java:73)
org.apache.solr.handler.dataimport.EntityProcessorWrapper.nextRow(EntityProcessorWrapper.java:243)
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:475)
org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:414)
org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:329)
org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:237)
org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:411)
org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:483)
org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:464)
, Details: MCWrapper id 2d232d23 Managed connection
WSRdbManagedConnectionImpl@3a4c3a4c State:STATE_ACTIVE_INUSE Thread Id:
000000b4 Thread Name: Thread-92 Handle count 1
[3/27/17 8:54:41:406 CDT] 000000b4 SharedLogWrit > prepare entry Entry
[3/27/17 8:54:41:406 CDT] 000000b4 SharedLogWrit < prepare entry Exit
[3/27/17 8:54:41:406 CDT] 000000b4 SharedLogWrit > writeDataAndHeader Entry
[3/27/17 8:54:41:406 CDT] 000000b4 SharedLogWrit 3 writeDataAndHeader -
writing 2686 bytes to location 1781784
[3/27/17 8:54:41:406 CDT] 000000b4 SharedLogWrit 3 writeDataAndHeader -
write complete, filePointer = 1784470
[3/27/17 8:54:41:406 CDT] 000000b4 SharedLogWrit 3 writeDataAndHeader -
freeSpace ptr = 1784470
[3/27/17 8:54:41:406 CDT] 000000b4 SharedLogWrit < writeDataAndHeader Exit
--
Regards,
Santosh Sidnal
