hass-music-assistant: Server update: duplicate column name: external_ids

What version of Music Assistant has the issue?

2023.12.0

The problem

Just updated to the latest version of the server and while starting it, the database migration kicks in but fails with an error duplicate column name: external_ids, details see below.

How to reproduce

Updated from beta 75 to beta 77

Relevant log output

2023-12-07 07:28:24.635 INFO (MainThread) [music_assistant] Starting Music Assistant Server (6f94f41b08ff4f88ab8bf72e2b8b088f) version 2.0.0b77 - uvloop: False 2023-12-07 07:28:24.673 INFO (MainThread) [music_assistant.webserver] Starting server on 0.0.0.0:8095 - base url: http://192.168.3.74:8095 2023-12-07 07:28:24.685 INFO (MainThread) [music_assistant.music] Performing database migration from 25 to 27 2023-12-07 07:28:24.685 WARNING (MainThread) [music_assistant.music] DATABASE MIGRATION IN PROGRESS - THIS CAN TAKE A WHILE 2023-12-07 07:28:24.686 ERROR (MainThread) [asyncio] Task exception was never retrieved future: <Task finished name=‘Task-1’ coro=<run.<locals>.new_coro() done, defined at /usr/local/lib/python3.11/site-packages/aiorun.py:209> exception=OperationalError(‘duplicate column name: external_ids’)> Traceback (most recent call last): File “/usr/local/lib/python3.11/site-packages/aiorun.py”, line 219, in new_coro await coro File “/usr/local/lib/python3.11/site-packages/music_assistant/main.py”, line 174, in start_mass await mass.start() File “/usr/local/lib/python3.11/site-packages/music_assistant/server/server.py”, line 139, in start await self.music.setup(await self.config.get_core_config(“music”)) File “/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py”, line 107, in setup await self._setup_database() File “/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py”, line 666, in _setup_database await self.database.execute( File “/usr/local/lib/python3.11/site-packages/music_assistant/server/helpers/database.py”, line 151, in execute return await self._db.execute(query, values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File “/usr/local/lib/python3.11/site-packages/aiosqlite/core.py”, line 190, in execute cursor = await self._execute(self._conn.execute, sql, parameters) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File “/usr/local/lib/python3.11/site-packages/aiosqlite/core.py”, line 133, in _execute return await future ^^^^^^^^^^^^ File “/usr/local/lib/python3.11/site-packages/aiosqlite/core.py”, line 106, in run result = function() ^^^^^^^^^^ sqlite3.OperationalError: duplicate column name: external_ids

Additional information

No response

What version of Home Assistant Core are your running

2023.12.0

What type of installation are you running?

Home Assistant Container

On what type of hardware are you running?

Linux