You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/09/04 08:39:22 UTC
[GitHub] [incubator-superset] nomulex opened a new issue #10792: Error on Delete. sqlalchemy.exc.ResourceClosedError: This transaction is closed
nomulex opened a new issue #10792:
URL: https://github.com/apache/incubator-superset/issues/10792
I used the official superset helm charts [here](https://github.com/apache/incubator-superset/tree/master/helm/superset) to install superset. But I get an error on save.
### Expected results
Superset to save results with no error.
### Actual results
`ERROR:flask_appbuilder.models.sqla.interface:Delete record error: This transaction is closed
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2597, in _flush
flush_context.execute()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
rec.execute(self)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 624, in execute
uow,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 326, in delete_obj
_organize_states_for_delete(base_mapper, states, uowtransaction)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 463, in _organize_states_for_delete
base_mapper, uowtransaction, states
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 1602, in _connections_for_states
connection = uowtransaction.transaction.connection(base_mapper)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 311, in connection
self._assert_active()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 304, in _assert_active
raise sa_exc.ResourceClosedError(closed_msg)
sqlalchemy.exc.ResourceClosedError: This transaction is closed
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/flask_appbuilder/models/sqla/interface.py", line 634, in delete
self.session.commit()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/scoping.py", line 162, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 1036, in commit
self.transaction.commit()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 503, in commit
self._prepare_impl()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 482, in _prepare_impl
self.session.flush()
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2496, in flush
self._flush(objects)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2637, in _flush
transaction.rollback(_capture_exception=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 81, in __exit__
compat.raise_(value, with_traceback=traceback)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 2637, in _flush
transaction.rollback(_capture_exception=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 519, in rollback
self._assert_active(prepared_ok=True, rollback_ok=True)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/session.py", line 304, in _assert_active
raise sa_exc.ResourceClosedError(closed_msg)
sqlalchemy.exc.ResourceClosedError: This transaction is closed
`
#### Screenshots
![image](https://user-images.githubusercontent.com/3070004/92218867-6c75e600-eea2-11ea-872c-242e70dd29c4.png)
### Environment
(please complete the following information):
- superset version: `superset version` Superset 0.999.0dev
- python version: `python --version` Python 3.6.9
- node.js version: `node -v` none in [this](https://hub.docker.com/r/preset/superset) container
- npm version: `npm -v` none in [this](https://hub.docker.com/r/preset/superset) container
### Checklist
Make sure these boxes are checked before submitting your issue - thank you!
- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
none.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] dpgaspar commented on issue #10792: Error on Delete. sqlalchemy.exc.ResourceClosedError: This transaction is closed
Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #10792:
URL: https://github.com/apache/incubator-superset/issues/10792#issuecomment-688884076
Could you please fill out a detailed description of the steps to reproduce this issue, also add a chunk of log prior to the error itself.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] stale[bot] commented on issue #10792: Error on Delete. sqlalchemy.exc.ResourceClosedError: This transaction is closed
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10792:
URL: https://github.com/apache/incubator-superset/issues/10792#issuecomment-734495355
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #10792: Error on Delete. sqlalchemy.exc.ResourceClosedError: This transaction is closed
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10792:
URL: https://github.com/apache/incubator-superset/issues/10792#issuecomment-687011313
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.76. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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.
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