Problems with Oracle long-lived connection in Kubernetes cluster

9/18/2019

I am trying to deploy a Go application inside the Kubernetes cluster. My application uses the goracle.v2 library to connect to the Oracle database.

The problem only happens when my application is running inside the Kubernetes cluster. I have a process that executes a stored procedure and returns a cursor, and it often takes more than 10 minutes to execute.

When this happens the active session that was there in the database ends and the pod that was running with the application is stopped and nothing else happens. And this scenario only happens when it runs inside the cluster. If I run the app locally it doesn't happen even if the process takes more than 10 minutes.

Anyone have any idea what might be happening?

-- Rafael B. S. Santos
go
goracle
kubernetes

0 Answers