Result query set expired error occurs in Hue with k8s

[hoon-e]

Bug

I currently use hue application on kubernetes cluster. I connect to hive session using beeswax. beesawx attribute values are as follows.

[beeswax]
  hive_server_host=< hiveserver host >
  hive_server_port=10000
  hive_conf_dir=< hive conf directory >
  server_conn_timeout=12000
  download_row_limit=10000000
  download_cell_limit=10000000
  download_bytes_limit=350000000
  close_queries=true
  max_number_of_sessions=300

When i executed hive query, the following screen is repeated, and the result is that the query result is unsuccessful.

Picture

network status is like below. It seems to keep checking the status. I wonder if it has something to do with readinessProbe.

Have you ever experienced a similar situation? Thanks.

Hue Version

Opensource 4.9.0

[romainr]

Are you connections to HS2 sticky? Same for you users if using multiple Hue

https://docs.gethue.com/administrator/administration/reference/#impala-and-hive-ha

[hoon-e]

Yes. I use HS2 sticky. Is it a sticky session issue? I wonder if it's a load balancing problem, so even if I change to a single host, the same error occurs.

[hoon-e]

https://gethue.com/how-to-optimally-configure-your-analytic-database-for-high-availability-with-hue-and-other-sql-clients/

I've been testing separating property values for hue according to the documentation.

[hoon-e]

It works! As shown in the figure, I separated the haproxy port and configured it, and it worked properly.

One thing to note is that the following error occurred,

TSocket read 0 bytes (code THRIFTTRANSPORT): TTransportException('TSocket read 0 bytes',)

It was an error that occurred because the SSL setting was added to the server while setting the new port. If this error occurs, you may check the following.

1. Check if SSL settings are applied to the server.
2. Make sure SSL is turned off in hue hiveserver or Impala beeswax settings.
3. If set, check if the SSL key file is set properly.

I have all the SSL settings turned off in Hue I run.