[teiid-issues] [JBoss JIRA] (TEIID-5962) Teiid locks many threads when Salesforce is disconnected

[Renat Eskenin (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14150367#comment-14150367 ] 

Renat Eskenin commented on TEIID-5962:
--------------------------------------

We used properties
spring.teiid.data.salesforce.requestTimeout=120000
spring.teiid.data.salesforce.connectTimeout=120000

because 5000 is to less timeout.

But we still have same problem, when SF is disconnected Teiid do not cancel inbound requests and try to get SF connection. Tomcat thread poll  is fulled and service is down.

> Teiid locks many threads when Salesforce is disconnected
> --------------------------------------------------------
>
>                 Key: TEIID-5962
>                 URL: https://issues.redhat.com/browse/TEIID-5962
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>    Affects Versions: 12.3.1
>            Reporter: Renat Eskenin
>            Assignee: Steven Hawkins
>            Priority: Major
>         Attachments: Снимок экрана от 2020-05-31 11-09-10.png
>
>   Original Estimate: 1 hour
>          Time Spent: 45 minutes
>  Remaining Estimate: 15 minutes
>
> We had two incidents in our experimental service with teiid spring boot app. When Salesforce is down to 20min and service with teiid trying to call SQL from Salesforce we have many threads in tomcat server (in spring boot app). Then when 200 threads is activated service do not reply to requests because is "max threads" in tomcat of service.
> Why teiid do not send response as "Salesforce is down - error" or connection timeout?
> Micro schema:
> HTTP Requests to REST api -> Teiid spring boot app -> {broken 20min}Salesforce



--
This message was sent by Atlassian Jira
(v7.13.8#713008)