summary refs log tree commit diff
Commit message (Collapse)AuthorAgeFilesLines
* Clean up PreserveLoggingContext (#7877)Richard van der Hoff2020-07-222-16/+14
| | | This had some dead code and some just plain wrong docstrings.
* fix an incorrect commentRichard van der Hoff2020-07-221-2/+2
|
* Convert room list handler to async/await. (#7912)Patrick Cloke2020-07-213-41/+32
|
* Element CSS and logo in email templates (#7919)Jason Robinson2020-07-214-0/+12
| | | | | Use Element CSS and logo in notification emails when app name is Element. Signed-off-by: Jason Robinson <jasonr@matrix.org>
* Lint the contrib/ directory in CI and linting scripts, add synctl to linting ↵Andrew Morgan2020-07-2011-82/+71
| | | | | | | script (#7914) Run `isort`, `flake8` and `black` over the `contrib/` directory and `synctl` script. The latter was already being done in CI, but now the linting script does it too. Fixes https://github.com/matrix-org/synapse/issues/7910
* Remove unused code from synapse.logging.utils. (#7897)Karthikeyan Singaravelan2020-07-202-126/+2
|
* Fix a typo in the sample config. (#7890)Adrian2020-07-203-2/+3
|
* Fix deprecation warning: import ABC from collections.abc (#7892)Karthikeyan Singaravelan2020-07-205-6/+7
|
* Change sample config's postgres user to synapse_user (#7889)Andrew Morgan2020-07-203-2/+3
| | | | | | | The [postgres setup docs](https://github.com/matrix-org/synapse/blob/develop/docs/postgres.md#set-up-database) recommend setting up your database with user `synapse_user`. However, uncommenting the postgres defaults in the sample config leave you with user `synapse`. This PR switches the sample config to recommend `synapse_user`. Took a me a second to figure this out, so assume this will beneficial to others.
* Fix deprecation warning due to invalid escape sequences (#7895)Karthikeyan Singaravelan2020-07-202-4/+5
| | | | | | | * Fix deprecation warnings due to invalid escape sequences. * Add changelog Signed-off-by: Karthikeyan Singaravelan <tir.karthi@gmail.com>
* Remove Ubuntu Eoan that is now EOL (#7888)Gary Kim2020-07-172-1/+1
|
* Fix the trace function for async functions. (#7872)Patrick Cloke2020-07-172-23/+41
| | | Co-authored-by: Richard van der Hoff <1389908+richvdh@users.noreply.github.com>
* Add help for creating a user via docker (#7885)Michael Kaye2020-07-172-0/+16
|
* Switch to Debian:Slim from Alpine for the docker image (#7839)Christopher May-Townsend2020-07-173-40/+30
| | | As mentioned in #7397, switching to a debian base should help with multi-arch work to save time on compiling. This is unashamedly based on #6373, but without the extra functionality. Switch python version back to generic 3.7 to always pull the latest. Essentially, keeping this as small as possible. The image is bigger though unfortunately.
* Stop using 'device_max_stream_id' (#7882)Erik Johnston2020-07-174-5/+3
| | | | | It serves no purpose and updating everytime we write to the device inbox stream means all such transactions will conflict, causing lots of transaction failures and retries.
* Fix TypeError in synapse.notifier (#7880)Erik Johnston2020-07-172-0/+9
| | | Fixes #7774
* Add a default limit (of 100) to get/sync operations. (#7858)Patrick Cloke2020-07-174-4/+18
|
* Change "unknown room ver" logging to warning. (#7881)Erik Johnston2020-07-172-1/+2
| | | | It's somewhat expected for us to have unknown room versions in the database due to room version experiments.
* Convert device handler to async/await (#7871)Patrick Cloke2020-07-176-166/+162
|
* Convert synapse.app to async/await. (#7868)Patrick Cloke2020-07-174-41/+37
|
* Convert _base, profile, and _receipts handlers to async/await (#7860)Patrick Cloke2020-07-176-59/+53
|
* Add admin endpoint to get members in a room. (#7842)Michael Albert2020-07-165-1/+107
|
* Consistently use `db_to_json` to convert from database values to JSON ↵Patrick Cloke2020-07-1622-82/+80
| | | | objects. (#7849)
* Combine nginx federation server blocks (#7823)Luke Faraone2020-07-161-11/+5
| | | | | | I'm pretty sure there's no technical reason these have to be distinct server blocks, so collapse into one and go with the more terse location block. Signed-off-by: Luke W Faraone <luke@faraone.cc>
* Optimise queueing of inbound replication commands (#7861)Richard van der Hoff2020-07-162-116/+216
| | | | | | | | | | | When we get behind on replication, we tend to stack up background processes behind a linearizer. Bg processes are heavy (particularly with respect to prometheus metrics) and linearizers aren't terribly efficient once the queue gets long either. A better approach is to maintain a queue of requests to be processed, and nominate a single process to work its way through the queue. Fixes: #7444
* Reject attempts to join empty rooms over federation (#7859)Richard van der Hoff2020-07-162-2/+14
| | | | | | We shouldn't allow others to make_join through us if we've left the room; reject such attempts with a 404. Fixes #7835. Fixes #6958.
* Allow moving typing off master (#7869)Erik Johnston2020-07-1610-178/+284
|
* Add ability to run multiple pusher instances (#7855)Erik Johnston2020-07-169-82/+293
| | | This reuses the same scheme as federation sender sharding
* Merge pull request #7866 from matrix-org/rav/fix_guest_user_idRichard van der Hoff2020-07-1611-81/+196
|\ | | | | Fix guest user registration with lots of client readers
| * changelogRichard van der Hoff2020-07-161-0/+1
| |
| * Use a postgres sequence to generate guest user IDsRichard van der Hoff2020-07-164-51/+82
| |
| * Use SequenceGenerator for state group ID allocationRichard van der Hoff2020-07-164-26/+11
| |
| * Use `PostgresSequenceGenerator` from `MultiWriterIdGenerator`Richard van der Hoff2020-07-161-4/+4
| | | | | | | | partly just to show it works, but alwo to remove a bit of code duplication.
| * Add some helper classes for generating ID sequencesRichard van der Hoff2020-07-161-0/+98
| |
* | Add some tiny type annotations (#7870)Richard van der Hoff2020-07-163-8/+7
| | | | | | I found these made pycharm have more of a clue as to what was going on in other places.
* | Remove obsolete comment.Olivier Wilkinson (reivilibre)2020-07-161-2/+0
| | | | | | | | | | | | | | | | It was correct at the time of our friend Jorik writing it (checking git blame), but the world has moved now and it is no longer a generator. Signed-off-by: Olivier Wilkinson (reivilibre) <olivier@librepush.net>
* | Ensure that calls to `json.dumps` are compatible with the standard library ↵Patrick Cloke2020-07-158-13/+22
| | | | | | | | json. (#7836)
* | Avoid brand new rooms in `delete_old_current_state_events` (#7854)Richard van der Hoff2020-07-152-10/+56
| | | | | | | | | | | | | | | | When considering rooms to clean up in `delete_old_current_state_events`, skip rooms which we are creating, which otherwise look a bit like rooms we have left. Fixes #7834.
* | Merge branch 'erikj/faster_typing' of github.com:matrix-org/synapse into developErik Johnston2020-07-153-4/+5
|\ \ | |/ |/|
| * Fix testsErik Johnston2020-07-151-2/+2
| |
| * Fix typoErik Johnston2020-07-151-1/+1
| |
| * NewsfileErik Johnston2020-07-151-0/+1
| |
| * Use get_users_in_room rather than state handler in typing for speedErik Johnston2020-07-151-2/+2
| |
* | Allow accounts to be re-activated from the admin APIs. (#7847)Patrick Cloke2020-07-155-22/+90
| |
* | Fix client reader sharding tests (#7853)Erik Johnston2020-07-157-174/+300
|/ | | | | | | | | | | | | | | * Fix client reader sharding tests * Newsfile * Fix typing * Update changelog.d/7853.misc Co-authored-by: Patrick Cloke <clokep@users.noreply.github.com> * Move mocking of http_client to tests Co-authored-by: Patrick Cloke <clokep@users.noreply.github.com>
* Convert E2E key and room key handlers to async/await. (#7851)Patrick Cloke2020-07-155-361/+521
|
* Return the proper 403 Forbidden error during errors with JWT logins. (#7844)Patrick Cloke2020-07-154-30/+27
|
* remove `retry_on_integrity_error` wrapper for persist_events (#7848)Richard van der Hoff2020-07-152-67/+1
| | | | | | | | | As far as I can tell from the sentry logs, the only time this has actually done anything in the last two years is when we had two master workers running at once, and even then, it made a bit of a mess of it (see https://github.com/matrix-org/synapse/issues/7845#issuecomment-658238739). Generally I feel like this code is doing more harm than good.
* Fix bug in per-room message retention policies. (#7850)Patrick Cloke2020-07-142-1/+2
|
* Allow email subjects to be customised through Synapse's configuration (#7846)Brendan Abolivier2020-07-144-39/+202
|
* Add delete room admin endpoint (#7613)Dirk Klimpel2020-07-1412-113/+775
| | | | | | | | | | | | | | | | | | The Delete Room admin API allows server admins to remove rooms from server and block these rooms. `DELETE /_synapse/admin/v1/rooms/<room_id>` It is a combination and improvement of "[Shutdown room](https://github.com/matrix-org/synapse/blob/develop/docs/admin_api/shutdown_room.md)" and "[Purge room](https://github.com/matrix-org/synapse/blob/develop/docs/admin_api/purge_room.md)" API. Fixes: #6425 It also fixes a bug in [synapse/storage/data_stores/main/room.py](synapse/storage/data_stores/main/room.py) in ` get_room_with_stats`. It should return `None` if the room is unknown. But it returns an `IndexError`. https://github.com/matrix-org/synapse/blob/901b1fa561e3cc661d78aa96d59802cf2078cb0d/synapse/storage/data_stores/main/room.py#L99-L105 Related to: - #5575 - https://github.com/Awesome-Technologies/synapse-admin/issues/17 Signed-off-by: Dirk Klimpel dirk@klimpel.org
* Add the option to validate the `iss` and `aud` claims for JWT logins. (#7827)Patrick Cloke2020-07-146-15/+182
|
* Improve the type hints of synapse.api.errors. (#7820)Patrick Cloke2020-07-142-55/+74
|
* Clearly state built-in ACME no longer works (#7824)Luke Faraone2020-07-141-7/+5
| | | | | I'm tempted to remove this section entirely, but it's helpful for admins who are trying to figure out why their Synapse is crashing on start with ACME errors. Signed-off-by: Luke W Faraone <luke@faraone.cc>
* Correctly pass app_name to all email templates. (#7829)Erik Johnston2020-07-142-2/+9
| | | We didn't do this for e.g. registration emails.
* Support handling registration requests across multiple client readers. (#7830)Patrick Cloke2020-07-133-1/+136
|
* Fix handling of "off" in encryption_enabled_by_default_for_room_type (#7822)Brendan Abolivier2020-07-132-1/+7
| | | | | | | | | | | | | | | | | Fixes https://github.com/matrix-org/synapse/issues/7821, introduced in https://github.com/matrix-org/synapse/pull/7639 Turns out PyYAML translates `off` into a `False` boolean if it's unquoted (see https://stackoverflow.com/questions/36463531/pyyaml-automatically-converting-certain-keys-to-boolean-values), which seems to be a liberal interpretation of this bit of the YAML spec: https://yaml.org/spec/1.1/current.html#id864510 An alternative fix would be to implement the solution mentioned in the SO post linked above, but I'm aware it might break existing setups (which might use these values in the configuration file) so it's probably better just to add an extra check for this one. We should be aware that this is a thing for the next times we do that though. I didn't find any other occurrence of this bug elsewhere in the codebase.
* Update grafana dashboardRichard van der Hoff2020-07-131-85/+214
|
* Merge branch 'master' into developRichard van der Hoff2020-07-133-4/+14
|\
| * 1.17.0 v1.17.0 github/release-v1.17.0 release-v1.17.0Richard van der Hoff2020-07-133-4/+14
| |
* | Do not use canonicaljson to magically handle decoding bytes from JSON. (#7802)Patrick Cloke2020-07-107-28/+17
| |
* | Add types to the server code and remove unused parameter (#7813)Patrick Cloke2020-07-102-30/+42
| |
* | Include room states on invite events sent to ASes (#6455)Sorunome2020-07-102-4/+17
| |
* | Merge branch 'release-v1.17.0' into developRichard van der Hoff2020-07-103-0/+41
|\|
| * Merge branch 'master' into release-v1.17.0Richard van der Hoff2020-07-103-0/+41
| |\
| | * update changelog v1.16.1 github/release-v1.16.1 release-v1.16.1Richard van der Hoff2020-07-101-1/+1
| | |
| | * fix migration, againRichard van der Hoff2020-07-101-1/+1
| | |
| | * fix changelogRichard van der Hoff2020-07-101-6/+0
| | |
| | * 1.16.1Richard van der Hoff2020-07-104-2/+26
| | |
| | * Drop incorrectly-added table `local_rejections_stream`. (#7816)Richard van der Hoff2020-07-102-0/+23
| | |
* | | Add ability to shard the federation sender (#7798)Erik Johnston2020-07-1015-157/+670
| | |
* | | Fix resync remote devices on receive PDU in worker mode. (#7815)Erik Johnston2020-07-102-8/+20
| | | | | | | | | | | | | | | | | | The replication client requires that arguments are given as keyword arguments, which was not done in this case. We also pull out the logic so that we can catch and handle any exceptions raised, rather than leaving them unhandled.
* | | Fix recursion error when fetching auth chain over federation (#7817)Erik Johnston2020-07-103-16/+44
|/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | When fetching the state of a room over federation we receive the event IDs of the state and auth chain. We then fetch those events that we don't already have. However, we used a function that recursively fetched any missing auth events for the fetched events, which can lead to a lot of recursion if the server is missing most of the auth chain. This work is entirely pointless because would have queued up the missing events in the auth chain to be fetched already. Let's just diable the recursion, since it only gets called from one place anyway.
* | 1.17.0rc1 v1.17.0rc1Richard van der Hoff2020-07-0929-27/+54
| |
* | Fix some spelling mistakes / typos. (#7811)Patrick Cloke2020-07-0931-40/+41
| |
* | `update_membership` declaration: now always returns an event id. (#7809)Richard van der Hoff2020-07-094-9/+8
| |
* | Improve stacktraces from exceptions in background processes (#7808)Richard van der Hoff2020-07-092-1/+10
| | | | | | use `Failure()` to fish out the real exception.
* | Fix `can only concatenate list (not "tuple") to list` exception (#7810)Richard van der Hoff2020-07-092-1/+2
| | | | | | It seems auth_events can be either a list or a tuple, depending on Things.
* | Pass original request headers from workers to the main process. (#7797)Patrick Cloke2020-07-092-5/+26
| |
* | Generate real events when we reject invites (#7804)Richard van der Hoff2020-07-097-169/+184
| | | | | | | | | | | | | | | | Fixes #2181. The basic premise is that, when we fail to reject an invite via the remote server, we can generate our own out-of-band leave event and persist it as an outlier, so that we have something to send to the client.
* | Add `HomeServer.signing_key` property (#7805)Richard van der Hoff2020-07-0810-12/+12
| | | | | | ... instead of duplicating `config.signing_key[0]` everywhere
* | Revert "Update the installation docs on apt-transport-https (#7801)"Richard van der Hoff2020-07-082-12/+0
| | | | | | | | | | | | | | | | This reverts commit e0c01296936a178d83556fc4f00f69e429fa7ba5. As discussed at https://github.com/matrix-org/synapse/pull/7801#pullrequestreview-444652786, I don't think this is an improvement.
* | Do not use simplejson in Synapse. (#7800)Patrick Cloke2020-07-086-25/+11
| |
* | Stop passing bytes when dumping JSON (#7799)Patrick Cloke2020-07-084-6/+11
| |
* | Update the installation docs on apt-transport-https (#7801)Dirk Heinrichs2020-07-082-0/+12
| | | | | | | | | | * Starting with apt 1.6, https support has moved into the main package and apt-transport-https has become a transitional dummy package. Signed-off-by: Dirk Heinrichs <dirk.heinrichs@altum.de>
* | Merge branch 'master' into developRichard van der Hoff2020-07-083-6/+17
|\|
| * shuffle changelog slightly v1.16.0 github/release-v1.16.0 release-v1.16.0Richard van der Hoff2020-07-081-6/+5
| |
| * 1.16.0Richard van der Hoff2020-07-083-1/+13
| |
* | Change Caddy links (old is deprecated) (#7789)Nicolai Søborg2020-07-083-2/+3
| | | | | | | | | | | | | | * Change Caddy links Current links points to Caddy v1 which is deprecated. Signed-off-by: Nicolai Søborg <git@xn--sb-lka.org>
* | Stop populating unused table `local_invites`. (#7793)Richard van der Hoff2020-07-075-81/+25
| | | | | | | | | | This table is no longer used, so we may as well stop populating it. Removing it would prevent people rolling back to older releases of Synapse, so that can happen in a future release.
* | Refactor getting replication updates from database v2. (#7740)Erik Johnston2020-07-0711-195/+336
| |
* | Add libwebp dependency to Dockerfile (#7791)Juho Vanhanen2020-07-062-0/+3
| | | | | | | | | | * Add libwebp dependency to Dockerfile Signed-off-by: Juho Vanhanen <juho@vanhanen.io>
* | Add documentation for JWT login type and improve sample config. (#7776)Patrick Cloke2020-07-065-29/+180
| |
* | Convert the appservice handler to async/await. (#7775)Patrick Cloke2020-07-064-76/+68
| |
* | Don't ignore `set_tweak` actions with no explicit `value`. (#7766)reivilibre2020-07-063-4/+45
| | | | | | | | | | | | | | | | | | | | | | | | | | | | * Fix spec compliance; tweaks without values are valid (default to True, which is only concretely specified for `highlight`, but it seems only reasonable to generalise) * Changelog for 7766. * Add documentation to `tweaks_for_actions` May as well tidy up when I'm here. * Add a test for `tweaks_for_actions`
* | Allow to use higher versions of prometheus_client (#7780)Oliver Kurz2020-07-062-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixes https://github.com/matrix-org/synapse/issues/7641 The package was pinned to <0.8.0 without an obvious reasoning with 7ad1d7635 in https://github.com/matrix-org/synapse/pull/5636 while the version selection looks to just try to exclude an arbitrary next minor version number that might introduce API breaking changes. Selecting the next minor number might be a good conservative selection. Downstream distributions already reported success patching out the version requirements. This also fixes the integration of upgraded packages into openSUSE packages, e.g. for openSUSE Tumbleweed which already ships prometheus_client >= 0.8 . Signed-off-by: Oliver Kurz <okurz@suse.de> Co-authored-by: Richard van der Hoff <1389908+richvdh@users.noreply.github.com>
* | isort 5 compatibility (#7786)Will Hunt2020-07-0523-38/+22
| | | | | | The CI appears to use the latest version of isort, which is a problem when isort gets a major version bump. Rather than try to pin the version, I've done the necessary to make isort5 happy with synapse.
* | Merge different Resource implementation classes (#7732)Erik Johnston2020-07-0318-318/+322
| |
* | Fix inconsistent handling of upper and lower cases of email addresses. (#7021)Dirk Klimpel2020-07-038-48/+279
| | | | | | fixes #7016
* | Allow YAML config file to contain None (#7779)Alex Kotov2020-07-032-1/+3
| | | | | | | | | | Useful when config file is fully commented Signed-off-by: Alex Kotov <kotovalexarian@gmail.com>
* | Merge tag 'v1.16.0rc2' into developPatrick Cloke2020-07-025-24/+41
|\| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Synapse 1.16.0rc2 (2020-07-02) ============================== Synapse 1.16.0rc2 includes the security fixes released with Synapse 1.15.2. Please see [below](https://github.com/matrix-org/synapse/blob/master/CHANGES.md#synapse-1152-2020-07-02) for more details. Improved Documentation ---------------------- - Update postgres image in example `docker-compose.yaml` to tag `12-alpine`. ([\#7696](https://github.com/matrix-org/synapse/issues/7696)) Internal Changes ---------------- - Add some metrics for inbound and outbound federation latencies: `synapse_federation_server_pdu_process_time` and `synapse_event_processing_lag_by_event`. ([\#7771](https://github.com/matrix-org/synapse/issues/7771))
| * Fix a typo. v1.16.0rc2Patrick Cloke2020-07-021-1/+1
| |
| * Move 1.15.2 after 1.16.0rc2.Patrick Cloke2020-07-021-20/+20
| |
| * 1.16.0rc2Patrick Cloke2020-07-024-3/+19
| |
| * Merge branch 'master' into release-v1.16.0Patrick Cloke2020-07-0215-98/+134
| |\
| * | Fix new metric where we used ms instead of seconds (#7771)Erik Johnston2020-07-013-2/+3
| | | | | | | | | | | | Introduced in #7755, not yet released.
* | | Merge branch 'master' into developPatrick Cloke2020-07-0215-98/+134
|\ \ \ | | |/ | |/|
| * | Merge tag 'v1.15.2'Patrick Cloke2020-07-0214-98/+133
| |\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Synapse 1.15.2 (2020-07-02) =========================== Due to the two security issues highlighted below, server administrators are encouraged to update Synapse. We are not aware of these vulnerabilities being exploited in the wild. Security advisory ----------------- * A malicious homeserver could force Synapse to reset the state in a room to a small subset of the correct state. This affects all Synapse deployments which federate with untrusted servers. ([96e9afe6](https://github.com/matrix-org/synapse/commit/96e9afe62500310977dc3cbc99a8d16d3d2fa15c)) * HTML pages served via Synapse were vulnerable to clickjacking attacks. This predominantly affects homeservers with single-sign-on enabled, but all server administrators are encouraged to upgrade. ([ea26e9a9](https://github.com/matrix-org/synapse/commit/ea26e9a98b0541fc886a1cb826a38352b7599dbe)) This was reported by [Quentin Gliech](https://sandhose.fr/).
| | * | Remove an extraneous space. v1.15.2 github/release-v1.15.2 release-v1.15.2Patrick Cloke2020-07-021-1/+1
| | | |
| | * | Add links to the fixes.Patrick Cloke2020-07-021-2/+2
| | | |
| | * | Fix tense in the release notes.Patrick Cloke2020-07-021-1/+1
| | | |
| | * | 1.15.2Patrick Cloke2020-07-023-1/+27
| | | |
| | * | Correctly handle outliers as prev events over federationErik Johnston2020-07-021-3/+3
| | | |
| | * | Ensure that HTML pages served from Synapse include headers to avoid embedding.Patrick Cloke2020-07-0210-94/+103
| | | |
| * | | Update postgres in the Docker compose example to 12-alpine. (#7696)lub2020-06-172-1/+2
| |/ /
* | | Hack to add push priority to push notifications (#7765)reivilibre2020-07-013-8/+362
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Remove obsolete comment about ancient temporary code Signed-off-by: Olivier Wilkinson (reivilibre) <olivier@librepush.net> * Implement hack to set push priority based on whether the tweaks indicate the event might cause effects. * Changelog for 7765 Signed-off-by: Olivier Wilkinson (reivilibre) <olivier@librepush.net> * Antilint * Add tests for push priority Signed-off-by: Olivier Wilkinson (reivilibre) <olivier@librepush.net> * Update synapse/push/httppusher.py Co-authored-by: Brendan Abolivier <babolivier@matrix.org> * Antilint * Remove needless invites from tests. Co-authored-by: Brendan Abolivier <babolivier@matrix.org>
* | | Add early returns to `_check_for_soft_fail` (#7769)Richard van der Hoff2020-07-012-64/+56
| | | | | | | | | | | | my editor was complaining about unset variables, so let's add some early returns to fix that and reduce indentation/cognitive load.
* | | Use symbolic names for replication stream names (#7768)Richard van der Hoff2020-07-0111-22/+27
| | | | | | | | | This makes it much easier to find where streams are referenced.
* | | Type checking for `FederationHandler` (#7770)Richard van der Hoff2020-07-013-17/+32
| | | | | | | | | fix a few things to make this pass mypy.
* | | Fix incorrect error message when database CTYPE was set incorrectly. (#7760)Richard van der Hoff2020-07-012-1/+2
| |/ |/|
* | Pin link in CHANGES.md v1.16.0rc1Andrew Morgan2020-07-011-1/+1
| |
* | Fixes to CHANGES.mdAndrew Morgan2020-07-011-8/+12
| |
* | 1.16.0rc1Andrew Morgan2020-07-0145-44/+71
| |
* | Back out MSC2625 implementation (#7761)Brendan Abolivier2020-07-0111-189/+53
| |
* | Additional configuration options for auto-join rooms (#7763)Patrick Cloke2020-06-306-71/+542
| |
* | Add some metrics for inbound and outbound federation processing times (#7755)Erik Johnston2020-06-305-17/+43
| |
* | Explain the purpose of the "tests" conditional dependency requirement (#7751)Andrew Morgan2020-06-302-0/+5
| |
* | Add another yield point to state res v2 (#7746)Erik Johnston2020-06-262-2/+11
| |
* | Move flake8 to end. Don't exit script on failure (#7738)Andrew Morgan2020-06-252-2/+3
| |
* | Make tox actions work on Debian 10 (#7703)Dagfinn Ilmari Mannsåker2020-06-252-4/+3
| | | | | | | | | | | | - Remove the requirement for a specific version of Python - Move dep comment to a separate line, Tox 3.7.0 like trailing ones Signed-off-by: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>
* | Yield during large v2 state res. (#7735)Erik Johnston2020-06-245-11/+62
| | | | | | | | | | | | | | | | | | | | | | State res v2 across large data sets can be very CPU intensive, and if all the relevant events are in the cache the algorithm will run from start to finish within a single reactor tick. This can result in blocking the reactor tick for several seconds, which can have major repercussions on other requests. To fix this we simply add the occaisonal `sleep(0)` during iterations to yield execution until the next reactor tick. The aim is to only do this for large data sets so that we don't impact otherwise quick resolutions.=
* | add org.matrix.login.jwt so that m.login.jwt can be deprecated (#7675)Sorunome2020-06-243-4/+12
| |
* | Set Content-Length for Metrics requests (#7730)Christian Svensson2020-06-232-1/+5
| | | | | | | | | | | | HTTP requires the response to contain a Content-Length header unless chunked encoding is being used. Prometheus metrics endpoint did not set this, causing software such as prometheus-proxy to not be able to scrape synapse for metrics. Signed-off-by: Christian Svensson <blue@cmd.nu>
* | Sync ignored table names in synapse_port_db to current database schema (#7717)Patrick Cloke2020-06-232-4/+13
| |
* | Allow local media to be marked as safe from being quarantined. (#7718)Patrick Cloke2020-06-227-107/+119
| |
* | Convert directory handler to async/await (#7727)Patrick Cloke2020-06-223-40/+33
| |
* | Speed up state res v2 across large state differences. (#7725)Erik Johnston2020-06-192-1/+3
| |
* | Fixed typo by adding a 'g' to PostgreSQL (#7724)Jesse Riddle2020-06-192-1/+2
| |
* | add a commentRichard van der Hoff2020-06-181-0/+2
| |
* | Merge pull request #7716 from matrix-org/babolivier/unread_fixBrendan Abolivier2020-06-173-2/+3
|\ \ | | | | | | Fix unread counts in sync
| * | Fix unread counts in syncBrendan Abolivier2020-06-173-2/+3
| | | | | | | | | | | | | | | * Always return an unread_count in get_unread_event_push_actions_by_room_for_user * Don't always expect unread_count to be there so we don't take out sync entirely if something goes wrong
* | | Convert the typing handler to async/await. (#7679)Patrick Cloke2020-06-173-24/+19
| | |
* | | Require parameterized package version to be at least 0.7.0. (#7680)Oleg Girko2020-06-172-1/+3
|/ / | | | | | | | | Older versions of `parameterized` package have no `parameterized_class` decorator. This decorator is used in tests. Signed-off-by: Oleg Girko <ol@infoserver.lv>
* | Ignore the UI Auth sessions when porting from sqlite to postgresql (#7711)Patrick Cloke2020-06-172-7/+13
| |
* | Add support for using rust-python-jaeger-reporter (#7697)Erik Johnston2020-06-173-3/+40
| |
* | Support running multiple media repos. (#7706)Erik Johnston2020-06-174-4/+28
| | | | | | | | | | This requires a new config option to specify which media repo should be responsible for running background jobs to e.g. clear out expired URL preview caches.
* | Fetch from the r0 media path instead of the unspecced v1. (#7714)Patrick Cloke2020-06-173-5/+6
| |
* | Implement unread counter (MSC2625) (#7673)Brendan Abolivier2020-06-179-51/+187
|\ \ | | | | | | Implementation of https://github.com/matrix-org/matrix-doc/pull/2625
| * \ Merge branch 'develop' into babolivier/mark_unreadBrendan Abolivier2020-06-1557-292/+363
| |\ \
| * \ \ Merge branch 'develop' into babolivier/mark_unreadBrendan Abolivier2020-06-1526-115/+448
| |\ \ \
| * | | | Incorporate reviewBrendan Abolivier2020-06-151-15/+11
| | | | |
| * | | | LintBrendan Abolivier2020-06-121-3/+8
| | | | |
| * | | | Incorporate review bitsBrendan Abolivier2020-06-123-22/+20
| | | | |
| * | | | Pre-populate the unread_count columnBrendan Abolivier2020-06-121-0/+5
| | | | |
| * | | | Don't update the schema versionBrendan Abolivier2020-06-122-1/+1
| | | | |
| * | | | Use attr instead of a dictBrendan Abolivier2020-06-121-21/+31
| | | | |
| * | | | LintBrendan Abolivier2020-06-121-3/+1
| | | | |
| * | | | Test that a mark_unread action updates the right counter when using a slave ↵Brendan Abolivier2020-06-121-0/+15
| | | | | | | | | | | | | | | | | | | | store
| * | | | Remove debug loggingBrendan Abolivier2020-06-121-2/+0
| | | | |
| * | | | Test that a mark_unread action updates the right counterBrendan Abolivier2020-06-121-5/+16
| | | | |
| * | | | Fix summary rotationBrendan Abolivier2020-06-121-12/+35
| | | | |
| * | | | Log for invalid values of notifBrendan Abolivier2020-06-111-0/+6
| | | | |
| * | | | Fix SQLBrendan Abolivier2020-06-111-3/+3
| | | | |
| * | | | Fix schema updateBrendan Abolivier2020-06-111-1/+1
| | | | |
| * | | | LintBrendan Abolivier2020-06-111-1/+2
| | | | |
| * | | | Save the count of unread messages to event_push_summaryBrendan Abolivier2020-06-113-20/+53
| | | | |
| * | | | Actually act on mark_unreadBrendan Abolivier2020-06-111-3/+7
| | | | |
| * | | | Appease mypyBrendan Abolivier2020-06-101-1/+1
| | | | |
| * | | | LintBrendan Abolivier2020-06-101-3/+3
| | | | |
| * | | | Use temporary prefixes as per the MSCBrendan Abolivier2020-06-103-3/+5
| | | | |
| * | | | ChangelogBrendan Abolivier2020-06-102-1/+1
| | | | |
| * | | | Fix testsBrendan Abolivier2020-06-102-17/+21
| | | | |
| * | | | Use a more efficient way of calculating countersBrendan Abolivier2020-06-101-23/+20
| | | | |
| * | | | Add a new unread_counter to sync responsesBrendan Abolivier2020-06-103-3/+28
| | | | |
| * | | | Rename dont_push into mark_unreadBrendan Abolivier2020-06-102-5/+4
| | | | |
| * | | | Merge branch 'develop' into babolivier/mark_unreadBrendan Abolivier2020-06-10963-30448/+65965
| |\ \ \ \
| * | | | | changelogMatthew Hodgson2019-09-191-0/+1
| | | | | |
| * | | | | Add experimental "dont_push" push action to suppress push for notificationsMatthew Hodgson2019-09-191-5/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This is a potential solution to https://github.com/vector-im/riot-web/issues/3374 and https://github.com/vector-im/riot-web/issues/5953 as raised by Mozilla at https://github.com/vector-im/riot-web/issues/10868. This lets you define a push rule action which increases the badge count (unread notification) count on a given room, but doesn't actually send a push for that notification via email or HTTP. We might want to define this as the default behaviour for group chats in future to solve https://github.com/vector-im/riot-web/issues/3268 at last. This is implemented as a string action rather than a tweak because: * Other pushers don't care about the tweak, given they won't ever get pushed * The DB can store the tweak more efficiently using the existing `notify` table. * It avoids breaking the default_notif/highlight_action optimisations. Clients which generate their own notifs (e.g. desktop notifs from Riot/Web would need to be aware of the new push action) to uphold it. An alternative way to do this would be to maintain a `msg_count` alongside `highlight_count` and `notification_count` in `unread_notifications` in sync responses. However, doing this by counting the rows in `events` since the `stream_position` of the user's last read receipt turns out to be painfully slow (~200ms), perhaps due to the size of the events table. So instead, we use the highly optimised existing event_push_actions (and event_push_actions_staging) table to maintain the counts - using the code paths which already exist for tracking unread notification counts efficiently. These queries are typically ~3ms or so. The biggest issues I see here are: * We're slightly repurposing the `notif` field on `event_push_actions` to track whether a given action actually sent a `push` or not. This doesn't seem unreasonable, but it's slightly naughty given that previously the field explicitly tracked whether `notify` was true for the action (and as a result, it was uselessly always set to 1 in the DB). * We're going to put more load on the `event_push_actions` table for all the random group chats which people had previously muted. In practice i don't think there are many of these though. * There isn't an MSC for this yet (although this comment could become one).
* | | | | | fix broken link in sample config (#7712)Richard van der Hoff2020-06-163-2/+3
| | | | | |
* | | | | | Refactor getting replication updates from database. (#7636)Erik Johnston2020-06-169-72/+251
| | | | | | | | | | | | | | | | | | The aim here is to make it easier to reason about when streams are limited and when they're not, by moving the logic into the database functions themselves. This should mean we can kill of `db_query_to_update_function` function.
* | | | | | Fix "argument of type 'ObservableDeferred' is not iterable" error (#7708)Patrick Cloke2020-06-163-5/+7
| | | | | |
* | | | | | Add instructions for authing with Keycloak via OpenID (#7659)hungrymonkey2020-06-162-0/+45
| | | | | |
* | | | | | Include a user agent in federation requests. (#7677)Patrick Cloke2020-06-165-4/+43
| | | | | |
* | | | | | Replace all remaining six usage with native Python 3 equivalents (#7704)Dagfinn Ilmari Mannsåker2020-06-1673-237/+111
| | | | | |
* | | | | | Convert the device message and pagination handlers to async/await. (#7678)Patrick Cloke2020-06-163-31/+19
| | | | | |
* | | | | | Create a ListenerConfig object (#7681)Richard van der Hoff2020-06-1613-167/+248
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This ended up being a bit more invasive than I'd hoped for (not helped by generic_worker duplicating some of the code from homeserver), but hopefully it's an improvement. The idea is that, rather than storing unstructured `dict`s in the config for the listener configurations, we instead parse it into a structured `ListenerConfig` object.
* | | | | | Merge branch 'master' into developBrendan Abolivier2020-06-167-9/+81
|\ \ \ \ \ \ | | |_|_|_|/ | |/| | | |
| * | | | | Fix changelog wording v1.15.1 github/release-v1.15.1 release-v1.15.1Brendan Abolivier2020-06-161-2/+2
| | | | | |
| * | | | | 1.15.1Brendan Abolivier2020-06-165-3/+17
| | | | | |
| * | | | | Wrap register_device coroutine in an ensureDeferred (#7684)Andrew Morgan2020-06-164-5/+62
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixes https://github.com/matrix-org/synapse/issues/7683 Broke in: #7649 We had a `yield` acting on a coroutine. To be fair this one is a bit difficult to notice as there's a function in the middle that just passes the coroutine along.
| * | | | | Merge pull request #7685 from matrix-org/babolivier/3pid_r0Brendan Abolivier2020-06-152-3/+4
| |\ \ \ \ \ | | | | | | | | | | | | | | Enable 3PID add/bind/unbind endpoints on r0 routes
| | * | | | | Enable 3PID add/bind/unbind endpoints on r0 routesBrendan Abolivier2020-06-152-3/+4
| |/ / / / /
* | | | | | Ensure the body is a string before comparing push rules. (#7701)Patrick Cloke2020-06-153-11/+33
| | | | | |
* | | | | | Ensure etag is a string for GET room_keys/version response (#7691)Hubert Chathi2020-06-153-0/+3
| | | | | |
* | | | | | Update m.id.phone to use 'phone' instead of 'number' (#7687)Andrew Morgan2020-06-152-2/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The spec [states](https://matrix.org/docs/spec/client_server/r0.6.1#phone-number) that `m.id.phone` requires the field `country` and `phone`. In Synapse, we've been enforcing `country` and `number`. I am not currently sure whether this affects any client implementations. This issue was introduced in #1994.
* | | | | | Fix "There was no active span when trying to log." error (#7698)Erik Johnston2020-06-152-0/+2
| |_|_|_|/ |/| | | |
* | | | | Discard RDATA from already seen positions. (#7648)Patrick Cloke2020-06-156-27/+175
| | | | |
* | | | | Replace iteritems/itervalues/iterkeys with native versions. (#7692)Patrick Cloke2020-06-1547-263/+184
| | | | |
* | | | | Fix warnings about losing log context during UI auth. (#7688)Patrick Cloke2020-06-122-1/+2
| | | | |
* | | | | Fix a typo when comparing the URI & method during UI Auth. (#7689)Patrick Cloke2020-06-122-1/+2
| |_|_|/ |/| | |
* | | | Remove "user_id" from GET /presence. (#7606)Will Hunt2020-06-112-1/+4
| | | |
* | | | Merge branch 'master' into developBrendan Abolivier2020-06-113-4/+16
|\| | |
| * | | 1.15.0 v1.15.0 github/release-v1.15.0 release-v1.15.0Brendan Abolivier2020-06-113-1/+13
| | | |
| * | | Merge branch 'release-v1.15.0' of github.com:matrix-org/synapse into ↵Brendan Abolivier2020-06-090-0/+0
| |\ \ \ | | | | | | | | | | | | | | | release-v1.15.0
| | * | | Update CHANGES.mdRichard van der Hoff2020-06-091-1/+1
| | | |/ | | |/| | | | | fix a typo
| * / | Fix some attributionsBrendan Abolivier2020-06-091-3/+3
| |/ /
* | | Increase the default SAML session expirary time to 15 minutes. (#7664)Patrick Cloke2020-06-113-3/+4
| | |
* | | fix typo in sample_config.yaml (#7652)wondratsch2020-06-113-2/+3
| | | | | | | | | | | | | | | Just a simple typo fix. Signed-off-by: wondratsch 28294257+wondratsch@users.noreply.github.com
* | | Take out a lock before modifying _CACHES (#7663)Richard van der Hoff2020-06-102-5/+16
| | | | | | | | | | | | This should fix #7610.
* | | Add option to enable encryption by default for new rooms (#7639)Andrew Morgan2020-06-1011-36/+275
| | | | | | | | | | | | | | | | | | | | | | | | | | | Fixes https://github.com/matrix-org/synapse/issues/2431 Adds config option `encryption_enabled_by_default_for_room_type`, which determines whether encryption should be enabled with the default encryption algorithm in private or public rooms upon creation. Whether the room is private or public is decided based upon the room creation preset that is used. Part of this PR is also pulling out all of the individual instances of `m.megolm.v1.aes-sha2` into a constant variable to eliminate typos ala https://github.com/matrix-org/synapse/pull/7637 Based on #7637
* | | Clean-up the fallback login code. (#7657)Patrick Cloke2020-06-104-64/+130
|/ /
* | 1.15.0rc1 v1.15.0rc1Brendan Abolivier2020-06-0945-44/+67
| |
* | Revert "1.15.0rc1"Brendan Abolivier2020-06-0945-67/+44
| | | | | | | | This reverts commit 8587b0426fa4e65992aaa47158e991fa1797d3fb.
* | 1.15.0rc1Brendan Abolivier2020-06-0945-44/+67
| |
* | Fix bug in account data replication stream. (#7656)Erik Johnston2020-06-096-4/+35
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Ensure account data stream IDs are unique. The account data stream is shared between three tables, and the maximum allocated ID was tracked in a dedicated table. Updating the max ID happened outside the transaction that allocated the ID, leading to a race where if the server was restarted then the same ID could be allocated but the max ID failed to be updated, leading it to be reused. The ID generators have support for tracking across multiple tables, so we may as well use that instead of a dedicated table. * Fix bug in account data replication stream. If the same stream ID was used in both global and room account data then the getting updates for the replication stream would fail due to `heapq.merge(..)` trying to compare a `str` with a `None`. (This is because you'd have two rows like `(534, '!room')` and `(534, None)` from the room and global account data tables). Fix is just to order by stream ID, since we don't rely on the ordering beyond that. The bug where stream IDs can be reused should be fixed now, so this case shouldn't happen going forward. Fixes #7617
* | Convert the registration handler to async/await. (#7649)Patrick Cloke2020-06-083-68/+48
| |
* | Accept device information at the login fallback endpoint. (#7629)Patrick Cloke2020-06-082-35/+121
| |
* | Convert user directory handler and related classes to async/await. (#7640)Patrick Cloke2020-06-056-111/+78
| |
* | Add an option to disable autojoin for guest accounts (#6637)Travis Ralston2020-06-055-1/+33
| | | | | | | | Fixes https://github.com/matrix-org/synapse/issues/3177
* | Clarifications to the admin api documentation (#7647)Richard van der Hoff2020-06-058-89/+126
| | | | | | | | | | | | * Clarify how to authenticate * path params are not the same thing as query params * Fix documentation for `/_synapse/admin/v2/users/<user_id>`
* | Update to the stable SSO prefix for UI Auth. (#7630)Patrick Cloke2020-06-052-1/+2
| |
* | Fix type information on `assert_*_is_admin` methods (#7645)Richard van der Hoff2020-06-053-23/+19
| | | | | | These things don't return Deferreds.
* | Remove some unused constants. (#7644)Richard van der Hoff2020-06-052-4/+1
| |
* | Typo fixes.Patrick Cloke2020-06-052-2/+2
| |
* | Allow new users to be registered via the admin API even if the monthly ↵Dirk Klimpel2020-06-054-16/+172
| | | | | | | | active user limit has been reached (#7263)
* | Add device management to admin API (#7481)Dirk Klimpel2020-06-055-0/+920
| | | | | | | | | | | | | | | | | | | | - Admin is able to - change displaynames - delete devices - list devices - get device informations Fixes #7330
* | Attempt to fix PhoneHomeStatsTestCase.test_performance_100 being flaky. (#7634)Patrick Cloke2020-06-052-19/+24
| |
* | Support CS API v0.6.0 (#6585)Andrew Morgan2020-06-052-15/+2
| |
* | Add support for webp thumbnailing (#7586)WGH2020-06-053-36/+101
| | | | | | | | | | Closes #4382 Signed-off-by: Maxim Plotnikov <wgh@torlan.ru>
* | Performance improvements and refactor of Ratelimiter (#7595)Andrew Morgan2020-06-0519-230/+322
| | | | | | | | | | | | | | | | | | | | While working on https://github.com/matrix-org/synapse/issues/5665 I found myself digging into the `Ratelimiter` class and seeing that it was both: * Rather undocumented, and * causing a *lot* of config checks This PR attempts to refactor and comment the `Ratelimiter` class, as well as encourage config file accesses to only be done at instantiation. Best to be reviewed commit-by-commit.
* | Fix encryption algorithm typos in tests/comments (#7637)Andrew Morgan2020-06-044-10/+11
| | | | | | | | | | | | | | | | @uhoreg has confirmed these were both typos. They are only in comments and tests though, rather than anything critical. Introduced in: * https://github.com/matrix-org/synapse/pull/7157 * https://github.com/matrix-org/synapse/pull/5726
* | Advertise the token login type when OpenID Connect is enabled. (#7631)Patrick Cloke2020-06-042-8/+4
| |
* | Cleanups to the OpenID Connect integration (#7628)Richard van der Hoff2020-06-038-324/+428
| | | | | | | | docs, default configs, comments. Nothing very significant.
* | async/await get_user_id_by_threepid (#7620)Andrew Morgan2020-06-034-28/+29
| | | | | | | | | | Based on #7619 async's `get_user_id_by_threepid` and its call stack.
* | Check the changelog number in check-newsfragment (#7623)Richard van der Hoff2020-06-032-4/+17
| |
* | Replace instances of reactor pumping with get_success. (#7619)Andrew Morgan2020-06-033-121/+152
| | | | | | | | | | Calls `self.get_success` on all deferred methods instead of abusing `self.pump()`. This has the benefit of working with coroutines, as well as checking that method execution completed successfully. There are also a few small cleanups that I made in the process.
* | Check if the localpart is reserved for guests earlier in the registration ↵Brendan Abolivier2020-06-032-9/+10
| | | | | | | | | | flow (#7625) This is so the user is warned about the username not being valid as soon as possible, rather than only once they've finished UIA.
* | Fix exceptions when fetching events from a down host. (#7622)Erik Johnston2020-06-032-1/+2
| | | | | | We already caught some exceptions, but not all.
* | `synctl restart` should start synapse if it wasn't running (#7624)Richard van der Hoff2020-06-032-1/+2
| |
* | Switch back to upstream dh-virtualenv (#7621)Richard van der Hoff2020-06-032-1/+2
| | | | | | | | | | | | Upstream have merged our changes (https://github.com/spotify/dh-virtualenv/pull/300), so let's switch back to it instead of using our fork.
* | Merge branch 'master' into developRichard van der Hoff2020-06-031-1/+1
|\ \
| * | Fix typo in PR link github/release-v1.14.0 release-v1.14.0Richard van der Hoff2020-06-031-1/+1
| | |
* | | Clean up exception handling in SAML2ResponseResource (#7614)Richard van der Hoff2020-06-037-61/+77
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Expose `return_html_error`, and allow it to take a Jinja2 template instead of a raw string * Clean up exception handling in SAML2ResponseResource * use the existing code in `return_html_error` instead of re-implementing it (giving it a jinja2 template rather than inventing a new form of template) * do the exception-catching in the REST layer rather than in the handler layer, to make sure we catch all exceptions.
* | | update grafana dashboardRichard van der Hoff2020-06-021-88/+525
| | |
* | | Mention #synapse:matrix.org in README troubleshooting (#7603)Andrew Morgan2020-06-012-1/+5
| | | | | | | | | Just in case people head straight to the troubleshooting section and find themselves at a dead end.
* | | Advertise Python 3.8 support in setup.py (#7602)Andrew Morgan2020-06-012-0/+2
| | | | | | | | | Synapse supports Python 3.8. We've been using it in CI for a while now.
* | | Fix a bug in automatic user creation with m.login.jwt. (#7585)Olof Johansson2020-06-013-7/+162
| | |
* | | Process cross-signing keys when resyncing device lists (#7594)Brendan Abolivier2020-06-014-18/+119
| | | | | | | | | It looks like `user_device_resync` was ignoring cross-signing keys from the results received from the remote server. This patch fixes this, by processing these keys using the same process `_handle_signing_key_updates` does (and effectively factor that part out of that function).
* | | Email notifications for new users when creating via the Admin API. (#7267)Dirk Klimpel2020-06-013-0/+92
| | |
* | | Improve performance of _get_state_groups_from_groups_txn (#7567)Dagfinn Ilmari Mannsåker2020-06-012-6/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The query keeps showing up in my slow query log. This changes the plan under the top-level Sort node from ``` WindowAgg (cost=280335.88..292963.15 rows=561212 width=80) (actual time=138.651..160.562 rows=27112 loops=1) -> Sort (cost=280335.88..281738.91 rows=561212 width=84) (actual time=138.597..140.622 rows=27112 loops=1) Sort Key: state_groups_state.type, state_groups_state.state_key, state_groups_state.state_group Sort Method: quicksort Memory: 4581kB -> Nested Loop (cost=2.83..226745.22 rows=561212 width=84) (actual time=21.548..47.657 rows=27112 loops=1) -> HashAggregate (cost=2.27..3.28 rows=101 width=8) (actual time=21.526..21.535 rows=20 loops=1) Group Key: state.state_group -> CTE Scan on state (cost=0.00..2.02 rows=101 width=8) (actual time=21.280..21.493 rows=20 loops=1) -> Index Scan using state_groups_state_type_idx on state_groups_state (cost=0.56..2189.40 rows=5557 width=84) (actual time=0.005..0.991 rows=1356 loops=20) Index Cond: (state_group = state.state_group) ``` to ``` Nested Loop (cost=2.83..226745.22 rows=561212 width=84) (actual time=24.194..52.834 rows=27112 loops=1) -> HashAggregate (cost=2.27..3.28 rows=101 width=8) (actual time=24.130..24.138 rows=20 loops=1) Group Key: state.state_group -> CTE Scan on state (cost=0.00..2.02 rows=101 width=8) (actual time=23.887..24.113 rows=20 loops=1) -> Index Scan using state_groups_state_type_idx on state_groups_state (cost=0.56..2189.40 rows=5557 width=84) (actual time=0.016..1.159 rows=1356 loops=20) Index Cond: (state_group = state.state_group) ``` This cuts the execution time from ~190ms to ~130ms, i.e. a reduction of ~30%. The full plans are visualised at https://explain.depesz.com/s/WpbT and https://explain.depesz.com/s/KlEk Signed-off-by: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>