MariaDB upgrade to 2.7 fails - Multiple accounts exist for @user_name, @host_name

[andyp05]

Describe the issue you are experiencing

I searched and couldn't find a similar issue. MariaDB 2.6.1 is running fine. When I try to upgrade to 2.7.1 after a clean shutdown, I get the following error.

[09:57:43] INFO: Ensuring internal database upgrades are performed
ERROR 1644 (45000) at line 475: Multiple accounts exist for @user_name, @host_name that differ only in Host lettercase; remove all except one of them
FATAL ERROR: Upgrade failed
s6-rc: warning: unable to start service mariadb-post: command exited 1
/run/s6/basedir/scripts/rc.init: warning: s6-rc failed to properly bring all the services up! Check your logs (in /run/uncaught-logs/current if you have in-container logging) for more information.
/run/s6/basedir/scripts/rc.init: fatal: stopping the container.
s6-rc: info: service mariadb-core: stopping

Restored my 2.6.1 backup

I loaded phpMyAdmin and saw duplicated users. Deleted the duplicated row. No idea how that got there.

Before:

After:

After deleting the duplicate 'service' user, I restarted the addon. 2.6 reloads fine. I try another upgrade and get the same error.

Restored my 2.6.1 backup.

Back up and running with older version.

What type of installation are you running?

Home Assistant OS

Which operating system are you running on?

Home Assistant Operating System

Which add-on are you reporting an issue with?

MariaDB

What is the version of the add-on?

2.6.1

Steps to reproduce the issue

1. Try upgrade of mariadb from 2.6.1 to 2.7.1
2. Upgrade fails
3. Restore
4. Delete duplicate user.
5. Try upgrade again.
6. Upgrade fails
   ...

System Health information

System Information

version	core-2024.9.2
installation_type	Home Assistant OS
dev	false
hassio	true
docker	true
user	root
virtualenv	false
python_version	3.12.4
os_name	Linux
os_version	6.6.46-haos
arch	x86_64
timezone	America/New_York
config_dir	/config

Home Assistant Community Store

GitHub API	ok
GitHub Content	ok
GitHub Web	ok
HACS Data	ok
GitHub API Calls Remaining	5000
Installed Version	2.0.1
Stage	running
Available Repositories	1412
Downloaded Repositories	13

Home Assistant Cloud

logged_in	true
subscription_expiration	March 11, 2025 at 8:00 PM
relayer_connected	true
relayer_region	us-east-1
remote_enabled	true
remote_connected	true
alexa_enabled	false
google_enabled	false
remote_server	us-east-1-3.ui.nabu.casa
certificate_status	ready
instance_id	a639ef00f1bc4d478e3fd1fa6f6b202d
can_reach_cert_server	ok
can_reach_cloud_auth	ok
can_reach_cloud	ok

Home Assistant Supervisor

host_os	Home Assistant OS 13.1
update_channel	stable
supervisor_version	supervisor-2024.09.1
agent_version	1.6.0
docker_version	26.1.4
disk_total	457.7 GB
disk_used	24.9 GB
healthy	true
supported	true
host_connectivity	true
supervisor_connectivity	true
ntp_synchronized	true
virtualization
board	generic-x86-64
supervisor_api	ok
version_api	ok
installed_addons	Mosquitto broker (6.4.1), File editor (5.8.0), MariaDB (2.6.1), OneDrive Backup (2.3.1), phpMyAdmin (0.9.1), Z-Wave JS (0.7.2), Advanced SSH & Web Terminal (19.0.0), Samba share (12.3.2), Studio Code Server (5.15.0), Glances (0.21.1), Frigate (Full Access) (0.14.1)

keymaster

zwave_integration	zwave_js
network_status	on

Dashboards

dashboards	1
resources	9
views	11
mode	storage

Recorder

error	failed to load: unknown

Anything in the Supervisor logs that might be useful for us?

No response

Anything in the add-on logs that might be useful for us?

No response

Additional information

Core 2024.9.2
Supervisor 2024.09.1
Operating System 13.1
Frontend 20240909.1

Running on Intel NUC