diff options
| author | anoadragon453 <anoadragon453@users.noreply.github.com> | 2024-03-14 13:55:07 +0000 |
|---|---|---|
| committer | anoadragon453 <anoadragon453@users.noreply.github.com> | 2024-03-14 13:55:07 +0000 |
| commit | 051cad208ca17ef13350d0d8810b989c466e9345 (patch) | |
| tree | 716d92006035ed4d5ef020bb32e85cd7ee00d005 /develop/usage | |
| parent | deploy: 9d7880c0c617a1a042f0430de3753af8467e98a5 (diff) | |
| download | synapse-051cad208ca17ef13350d0d8810b989c466e9345.tar.xz | |
deploy: 1c1b0bfa778e32bf740469b0a86be55102bc01b4
Diffstat (limited to 'develop/usage')
| -rw-r--r-- | develop/usage/administration/useful_sql_for_admins.html | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/develop/usage/administration/useful_sql_for_admins.html b/develop/usage/administration/useful_sql_for_admins.html index ce31570096..b501d28f23 100644 --- a/develop/usage/administration/useful_sql_for_admins.html +++ b/develop/usage/administration/useful_sql_for_admins.html @@ -329,6 +329,12 @@ WHERE room_stats_state.room_id = event_json.room_id" | psql -d synapse -h l FROM devices WHERE last_seen < DATE_PART('epoch', NOW() - INTERVAL '3 month') * 1000; </code></pre> +<h2 id="clear-the-cache-of-a-remote-users-device-list"><a class="header" href="#clear-the-cache-of-a-remote-users-device-list">Clear the cache of a remote user's device list</a></h2> +<p>Forces the resync of a remote user's device list - if you have somehow cached a bad state, and the remote server is +will not send out a device list update.</p> +<pre><code class="language-sql">INSERT INTO device_lists_remote_resync +VALUES ('USER_ID', (EXTRACT(epoch FROM NOW()) * 1000)::BIGINT); +</code></pre> </main> |