[dashboard] Random non-active workspace considered active

[jankeromnes]

Bug description

For some reason, there is an old non-active workspace in my workspaces list, even though it's not active (not opened recently, not pinned).

Workspace ID is blue-ferret-kisxfyd7:

mysql> select id, creationTime, contextURL, description, pinned, softDeleted, softDeletedTime, contentDeletedTime from d_b_workspace where id = 'blue-ferret-kisxfyd7';
+----------------------+--------------------------+------------------------------------------------+--------------------------------------+--------+-------------+-----------------+--------------------+
| id                   | creationTime             | contextURL                                     | description                          | pinned | softDeleted | softDeletedTime | contentDeletedTime |
+----------------------+--------------------------+------------------------------------------------+--------------------------------------+--------+-------------+-----------------+--------------------+
| blue-ferret-kisxfyd7 | 2021-03-24T09:04:52.429Z | https://github.com/gitpod-io/sveltejs-template | gitpod-io/sveltejs-template - master |      0 | NULL        |                 |                    |
+----------------------+--------------------------+------------------------------------------------+--------------------------------------+--------+-------------+-----------------+--------------------+

Surprisingly, it has zero instances 🤔 maybe that's the root cause:

mysql> select * from d_b_workspace_instance where workspaceId = 'blue-ferret-kisxfyd7';
Empty set (0.01 sec)

Steps to reproduce

• Log in to Gitpod (staging) as me

Expected behavior

No response

Example repository

No response

[jankeromnes]

Update: After accidentally starting it, and stopping it again, it disappeared from my list.

Then, after deleting the instance from the DB, it showed up again:

mysql> delete from d_b_workspace_instance where workspaceId = 'blue-ferret-kisxfyd7';
Query OK, 1 row affected (0.01 sec)