Details
Highest Description
Issue Summary
Oracle provides a feature called Native Network Encryption: ORACLE-BASE - Native Network Encryption for Database Connections This feature was previously part of the Advanced Security Option license, and provides connection encryption without requiring client side configuration.
When this feature is enabled, it adds 350ms+ to the time required to establish a database connection. This alone will cause noteworthy performance degradation, but when combined with the default database connection pool manager in Confluence, c3p0, it can cause intermittent outages and extreme performance degradation.
Oracle have stated that this latency is working as intended: Slow Connection Using 12c Client When Network Encryption Is Enabled
Steps to Reproduce
- Install any version of Confluence
- Install Oracle DB 11g or later with Native Network Encryption enabled
- Introduce load to the system
- Monitor Confluence for delayed or timeout responses
Expected Results
Confluence should work as per normal.
Actual Results
There is a prolonged delay in establishing database connections that causes c3p0 to get stuck in a loop of attempting to obtain additional database connections. As obtaining these database connections is slow, this will take longer than normal.
Confluence will remain unresponsive until it reaches the c3p0 maximum pool size for the node.
This issue will not be visible in the logs by default, but the following KB provides additional details on how to diagnose this issue: Confluence Unresponsive Due to High Database Connection Latency
Workaround
A workaround is detailed on this KB: Confluence Unresponsive Due to High Database Connection Latency
However, it may be preferably to implement SSL to the database with proper certificate exchange, or disable Native Network Encryption entirely.
Attachments
Issue Links
- was cloned as
-
BAM-21042 Running Bamboo with Oracle Database Native Network Encryption Degrades Performance or Causes Outages
-
- Closed
-
- mentioned in
-
Page Loading...
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-