potiuk commented on issue #28603:
URL: https://github.com/apache/airflow/issues/28603#issuecomment-1366733676

    One of the reasons for paramico change was that pysftp did not allow for 
the kind of configuration that direct paramiko would. You should likely look at 
`keepalive_interval` and possibly other parameters there. 
   
   The problem that you might experience is because some networking equipment 
between you and the server could have been restarted (usual thing in the cloud) 
and if you do not enable keep-alives, you might as a client not even be aware 
that the other end has stopped responding.
   
   The nature of TCP connection is such that there is no "physical" connection 
set up - those are just networking packets sent over the network to certain 
ports. So if you have no "keepalive" enabled, the client might simply not 
realize the other end is disconnected because if the other end did not have 
time to signal that it has died or the CLOSE message might not have been 
delivered. 
   
   Only [TCP 
keepalives](https://tldp.org/HOWTO/TCP-Keepalive-HOWTO/overview.html) can give 
you the certainty  that you detect this situation. And they are disabled by 
default - you need to enable them - in case of SSHook (and SFTPHook derives 
from it in the new implementation) via the `keepalive_interval` 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to