harsh9898 opened a new issue, #20467: URL: https://github.com/apache/superset/issues/20467
Hello, When I am running normal select and where clauses in sql editor it's giving the desired results but when I am trying to run the join query it's giving me the following error: ``` Database error Instance <Query at 0x7f5578e4ab80> is not bound to a Session; attribute refresh operation cannot proceed (Background on this error at: http://sqlalche.me/e/13/bhk3) ``` My superset version: 1.0.0 SQLAlchemy version: 1.3.24 I tried the following solution as I found from the other issues on github: Changed the follwoing code in /superset/utils.core.py: **Commented out the following code:** ``` #def __enter__(self) -> None: #try: # if threading.current_thread() == threading.main_thread(): # #signal.signal(signal.SIGALRM, self.handle_timeout) #signal.alarm(self.seconds) # print(0) #except ValueError as ex: # logger.warning("timeout can't be used in the current context") # logger.exception(ex) #def __exit__( # pylint: disable=redefined-outer-name,redefined-builtin #self, type: Any, value: Any, traceback: TracebackType ) -> None: #try: #signal.alarm(0) # print(0) #except ValueError as ex: # logger.warning("timeout can't be used in the current context") #logger.exception(ex) ``` Added the following lines instead of above and ran it again: ``` def __enter__(self): try: #signal.signal(signal.SIGALRM, self.handle_timeout) #signal.alarm(self.seconds) pass except ValueError as ex: logger.warning("timeout can't be used in the current context") logger.exception(ex) def __exit__(self, type, value, traceback): try: #signal.alarm(0) pass except ValueError as ex: logger.warning("timeout can't be used in the current context") logger.exception(ex)_ ``` After doing the above step, it's still giving the same error. If anyone knows then Please help me regarding this as it's very important for me. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
