Music Assistant Error - sqlite3.OperationalError: duplicate column name: external_ids

[marc4s]

Hi,

between 0.77b and 0.78b something got corrupted (without config changes from my side).
The Music in the database is still shown. but not available(source is plex which is still fine and available).
But the config page of MA seems to be affecated by the error and I cannot see my sources and the buttons for adding or changing them are gone)
this is still the case with 0.79b

2023-12-30 07:41:06.876 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 106, in setup await self._setup_database() File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 665, 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

[OzGav]

Please look at the closed issues this has, unfortunately, been reported many times

[marc4s]

if I follow the link to the issue tracker there are 0 open and 0 closed issues

https://github.com/music-assistant/hass-music-assistant/issues/issues

[marc4s]

the hint from here https://github.com/orgs/music-assistant/discussions/1680
restoring 0.75b and then upgrade to 0.79b is not working. same issue as before (while 0.75b was running well)

2023-12-30 08:08:57.456 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 106, in setup await self._setup_database() File "/usr/local/lib/python3.11/site-packages/music_assistant/server/controllers/music.py", line 665, 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

[marc4s]

Ok, I did the rollback twice with the STOP between the upgrade. now the db update went fine.