Managed to solve it!
In short it was database corruption. After going through the sqlite file I noticed that a brand new home.sqlite3 file has workspaces filled with id 1, 2. with org_id 1, 2.
My home.sqlite3 file was missing line 2…
I added back line 2 with the same id 2, orgid 2 and it magically worked!!
I’ll leave the thread up in case anyone experienced something similar.
SQLlite db browser used: https://sqlitebrowser.org/