Nov 25 20:29:57 matrix-xm-1 synapse[13766]: 2021-11-25 20:29:57,840 - synapse.http.server - 97 - ERROR - POST-4386 - Failed handle request via 'JoinRoomAliasServlet': <XForwardedForRequest at 0x7f9304136a40 method='POST' uri='/_matrix/client/r0/join/!ARdYGWMaXBljKrMuby%3Aproduction.com' clientproto='HTTP/1.1' site='8008'>
Nov 25 20:29:57 matrix-xm-1 synapse[13766]: Traceback (most recent call last):
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/http/server.py", line 262, in _async_render_wrapper
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     callback_return = await self._async_render(request)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/http/server.py", line 451, in _async_render
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     callback_return = await raw_callback_return
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/rest/client/room.py", line 331, in on_POST
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     await self.room_member_handler.update_membership(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/handlers/room_member.py", line 477, in update_membership
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     result = await self.update_membership_locked(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/handlers/room_member.py", line 789, in update_membership_locked
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     remote_join_response = await self._remote_join(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/handlers/room_member.py", line 1533, in _remote_join
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     event_id, stream_id = await self.federation_handler.do_invite_join(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/handlers/federation.py", line 513, in do_invite_join
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     max_stream_id = await self._federation_event_handler.process_remote_join(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/handlers/federation_event.py", line 476, in process_remote_join
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     return await self.persist_events_and_notify(room_id, [(event, context)])
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/handlers/federation_event.py", line 1871, in persist_events_and_notify
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     events, max_stream_token = await self._storage.persistence.persist_events(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/persist_events.py", line 326, in persist_events
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     ret_vals = await yieldable_gather_results(enqueue, partitioned.items())
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/persist_events.py", line 243, in handle_queue_loop
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     ret = await self._per_item_callback(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/persist_events.py", line 581, in _persist_event_batch
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     await self.persist_events_store._persist_events_and_state_updates(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/databases/main/events.py", line 175, in _persist_events_and_state_updates
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     await self.db_pool.runInteraction(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/database.py", line 699, in runInteraction
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     result = await self.runWithConnection(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/database.py", line 804, in runWithConnection
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     return await make_deferred_yieldable(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/twisted/python/threadpool.py", line 238, in inContext
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     result = inContext.theWork()  # type: ignore[attr-defined]
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/twisted/python/threadpool.py", line 254, in <lambda>
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     inContext.theWork = lambda: context.call(  # type: ignore[attr-defined]
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/twisted/python/context.py", line 118, in callWithContext
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     return self.currentContext().callWithContext(ctx, func, *args, **kw)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/twisted/python/context.py", line 83, in callWithContext
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     return func(*args, **kw)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/twisted/enterprise/adbapi.py", line 293, in _runWithConnection
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     compat.reraise(excValue, excTraceback)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/twisted/python/deprecate.py", line 298, in deprecatedFunction
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     return function(*args, **kwargs)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/twisted/python/compat.py", line 404, in reraise
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     raise exception.with_traceback(traceback)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/twisted/enterprise/adbapi.py", line 284, in _runWithConnection
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     result = func(conn, *args, **kw)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/database.py", line 799, in inner_func
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     return func(db_conn, *args, **kwargs)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/database.py", line 567, in new_transaction
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     r = func(cursor, *args, **kwargs)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/logging/utils.py", line 73, in wrapped
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     return f(*args, **kwargs)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/databases/main/events.py", line 406, in _persist_events_txn
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     self._update_current_state_txn(txn, state_delta_for_room, min_stream_order)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/databases/main/events.py", line 1062, in _update_current_state_txn
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     txn.execute_batch(
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/database.py", line 288, in execute_batch
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     self._do_execute(lambda *x: execute_batch(self.txn, *x), sql, args)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/database.py", line 340, in _do_execute
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     return func(sql, *args)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib/python3.10/site-packages/synapse/storage/database.py", line 288, in <lambda>
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     self._do_execute(lambda *x: execute_batch(self.txn, *x), sql, args)
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:   File "/opt/synapse/sw/lib64/python3.10/site-packages/psycopg2/extras.py", line 1187, in execute_batch
Nov 25 20:29:57 matrix-xm-1 synapse[13766]:     cur.execute(b";".join(sqls))
Nov 25 20:29:57 matrix-xm-1 synapse[13766]: psycopg2.errors.NotNullViolation: null value in column "membership" of relation "local_current_membership" violates not-null constraint
Nov 25 20:29:57 matrix-xm-1 synapse[13766]: DETAIL:  Failing row contains (!ARdYGWMaXBljKrMuby:production.com, @userA:development.com, $wkga3wQq3kKsgQIfUoIZ-XrLTuxjKlDijHLEFTTTYEM, null).