Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

The ExecuteSql processor run to hang sometime when use dbcpconnectionpoollookup

avatar
Expert 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

avatar
Expert 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.

 

View solution in original post

2 REPLIES 2

avatar
Expert 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

avatar
Expert 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.