You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "fzhan (via GitHub)" <gi...@apache.org> on 2024/02/04 23:48:39 UTC

[I] Delayed page activities in SQL Lab [superset]

fzhan opened a new issue, #27009:
URL: https://github.com/apache/superset/issues/27009

   ### Bug description
   
   1. When running SQL, returnes "Database error Update failed"
   2. After a refresh, shows 'pending' 
   <img width="286" alt="image" src="https://github.com/apache/superset/assets/894804/9646d448-b719-4150-8e16-79ba4b2663a1">
   3. When close the tab, display "
   {
       "errors": [
           {
               "message": "Instance '<TabState at 0x7fd77ecd0e80>' has been deleted, or its row is otherwise not present.",
               "error_type": "GENERIC_BACKEND_ERROR",
               "level": "error",
               "extra": {
                   "issue_codes": [
                       {
                           "code": 1011,
                           "message": "Issue 1011 - Superset encountered an unexpected error."
                       }
                   ]
               }
           }
       ]
   }"
   ![image](https://github.com/apache/superset/assets/894804/d4972b64-1bb2-4862-bfbd-8c0bdd5449f3)
   5. checking the log, display:
   ``` superset.views.base:Instance '<TabState at 0x7fd77ecd0e80>' has been deleted, or its row is otherwise not present.
   Traceback (most recent call last):
     File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1823, in full_dispatch_request
       rv = self.dispatch_request()
     File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1799, in dispatch_request
       return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
     File "/usr/local/lib/python3.9/site-packages/flask_appbuilder/security/decorators.py", line 177, in wraps
       return f(self, *args, **kwargs)
     File "/app/superset/views/sql_lab/views.py", line 110, in post
       return json_success(json.dumps({"id": tab_state.id}))
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 481, in __get__
       return self.impl.get(state, dict_)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 941, in get
       value = self._fire_loader_callables(state, key, passive)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 972, in _fire_loader_callables
       return state._load_expired(state, passive)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/state.py", line 710, in _load_expired
       self.manager.expired_attribute_loader(self, toload, passive)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/loading.py", line 1465, in load_scalar_attributes
       raise orm_exc.ObjectDeletedError(state)
   sqlalchemy.orm.exc.ObjectDeletedError: Instance '<TabState at 0x7fd77ecd0e80>' has been deleted, or its row is otherwise not present.```
   
   ### How to reproduce the bug
   
   1. When running SQL, returnes "Database error Update failed"
   2. After a refresh, shows 'pending' 
   <img width="286" alt="image" src="https://github.com/apache/superset/assets/894804/9646d448-b719-4150-8e16-79ba4b2663a1">
   3. When close the tab, display "
   {
       "errors": [
           {
               "message": "Instance '<TabState at 0x7fd77ecd0e80>' has been deleted, or its row is otherwise not present.",
               "error_type": "GENERIC_BACKEND_ERROR",
               "level": "error",
               "extra": {
                   "issue_codes": [
                       {
                           "code": 1011,
                           "message": "Issue 1011 - Superset encountered an unexpected error."
                       }
                   ]
               }
           }
       ]
   }"
   ![image](https://github.com/apache/superset/assets/894804/d4972b64-1bb2-4862-bfbd-8c0bdd5449f3)
   5. checking the log, display:
   ``` superset.views.base:Instance '<TabState at 0x7fd77ecd0e80>' has been deleted, or its row is otherwise not present.
   Traceback (most recent call last):
     File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1823, in full_dispatch_request
       rv = self.dispatch_request()
     File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1799, in dispatch_request
       return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
     File "/usr/local/lib/python3.9/site-packages/flask_appbuilder/security/decorators.py", line 177, in wraps
       return f(self, *args, **kwargs)
     File "/app/superset/views/sql_lab/views.py", line 110, in post
       return json_success(json.dumps({"id": tab_state.id}))
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 481, in __get__
       return self.impl.get(state, dict_)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 941, in get
       value = self._fire_loader_callables(state, key, passive)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 972, in _fire_loader_callables
       return state._load_expired(state, passive)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/state.py", line 710, in _load_expired
       self.manager.expired_attribute_loader(self, toload, passive)
     File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/loading.py", line 1465, in load_scalar_attributes
       raise orm_exc.ObjectDeletedError(state)
   sqlalchemy.orm.exc.ObjectDeletedError: Instance '<TabState at 0x7fd77ecd0e80>' has been deleted, or its row is otherwise not present.```
   
   ### Screenshots/recordings
   
   _No response_
   
   ### Superset version
   
   master / latest-dev
   
   ### Python version
   
   3.9
   
   ### Node version
   
   16
   
   ### Browser
   
   Chrome
   
   ### Additional context
   
   _No response_
   
   ### Checklist
   
   - [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
   - [X] I have searched the GitHub issue tracker and didn't find a similar bug report.
   - [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.


-- 
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: notifications-unsubscribe@superset.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] Delayed page activities in SQL Lab [superset]

Posted by "fzhan (via GitHub)" <gi...@apache.org>.
fzhan closed issue #27009: Delayed page activities in SQL Lab
URL: https://github.com/apache/superset/issues/27009


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] Delayed page activities in SQL Lab [superset]

Posted by "fzhan (via GitHub)" <gi...@apache.org>.
fzhan commented on issue #27009:
URL: https://github.com/apache/superset/issues/27009#issuecomment-1947669622

   after switching to a stable postgresql, the problem was gone.


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org