weizhouapache commented on issue #6821:
URL: https://github.com/apache/cloudstack/issues/6821#issuecomment-1280387953

   > > > > 299
   > > > 
   > > > 
   > > > @zap51 in this case, you should not execute the queries I mentioned in 
previous comment.
   > > > you can try to restore the project and account to normal state.
   > > > update projects set removed=NULL where id=299; update account set 
removed=NULL where id=1265;
   > > 
   > > 
   > > Thanks @weizhouapache, I tried the set of queries. Now I see I'm able to 
get into the details of the domain, however not visible on the WebUI though. 
I'm trying to clean up the entire domain and releasing all resources under it, 
but no success. I also see that the account has `cleanup_needed=1`
   > > ```
   > > select * from account where id=1265;
   > > 
+------+-----------------------------------+--------------------------------------+------+---------+-----------+---------+---------------------+---------------------+----------------+----------------+-----------------+---------+
   > > | id   | account_name                      | uuid                        
         | type | role_id | domain_id | state   | created             | removed 
            | cleanup_needed | network_domain | default_zone_id | default |
   > > 
+------+-----------------------------------+--------------------------------------+------+---------+-----------+---------+---------------------+---------------------+----------------+----------------+-----------------+---------+
   > > | 1265 | PrjAcct-xxxxxx-xxxxxx-6536279-962 | 
f64a31eb-10db-40a7-a276-6f4e730c2859 |    5 |    NULL |       962 | enabled | 
2022-09-16 08:38:03 | NULL                |              1 | NULL           |   
         NULL |       0 |
   > > 
+------+-----------------------------------+--------------------------------------+------+---------+-----------+---------+---------------------+---------------------+----------------+----------------+-----------------+---------+
   > > ```
   > > 
   > > 
   > >     
   > >       
   > >     
   > > 
   > >       
   > >     
   > > 
   > >     
   > >   
   > > Please suggest to remove all the resources under this domain and 
hopefully the account.
   > > Thanks
   > 
   > @weizhouapache Please suggest a method to clean up the resources under 
this account. Thank you!
   
   @zap51 
   I do not the exact state of your project, network, etc.
   do you need the project ? if not, just update the `removed` field in the 
table above, cloudstack will try to clean the project in backend.
   
   update account set removed=now() where id=1265;
   
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to