[jira] [Created] (RANGER-4190) Apache Ranger does not recover from a recoverable SQL exception

["Ramachandran (Jira)" <ji...@apache.org>]

Ramachandran created RANGER-4190:
------------------------------------

             Summary: Apache Ranger does not recover from a recoverable SQL exception
                 Key: RANGER-4190
                 URL: https://issues.apache.org/jira/browse/RANGER-4190
             Project: Ranger
          Issue Type: Improvement
          Components: Ranger
            Reporter: Ramachandran
            Assignee: Ramachandran
             Fix For: 3.0.0


It seems the Ranger instance is not able to connect Oracle ATP. This issue could be the loss of network connectivity to the load balancer which will connect to oracle ATP.
java.sql.SQLRecoverableException: I/O Exception: Connection reset

Internal Exception: java.sql.SQLRecoverableException: No more data to read from socket
Error Code: 17410
As we discussed with Abhi, this issue could happen due to the loss of connectivity to the oracle ATP network load balancer.
ADB network properties - [https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-prepare-jdbc-thin.html#GUID-0A619DFE-5F5F-4302-BF43-B08AEDA05A6C] [https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/load-balancing-of-connections-to-oracle-rac-databases.html#GUID-06B4373D-1217-44E4-BD86-DE353DA657F6]
 part of the Ranger start we need to add the below JVM parameters to disable the network cache by lowering its TTL to 0;-Djava.security.egd=file:///dev/urandom -Dnetworkaddress.cache.ttl=0 -Dnetworkaddress.cache.negative.ttl=0

 

By default, the [OpenJDK 8 InetAddress|http://hg.openjdk.java.net/jdk8/jdk8/jdk/file/687fd7c7986d/src/share/classes/java/net/InetAddress.java#l189] will cache failed DNS queries, referred to as "negative caching", for 10 seconds. It's recommended to disable both the positive and negative cache by setting them to 0 seconds, and rely on the DNS caching implemented inside OCI's DNS systems. 
{panel}
{panel}
|{{{}java.security.Security.setProperty({}}}{{{}"networkaddress.cache.ttl"{}}}{{{}, {}}}{{{}0{}}}{{{});{}}}
{{{}java.security.Security.setProperty({}}}{{{}"networkaddress.cache.negative.ttl"{}}}{{{}, {}}}{{{}0{}}}{{{});{}}}
{{// (Optional) Force Java to use a specific DNS provider}}
{{// By default it will use whatever lookup is defined in the system => files,nis,dns}}
{{// as in /etc/nsswitch.conf on linux}}
{{{}System.setProperty({}}}{{{}"sun.net.spi.nameservice.provider.1"{}}}{{{}, {}}}{{{}"dns,sun"{}}}{{{});{}}}|

Or as an argument when invoking Java:
{panel}
{panel}
|{{{}java -Dnetworkaddress.cache.ttl={}}}{{{}0{}}} {{{}-Dnetworkaddress.cache.negative.ttl={}}}{{{}0{}}} {{app.jar}}|

 

 

 

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)