IndexError('No item with that key')

[gadgetbazza]

Recently MASS has stopped functioning properly for me, unfortunately I do not know when this started as I haven't been using it for a few weeks.

I updated to the latest version of the server app by pulling the latest docker image, but still the same behaviour.

The log from the container is noted below:

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=IndexError('No item with that key')>
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 674, in _setup_database
    if mbid := item["mbid"]:
               ~~~~^^^^^^^^
IndexError: No item with that key
2023-12-08 14:04:32.653 WARNING (MainThread) [music_assistant.webserver] [140227518736912] Invalid command: players/all

The webui response, but there are no media providers or players listed anywhere, presumably as a result of the above.

Is there something I can reset / check to resolve this?

Thanks
Barry

[OzGav]

Please upgrade to beta 78

[gadgetbazza]

Updated as suggested, seems to be broken still.

2023-12-08 22:59:58.014 INFO (MainThread) [music_assistant] Starting Music Assistant Server (ef55eb0800e04e4cb6da6b00751cf16e) version 2.0.0b78 - uvloop: False
2023-12-08 22:59:58.557 INFO (MainThread) [music_assistant.webserver] Starting server on 0.0.0.0:8095 - base url: http://192.168.4.192:8095
2023-12-08 22:59:58.599 INFO (MainThread) [music_assistant.music] Performing database migration from 25 to 27
2023-12-08 22:59:58.599 WARNING (MainThread) [music_assistant.music] DATABASE MIGRATION IN PROGRESS - THIS CAN TAKE A WHILE
2023-12-08 22:59:58.600 ERROR (MainThread) [asyncio] Task exception was never retrieved
future: <Task finished name='Task-1' coro=<run..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
2023-12-08 23:00:05.523 WARNING (MainThread) [music_assistant.webserver] [140368662332688] Invalid command: players/all
2023-12-08 23:00:05.620 WARNING (MainThread) [music_assistant.webserver] [140368662332688] Invalid command: config/core
2023-12-08 23:00:13.216 WARNING (MainThread) [music_assistant.webserver] [140368662694544] Invalid command: players/all
2023-12-08 23:00:13.432 WARNING (MainThread) [music_assistant.webserver] [140368662694544] Invalid command: music/recently_played_items
2023-12-08 23:00:13.433 WARNING (MainThread) [music_assistant.webserver] [140368662694544] Invalid command: music/recently_played_items
2023-12-08 23:00:13.433 WARNING (MainThread) [music_assistant.webserver] [140368662694544] Invalid command: music/recently_played_items
2023-12-08 23:00:13.434 WARNING (MainThread) [music_assistant.webserver] [140368662694544] Invalid command: music/browse
2023-12-08 23:00:17.301 WARNING (MainThread) [music_assistant.webserver] [140368662694544] Invalid command: config/providers
2023-12-08 23:00:20.848 WARNING (MainThread) [music_assistant.webserver] [140368662694544] Invalid command: config/players
2023-12-08 23:00:22.150 WARNING (MainThread) [music_assistant.webserver] [140368662694544] Invalid command: config/providers/get
2023-12-08 23:00:23.591 WARNING (MainThread) [music_assistant.webserver] [140368662694544] Invalid command: config/providers

Removed the database files from the /data location and restarted the docker and it seems to have rebuilt / recovered...

[OzGav]

For anyone else. You can, without issue, upgrade from b75 to b78. If you have no problems on b76 or b77 you should be able to upgrade to b78 without issue. If you have problems on b76 or b77 you must either roll back to b75 then, assuming all is now well, go to b78 OR do a fresh install of b78