SQLAlchemy - Results have expired, rerun the query if needed.

[dlinek]

Is the issue already present in https://github.com/cloudera/hue/issues or discussed in the forum https://discourse.gethue.com?

Describe the bug:
hue sqlalechmy interpreter to Oracle. When i run query i very often got Results have expired, rerun the query if needed.
This info is thrown immediately even if query history box show that query is still runing.

Steps to reproduce it?
HUE 4.10 run in docker without any loadbalancers, connection to oracle via sqlalchemy interpreter
[[[oracle]]]
options='{"url": "oracle://${USER}:${PASSWORD}@XXXXXXXXX:1521/?service_name=XXXX"}'

Hue version or source? (e.g. open source 4.5, CDH 5.16, CDP 1.0...). System info (e.g. OS, Browser...).
hue latest version 4.10 from github with installed oracle connector
pip install cx_Oracle

Sometimes i need to repeat query multiple times to get result.
What can I change to fix this issue?

[github-actions]

This issue is stale because it has been open 30 days with no activity and is not "roadmap" labeled or part of any milestone. Remove stale label or comment or this will be closed in 5 days.

[hackeryang]

I also met this error using mysql, and when i used the mysql JDBC configuration way, it worked and returned query results. It seems that the sqlalchemy way has some session or connection bugs.

You can also try the JDBC way(need to upload JDK and execute $HUE_HOME/build/env/bin/pip install py4j ahead): https://docs.gethue.com/administrator/configuration/connectors/#mysql