New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
cannot delete user "Associated data exists, please delete them first" #13345
Comments
Any update? |
no updates from my end |
Thanks for the quick reply @maddyobrienjones I encountered the same error a couple of days ago. I don't know what I will do because I can't remove the user although all charts and dashboards created by that user have been deleted. By the way, the reason that I want for the user removal is the following situation. I don't know again what I will do and I wanted to delete&add the user again. It will be greatly appreciated if anyone knows a solution to this strange situation. Note: There are many dashboards, and not even one of them appeared in the 'ADD TO DASHBOARD' part. |
My second problem is solved by @nytai He told me that any user who wants to add a chart to any dashboard may have to add himself/herself as an owner of the dashboard. The other error 'Associated data exists, please delete them first' is still ongoing. |
Any update here? |
no updates from me. this is low priority in my backlog of tasks. |
I think there's also a logs table. Tbh deleting a user if quite difficult since cascade hasn't been set on a lot of the foreign key relationships, so you’ll have to find them and delete the records manually. If possible, just mark the user as inactive and change all the fields that might cause issues with unique constraints if the same user is trying to sign up again |
Also this stackoverflow post mentions a query you can run to find all the foreign key constraints on |
I tried to delete a user I just made, and it doesn't work giving this error. How does a new user own anything, and how can I find and delete it? |
Same problem here. Really need something to be able to delete a user |
@nytai , it's great! it works for me. When i tried to delete a user, it took a long time and timed out(log info, [CRITICAL] WORKER TIMEOUT (pid:5783)). So i deleted the records of the logs table, and the user can be deleted normally. |
I'm getting
|
Has anything been done for this for 2.0.0? |
Hey guys, The version 2.0.0 has the same problem It was necessary to remove the user data in this case from two tables:
|
puting this here for future use:
|
This script has worked for me without problems and I continue to use it. The reason for the select is that I use this with a != on the surname.
|
Still having this issue. The user im trying to delete has never created a chart or dashboard |
If you're using the latest version it may be possible that there are new tables. Run the above script and check what the error message is for the last line. Modify the script accordingly and post it here. |
just want to save time for who don't know how to do as C-monC did above, After that, just go to sqllab, find the user_id you want to delete, run 'delete from ab_user where id = ...' , it will show you which table have data associated with this user_id. Then run delete all rows having that user_id of all related tables and run 'delete from ab_user where id = ...' again, you can now remove that user. |
I ran into the same problem. I can't delete any user even though the use was recently created and doesn't own any chart, board or dataset. How could it be that the user deletion doesn't cascade through every data like e.g. logs? Appreciate some solutions (two years after initial report) for how to solve this bug. |
Airflow v2.6.0 Just had the same problem - following worked for me -
Not a fan of force deleting but this is a fundamental bug that needs fixing. A basic feature to allow updating of a user password should be implemented as this was the only reason I needed to delete a user. |
Same bug for me on 3.1.0. I have no access to the SuperSet database so I will set the user as inactive. But it should really be fixed. |
This is driving me nuts as well. I do not feel comfortable doing deletes outside of the ORM, as it might wreck stuff and make upgrades fail |
When trying to delete a user, the error message "Associated data exists, please delete them first" appears. All charts and dashboards created by that account have been deleted. I have also set the user as inactive and deleted its role setting. I am able to edit the user but not delete it.
I found the following similar issue which was marked as stale with no response: #8752
Expected results
Successful deletion of a user
Actual results
"Associated data exists, please delete them first" error message
Logs when navigating to user list and trying to delete user (domain has been replaced with deploymentlink.com):
10.4.15.23 - - [25/Feb/2021:19:48:28 +0000] "GET /users/list/ HTTP/1.1" 200 26741 "deploymentlink.com/superset/welcome" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"
10.4.15.23 - - [25/Feb/2021:19:48:34 +0000] "POST /users/delete/3 HTTP/1.1" 302 299 "deploymentlink.com/users/list" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"
10.4.15.23 - - [25/Feb/2021:19:48:34 +0000] "GET /users/list/ HTTP/1.1" 200 26786 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"
Screenshots
How to reproduce the bug
Environment
(please complete the following information):
superset version
: Superset 0.999.0devpython --version
: 3.7.9node -v
: couldn't findChecklist
Make sure to follow these steps before submitting your issue - thank you!
Additional context
none
The text was updated successfully, but these errors were encountered: