Skip to content

Instantly share code, notes, and snippets.

@richvdh

richvdh/events

Last active January 18, 2018 19:13
Show Gist options
  • Save richvdh/7c036114c14f2e6e90c988dcfe90f024 to your computer and use it in GitHub Desktop.
Save richvdh/7c036114c14f2e6e90c988dcfe90f024 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
events
matrix=# select to_timestamp(received_ts/1000),type from events where room_id='!PVNuPWbpXKukMcpzUY:t2bot.io' and stream_ordering >= 407442057;
to_timestamp | type
------------------------+----------------
2018-01-18 18:51:51+00 | m.room.message
2018-01-18 18:51:55+00 | m.room.message
2018-01-18 18:52:35+00 | m.room.message
2018-01-18 18:52:40+00 | m.room.message
2018-01-18 18:53:06+00 | m.room.message
2018-01-18 18:54:00+00 | m.room.message
2018-01-18 18:59:56+00 | m.room.message
2018-01-18 19:00:00+00 | m.room.message
2018-01-18 19:00:06+00 | m.room.member
2018-01-18 19:00:11+00 | m.room.message
2018-01-18 19:00:26+00 | m.room.message
2018-01-18 19:01:25+00 | m.room.message
2018-01-18 19:01:36+00 | m.room.message
2018-01-18 19:03:17+00 | m.room.message
2018-01-18 19:03:25+00 | m.room.message
2018-01-18 19:04:03+00 | m.room.message
2018-01-18 19:04:06+00 | m.room.message
2018-01-18 19:04:09+00 | m.room.message
2018-01-18 19:04:13+00 | m.room.member
2018-01-18 19:04:16+00 | m.room.message
Raw
log
$ tail -c +2500000000 homeserver.log | grep 'Asking for 4... conflicted events' | tail -n 20
2018-01-18 18:51:50,183 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 18:51:54,883 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 18:52:34,338 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 18:52:39,687 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 18:53:05,888 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 18:54:00,181 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 18:59:55,450 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 18:59:59,004 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:00:06,181 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:00:11,255 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:00:25,805 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:01:24,177 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:01:36,097 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:03:16,439 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:03:25,483 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:04:03,579 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:04:05,938 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:04:09,668 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:04:12,762 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
2018-01-18 19:04:16,399 - synapse.state - 511 - INFO - None - Asking for 4131 conflicted events
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment