[GitHub] [superset] radhakvnr opened a new issue #19058: Deleting a database connection is not deleting the entries from ab_view_menu and ab_permission_view metadata tables

[GitBox <gi...@apache.org>]

radhakvnr opened a new issue #19058:
URL: https://github.com/apache/superset/issues/19058


   Deleting a database connection is not deleting the entries from ab_view_menu and ab_permission_view_menu. which results many unnecessary rows present in the above mentioned tables in metadata.
   
   #### How to reproduce the bug
   
   1. Go to Database section
   2. Click on add database
   3. Create a new database connection and save
   4. Delete the Database connection
   5. go to the Metadata and query the ab_view_menu and ab_view_menu and ab_permission_view you can still see the entries of the deleted database.
   
   ### Expected results
   Deleting a Database connection should delete the corresponding entries from the respective tables.
   
   what you expected to happen.
   
   ### Actual results
   
   Deleting a database connection is not deleting the entries from ab_view_menu and ab_permission_view metadata tables
   
   #### Screenshots
   
   If applicable, add screenshots to help explain your problem.
   
   
   ### Environment
   
   (please complete the following information):
   
   - browser type and version:
   - 1.3.2
   - python version: 3.7.9
   - node.js version: `node -v`
   - any feature flags active:
   
   ### Checklist
   
   Make sure to follow these steps 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
   
   Add any other context about the problem here.
   


-- 
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

[GitHub] [superset] cccs-rc commented on issue #19058: Deleting a database connection is not deleting the entries from ab_view_menu and ab_permission_view metadata tables

[GitBox <gi...@apache.org>]

cccs-rc commented on issue #19058:
URL: https://github.com/apache/superset/issues/19058#issuecomment-1069457341


   Hi, @zhaoyongjie . I stumbled across this issue while I was in the process of manually cleaning up these tables for this exact reason! We've renamed our DB connections several times and the permissions have never been cleaned up, which means they continue to appear as options in the "Edit Role" view. It's a minor annoyance for admins. 
   
   Running ```superset init``` doesn't clean anything up for us (on 1.4.). 


-- 
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

[GitHub] [superset] zhaoyongjie commented on issue #19058: Deleting a database connection is not deleting the entries from ab_view_menu and ab_permission_view metadata tables

[GitBox <gi...@apache.org>]

zhaoyongjie commented on issue #19058:
URL: https://github.com/apache/superset/issues/19058#issuecomment-1062597501


   Hi, @radhakvnr. Do you try to run `superset init`? I remember there are some cleanup steps in this command.


-- 
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