Skip to content
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.

The knocked_members column of room_stats_state is nullable while all other columns are not #11365

Closed
anoadragon453 opened this issue Nov 17, 2021 · 2 comments

Comments

@anoadragon453
Copy link
Member

synapse=> \d room_stats_current
                  Table "public.room_stats_current"
          Column           |  Type   | Collation | Nullable | Default 
---------------------------+---------+-----------+----------+---------
 room_id                   | text    |           | not null | 
 current_state_events      | integer |           | not null | 
 joined_members            | integer |           | not null | 
 invited_members           | integer |           | not null | 
 left_members              | integer |           | not null | 
 banned_members            | integer |           | not null | 
 local_users_in_room       | integer |           | not null | 
 completed_delta_stream_id | bigint  |           | not null | 
 knocked_members           | integer |           |          | 
Indexes:
    "room_stats_current_pkey" PRIMARY KEY, btree (room_id)

Might have been missed in #6739?

@richvdh
Copy link
Member

richvdh commented Nov 17, 2021

@anoadragon453
Copy link
Member Author

D'oh! I must be running off an earlier version of that migration file. It is indeed marked as not null on matrix.org and I assume everywhere else.

Sorry for the noise!

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants