KSQL Query editor does not return values

[rharikrishnan87]

The KSQL Query editor, does not return values when running a query, while the same query returns values in the CLI. We do not se any errors in KSQL or control center logs. When we looked at the browser network, we only see a ws request and we do not see the response coming.

Attached are screen shots for reference. The query that we ran was

select * from KSQL_PAGEVIEWS_TRANSFORMED_AVRO1 limit 2;

[big-andy-coates]

Hi @rharikrishnan87,

So the issue you are experiencing is that the CLI works but Control Center does not?

The CLI uses the rest endpoint, where as Control Center uses web sockets. This is likely to be at the root of the disparity you're seeing.

• Have you confirmed that the KSQL server details Control Center is using are correct, i.e. the 192.168.109.37 port 8088?
• Have you confirmed this IP and port are reachable from Control Center?
• Do any other KSQL commands work?
• Do you see anything on the other KSQL tables, e.g. streams, tables, etc?
• Do you see the query starting in the KSQL logs?

If this doesn't help resolve the issue it would be useful to know the versions of the components you are running, know more about your setup, (e.g. how things are deployed, etc), and get hold of application logs from KSQL and Control Center.

[rharikrishnan87]

Hi, My response in line

Have you confirmed that the KSQL server details Control Center is using are correct, i.e. the 192.168.109.37 port 8088? Hari: Yes the KSQL server details (IP and Port) are correct in the kafka properties Have you confirmed this IP and port are reachable from Control Center? Hari: Yes Do any other KSQL commands work? Hari: Commands like create stream or tables work, but any query which is expecting a stream output does not work Do you see anything on the other KSQL tables, e.g. streams, tables, etc? Hari: Yes we do, the issue is only to do with getting output on the query editor Do you see the query starting in the KSQL logs? Hari: The event of me reaching query editor is logged in KSQl logs as a POST call, but my query is not in the KSQL logs

[big-andy-coates]

Hi Hari,

Hari: The event of me reaching query editor is logged in KSQl logs as a POST call, but my query is not in the KSQL logs

Can you share the logs please?

Can you also provide information on the versions of components you are running and your deployment setup?

Thanks,

Andy

[big-andy-coates]

Closing due to inactivity.

[davidseth]

@rharikrishnan87 picking this back up, can you supply any logs?

Also, did you have both C3 and KSQL configured with HTTPS?