Database error

[esambu]

How can correct the error below am experiencing while to trying to preview a table or make an sql query

Database error
Instance <Query at 0x21a5cdd15e0> is not bound to a Session; attribute refresh operation cannot proceed (Background on this error at: http://sqlalche.me/e/13/bhk3)

[esambu]

Am using windows with superset version 1.0.1 with the above error

[esambu]

I just got the solution for my error on Error running SQL Lab
#12824

[pratik-sankey]

hey @esambu , I am facing same error. can you share me solution you got?

[esambu]

The problem seems to be caused by SIGALRM. Here is a workaround which has worked for me. In Lib\site-packages\superset\utils\core.py replace: def __enter__(self): try: signal.signal(signal.SIGALRM, self.handle_timeout) signal.alarm(self.seconds) except ValueError as e: logger.warning("timeout can't be used in the current context") logger.exception(e) def __exit__(self, type, value, traceback): try: signal.alarm(0) except ValueError as e: logger.warning("timeout can't be used in the current context") logger.exception(e) with def __enter__(self): try: #signal.signal(signal.SIGALRM, self.handle_timeout) #signal.alarm(self.seconds) pass except ValueError as e: logger.warning("timeout can't be used in the current context") logger.exception(e) def __exit__(self, type, value, traceback): try: #signal.alarm(0) pass except ValueError as e: logger.warning("timeout can't be used in the current context") logger.exception(e)

…

On Tue, Mar 9, 2021 at 10:49 AM pratik-sankey ***@***.***> wrote: hey @esambu <https://github.com/esambu> , I am facing same error. can you share me solution you got? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#13169 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ASDZKVT4WV2MFHU74ZEIQG3TCXHIJANCNFSM4XX7TMJQ> .