[jira] [Created] (FLINK-36781) Flink SQL REPL Remote Gateway lag

["k walton (Jira)" <ji...@apache.org>]

k walton created FLINK-36781:
--------------------------------

             Summary: Flink SQL REPL Remote Gateway lag
                 Key: FLINK-36781
                 URL: https://issues.apache.org/jira/browse/FLINK-36781
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Client, Table SQL / Gateway
    Affects Versions: 1.20.0
         Environment: This was noticed when spawning a gateway on a remote kubernetes cluster and connecting through a port forward, which exacerbated the lag. But I've captured screenshots of the network requests on each key press on wireshark locally, which I've attached a recording of for clarity.

 

You can reproduce this by doing the following:
 # Have docker installed
 # in one terminal run a host gateway
{code:java}
docker run -p 8083:8083 --rm -it --entrypoint /bin/bash flink:1.20 -c "/opt/flink/bin/start-cluster.sh && /opt/flink/bin/sql-gateway.sh start-foreground -D sql-gateway.endpoint.rest.port=8083 -D sql-gateway.endpoint.rest.address=localhost" {code}

 # in a second terminal run a sql client connected to it, on my machine the command is
{code:java}
/opt/homebrew/opt/apache-flink/libexec/bin/sql-client.sh gateway -e localhost:8083 {code}

 # Observe network requests on every key press
            Reporter: k walton
         Attachments: flink-sql-gateway-lag.mov

When connecting to a remote gateway with the Flink SQL REPL we have noticed that a network request is made for every key press. This makes the REPL terminal unusably lagging when typing text into it.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)