Camunda application throwing SSL connection error while connecting to Camunda DB(mssqlserver)

XMLWordPrintable

    • Type: Bug Report
    • Resolution: Won't Fix
    • Priority: L3 - Default
    • None
    • Affects Version/s: None
    • Component/s: network
    • None

      Environment (Required on creation): Our Camunda application runs on Kubernetes Cluster with version 1.21.9 (azure cloud), the node size is Standard_D3_V2, Operating System:Linux , Node image:AKSUbuntu-1804containerd-2022.02.07,OS disk size:128 GB 

      Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket): The application is running on a single node , with two pods of which one is camunda and the other Istio side car, the application uses mssqlserver deployed on Azure cloud, the application seems to be running fine and will suddenly start throwing the below error and the readiness probe will keep getting 500 error and the application URL would result in site not available error. We have verified the DB and it seem to be running fine.

      "The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption"

      logs:

      Caused by: org.apache.ibatis.exceptions.PersistenceException:

          1. Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing".
          2. The error may exist in org/camunda/bpm/engine/impl/mapping/entity/ExternalTask.xml
          3. The error may involve org.camunda.bpm.engine.impl.persistence.entity.ExternalTaskEntity.selectExternalTasksForTopics
          4. The error occurred while executing a query
          5. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing".
            at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
            at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.lambda$executeSelectList$1(DbSqlSession.java:111)
            at org.camunda.bpm.engine.impl.util.ExceptionUtil.doWithExceptionWrapper(ExceptionUtil.java:254)
            ... 67 more
            Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing".
            at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3206)

            Steps to reproduce (Required on creation): Currently we are not Sure on how to recreate the issue

            Observed Behavior (Required on creation): Once the error is observed the Camunda cockpit would become unavailable

            Expected behavior (Required on creation): Error shouldnt occur as DB is up and running

            Root Cause (Required on prioritization):

            Solution Ideas (Optional):

            Hints (optional):

        This is the controller panel for Smart Panels app

          1. image002.png
            3 kB
            Saketh Damera
          2. image003.png
            3 kB
            Saketh Damera
          3. localhost_log.JPG
            393 kB
            Saketh Damera

              Assignee:
              Garima Yadav
              Reporter:
              Saketh Damera
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: