linkedin / linkedin/databus

EventProducerThread_person

Open
#114 0 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.