[Bug]: Error: Group is not renamed or deleted correctly on the Database

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• Nextcloud Server is running on 64bit capable CPU, PHP and OS.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

Nextcloud shows us an error saying that the user group already exists when it no longer exists.

Steps to reproduce

1. Create a group with a name X
2. Rename this group with a name Y
3. Recreate the X group

OR

1. Create a group with a name X
2. Delete the group
3. Recreate the X group

Expected behavior

That it validates the creation of the group.

Installation method

Community Docker image

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.1

Web server

Apache (supported)

Database engine version

MySQL

Is this bug present after an update or on a fresh install?

Fresh Nextcloud Server install

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

No response

List of activated Apps

Included App

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

Start by reproducing the group lifecycle on the reported MySQL and PHP setup: create X, rename or delete it, then try to recreate X. Trace the database-backed group creation, rename, and deletion handling. Done means recreating X succeeds without an erroneous “group already exists” error.