databus icon indicating copy to clipboard operation
databus copied to clipboard

EventProducerThread_person

Open rioleehit opened this issue 7 years ago • 0 comments

There is a exception in my computer. The Thread_person's connection is closed . I can't find out the reason.

2018-04-05 05:47:53,434 +1106 [EventProducerThread_person] (ERROR) {DBHelper} Invoking a rollback after the connection is closed 2018-04-05 05:47:53,435 +1107 [EventProducerThread_person] (ERROR) {person} readEventsFromAllSources exception:IO Error: The Network Adapter could not establish the connection java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:536) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:157) at com.linkedin.databus2.producers.db.OracleTxlogEventReader.resetConnections(OracleTxlogEventReader.java:606) at com.linkedin.databus2.producers.db.OracleTxlogEventReader.readEventsFromAllSources(OracleTxlogEventReader.java:193) at com.linkedin.databus2.producers.db.OracleEventProducer.readEventsFromAllSources(OracleEventProducer.java:120) at com.linkedin.databus2.producers.AbstractEventProducer$EventProducerThread.run(AbstractEventProducer.java:273) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:375) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:678) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:238) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308) ... 11 more Caused by: java.net.UnknownHostException: devdb: Name or service not known at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:928) at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1323) at java.net.InetAddress.getAllByName0(InetAddress.java:1276) at java.net.InetAddress.getAllByName(InetAddress.java:1192) at java.net.InetAddress.getAllByName(InetAddress.java:1126) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:171) at oracle.net.nt.ConnOption.connect(ConnOption.java:123) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:353) ... 16 more 2018-04-05 05:47:53,439 +1111 [EventProducerThread_person] (ERROR) {OracleEventProducer_person} DatabusException occurred while reading events from person. This error may be due to a transient issue (database is down?):java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection com.linkedin.databus2.core.DatabusException: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at com.linkedin.databus2.producers.db.OracleTxlogEventReader.readEventsFromAllSources(OracleTxlogEventReader.java:418) at com.linkedin.databus2.producers.db.OracleEventProducer.readEventsFromAllSources(OracleEventProducer.java:120) at com.linkedin.databus2.producers.AbstractEventProducer$EventProducerThread.run(AbstractEventProducer.java:273) Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:536) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:157) at com.linkedin.databus2.producers.db.OracleTxlogEventReader.resetConnections(OracleTxlogEventReader.java:606) at com.linkedin.databus2.producers.db.OracleTxlogEventReader.readEventsFromAllSources(OracleTxlogEventReader.java:193) ... 2 more Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:375) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:678) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:238) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308) ... 11 more Caused by: java.net.UnknownHostException: devdb: Name or service not known at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:928) at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1323) at java.net.InetAddress.getAllByName0(InetAddress.java:1276) at java.net.InetAddress.getAllByName(InetAddress.java:1192) at java.net.InetAddress.getAllByName(InetAddress.java:1126) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:171) at oracle.net.nt.ConnOption.connect(ConnOption.java:123) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:353) ... 16 more 2018-04-05 05:47:53,439 +1111 [EventProducerThread_person] (INFO) {BackoffTimerStaticConfigBuilder} person.dbPuller.errorRetries: error sleep, ms: 2000 2018-04-05 05:47:55,441 +3113 [EventProducerThread_person] (ERROR) {DBHelper} Invoking a rollback after the connection is closed 2018-04-05 05:47:55,441 +3113 [EventProducerThread_person] (ERROR) {person} readEventsFromAllSources exception:IO Error: The Network Adapter could not establish the connection java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:536) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:157) at com.linkedin.databus2.producers.db.OracleTxlogEventReader.resetConnections(OracleTxlogEventReader.java:606) at com.linkedin.databus2.producers.db.OracleTxlogEventReader.readEventsFromAllSources(OracleTxlogEventReader.java:193) at com.linkedin.databus2.producers.db.OracleEventProducer.readEventsFromAllSources(OracleEventProducer.java:120) at com.linkedin.databus2.producers.AbstractEventProducer$EventProducerThread.run(AbstractEventProducer.java:273) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:375) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:678) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:238) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308) ... 11 more Caused by: java.net.UnknownHostException: devdb at java.net.InetAddress.getAllByName0(InetAddress.java:1280) at java.net.InetAddress.getAllByName(InetAddress.java:1192) at java.net.InetAddress.getAllByName(InetAddress.java:1126) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:171) at oracle.net.nt.ConnOption.connect(ConnOption.java:123) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:353) ... 16 more

rioleehit avatar Apr 05 '18 10:04 rioleehit