Database inconsistency from some device IDs

[bdelwood]

After migrating using syn2mas, I got the following error from graphql when looking at the device panel in the user webui:

error: Error: Database inconsistency on table compat_sessions column device_id row 01GBDKE9WE9BA835G0HBW13FZ2

Running mas-cli manage kill-sessions led to a similar error:

2024-05-04T18:11:13.373610Z ERROR cli.manage.kill_sessions{user.username="elwood"}:db.compat_session.lookup{compat_session.id=01GBDKE9WE9BA835G0HBW13FZ2 db.statement="\n                SELECT compat_session_id\n                     , device_id\n                     , user_id\n                     , user_session_id\n                     , created_at\n                     , finished_at\n                     , is_synapse_admin\n                     , user_agent\n                     , last_active_at\n                     , last_active_ip as \"last_active_ip: IpAddr\"\n                FROM compat_sessions\n                WHERE compat_session_id = $1\n            "}: mas_storage_pg::compat::session: error=Database inconsistency on table compat_sessions column device_id row 01GBDKE9WE9BA835G0HBW13FZ2
Error: Database inconsistency on table compat_sessions column device_id row 01GBDKE9WE9BA835G0HBW13FZ2

Caused by:
    Device ID contains invalid characters

I had some really old sessions, generated by the Mautrix bridges, with device IDs like Facebook Messenger Bridge. Dropping the rows with those device IDs in compat_access_tokens and compat_sessions seems to have cleared it up and not broken anything else.