Resolves #7743 /claim #7743
The nginx stream proxy for publicly exposed databases defaults to a 10-minute timeout (nginx default proxy_timeout), causing long-running database operations (e.g. large SELECT * queries) to be disconnected prematurely.
public_port_proxy_timeout column (integer, default 0) to all 9 database tablespublic_port_proxy_timeout from the database modelproxy_timeout and proxy_connect_timeout into the nginx stream configproxyTimeout property with validation| Value | Behavior |
|---|---|
| 0 (default) | No timeout - connections stay open indefinitely |
| > 0 | Timeout in seconds between successive read/write operations |
Default of 0 solves the original issue: long-running queries (30min+) will no longer be disconnected.
nexicturbo
@nexicturbo
Zach Latta
@zachlatta