<p>TL;DR: How can we configure istio sidecar injection/istio-proxy/envoy-proxy/istio egressgateway to allow long living (&gt;3 hours), possibly idle, TCP connections?</p>
<p>Some details:</p>
<p>We're trying to perform a database migration to PostgreSQL which is being triggered by one application which has Spring Boot + Flyway configured, this migration is expected to last ~3 hours.</p>
<p>Our application is deployed inside our kubernetes cluster, which has configured istio sidecar injection. After exactly one hour of running the migration, the connection is always getting closed.</p>
<p>We're sure it's istio-proxy closing the connection as we attempted the migration from a pod without istio sidecar injection and it was running for longer than one hour, however this is not an option going forward as this may imply some downtime in production which we can't consider.</p>
<p>We suspect this should be configurable in istio proxy setting the parameter idle_timeout - which was implemented <a href="https://github.com/istio/istio/pull/13515" rel="noreferrer">here</a>. However this isn't working, or we are not configuring it properly, we're trying to configure this during istio installation by adding <code>--set gateways.istio-ingressgateway.env.ISTIO_META_IDLE_TIMEOUT=5s</code> to our helm template.</p>

<p>If you use istio version higher than 1.7 you might try use <a href="https://istio.io/latest/docs/reference/config/networking/envoy-filter/" rel="noreferrer">envoy filter</a> to make it work. There is answer and example on <a href="https://github.com/istio/istio/issues/24387#issuecomment-713600319" rel="noreferrer">github</a> provided by @ryant1986.</p>
<blockquote>
<p>We ran into the same problem on 1.7, but we noticed that the ISTIO_META_IDLE_TIMEOUT setting was only getting picked up on the OUTBOUND side of things, not the INBOUND. By adding an additional filter that applied to the INBOUND side of the request, we were able to successfully increase the timeout (we used 24 hours)</p>
</blockquote>
<pre><code>apiVersion: networking.istio.io/v1alpha3
kind: EnvoyFilter
metadata:
  name: listener-timeout-tcp
  namespace: istio-system
spec:
  configPatches:
  - applyTo: NETWORK_FILTER
    match:
      context: SIDECAR_INBOUND
      listener:
        filterChain:
          filter:
            name: envoy.filters.network.tcp_proxy
    patch:
      operation: MERGE
      value:
        name: envoy.filters.network.tcp_proxy
        typed_config:
          '@type': type.googleapis.com/envoy.config.filter.network.tcp_proxy.v2.TcpProxy
          idle_timeout: 24h
</code></pre>
<blockquote>
<p>We also created a similar filter to apply to the passthrough cluster (so that timeouts still apply to external traffic that we don't have service entries for), since the config wasn't being picked up there either.</p>
</blockquote>
