Tonitzpp commented on PR #13456:
URL: https://github.com/apache/cloudstack/pull/13456#issuecomment-4892556584
@weizhouapache I tested it again, with and without the changes, to see if
was still possible to reproduce the issue #12601. I was able to reproduce it
without, but not with my changes.
Here are the steps I executed:
1. Created a User account:
<img width="1076" height="1600" alt="image"
src="https://github.com/user-attachments/assets/bf04f580-bcd6-467d-94a4-701e78699a02";
/>
2. Created a project:
<img width="1267" height="704" alt="image"
src="https://github.com/user-attachments/assets/a4d00c27-4b92-46b0-a176-efa03987cbfb";
/>
3. Added the User in the project as a user with the role type as admin:
<img width="1091" height="1387" alt="image"
src="https://github.com/user-attachments/assets/55a7ca23-93fe-4184-9e2a-f4f18979fbe3";
/>
4. Then, I deleted the project with clean up:
<img width="1305" height="781" alt="image"
src="https://github.com/user-attachments/assets/9554424c-76d9-4196-be4e-66c6d46fcaa6";
/>
Before the changes, I tried to delete the account and the error showed up:
<img width="3289" height="615" alt="image"
src="https://github.com/user-attachments/assets/e4047924-7d10-4a25-a3e1-8eeef4699783";
/>
I checked the database too:
```sql
MariaDB [cloud]> select * from project_account;
+----+------------+---------+--------------+------------+--------------------+-----------------+---------------------+
| id | account_id | user_id | account_role | project_id | project_account_id
| project_role_id | created |
+----+------------+---------+--------------+------------+--------------------+-----------------+---------------------+
| 2 | 4 | 4 | Admin | 1 | 5
| NULL | 2026-04-23 12:22:59 |
+----+------------+---------+--------------+------------+--------------------+-----------------+---------------------+
1 row in set (0.000 sec)
```
After the changes, I deleted the account successfully:
<img width="3300" height="402" alt="image"
src="https://github.com/user-attachments/assets/7819514c-22e9-43b5-9efb-f782c534fd14";
/>
And checked the database that it was clean:
```sql
MariaDB [cloud]> select * from project_account;
Empty set (0.000 sec)
```
Did you perform any different steps?
---
@DaanHoogland And in regards to the normalization, it will need to be
included in the 4.22.1 -> 4.23.0 and 4.22.1 -> 4.22.2 scripts.
--
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]
