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."
}
]
}
}
]
}"

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."
}
]
}
}
]
}"

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