EventProducerThread_person
- Dominant language
- Java
- Stars
- 3.7k
- Forks
- 736
- PR merge metrics
- No merged PRs in 30d
Description
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
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with OracleTxlogEventReader.resetConnections and readEventsFromAllSources, the entry points named in the stack trace. Check how the EventProducerThread_person database connection is configured and whether the host name devdb resolves. Done means reproducing the failure and identifying whether the cause is environment configuration or repository error handling.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- backend, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 15/100