Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup

Solved Go to solution

The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup

Contributor

Hello,

I am working with 3 nodes CFM cluster. the version of CFM is 1.0.1.  

The below pic shows the steps:

19287C52-AE55-4721-9D0E-065AB0507D32.png

 

the below pic is config of ExecuteSQL:

2F4156E7-12D2-493f-ACCF-BD9E77CAD8A3.png

the below pic is lookup service:

3BC89273-4395-4ab2-BC95-9B728D1C9FF2.png

the below is the config of dbcpconnetionpool:

B403344A-EBD0-47f7-82DB-21FD58BEF033.png15FA3BAE-53D4-48e5-AA34-C5435A88D4B5.png

The behavior is the ExcuteSQL processor will execute very slowly seem hanged.  but sometime execute very fast. I believe that is database issue. So my questions is:

1. what is the impact? is dbcp connections pool issue of config? or is the dbcp connections pool lookup wrong behavior?  

2. I'm afraid the impact of this will be magnified. when increased database connection pool to 500+.

Could help me to answer my questions?

Thanks

Paul

1 ACCEPTED SOLUTION

Accepted Solutions

Re: The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup

Contributor

Oh, it is network connection issue. it gone away when i add oracle.jdbc.ReadTimeout=120000 and oracle.net.CONNECT_TIMEOUT=10000 to config of DBCPConnectionPool.

 

2 REPLIES 2
Highlighted

Re: The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup

Contributor

I'm sorry. Correct the above description.

The behavior is the ExcuteSQL processor will execute very slowly seem hanged. but sometime execute very fast. I believe that is not database issue.

So my questions is:

1. what is the impact? is dbcp connections pool issue of config? or is the dbcp connections pool lookup wrong behavior?

2. I'm afraid the impact of this will be magnified when we face to increased database connection pool config to 500+. Is that the right thing to worry about?

Could help me to answer my questions?

Thanks Paul

Re: The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup

Contributor

Oh, it is network connection issue. it gone away when i add oracle.jdbc.ReadTimeout=120000 and oracle.net.CONNECT_TIMEOUT=10000 to config of DBCPConnectionPool.

 

Don't have an account?
Coming from Hortonworks? Activate your account here