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

Issues: matrix-org/synapse

Author
Filter by author
Loading
Label
Filter by label
Loading
Use alt + click/return to exclude labels
or + click/return for logical OR
Projects
Filter by project
Loading
Milestones
Filter by milestone
Loading
Assignee
Filter by who’s assigned
Sort

Issues list

621 - WARNING - persist_presence_changes-99641 - [TXN OPERROR] {update_presence-34728b} could not serialize access due to concurrent update A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Logging Synapse's logs (structured or otherwise). Not metrics. A-Presence O-Occasional Affects or can be seen by some users regularly or most users rarely S-Tolerable Minor significance, cosmetic issues, low or no impact to users.
#16734 opened Dec 7, 2023 by lea-aglz
server_signature_keys has all nullable columns, server_name and key_id are especially dodgy A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#16646 opened Nov 16, 2023 by reivilibre
received_transactions has a few nullable columns, especially transaction_id and origin are dodgy A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#16645 opened Nov 16, 2023 by reivilibre
Fetching event reports can be slow A-Admin-API A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Moderation Tools for moderating HSes: event redaction, media removal, purge admin API, reports from users, ... A-Performance Performance, both client-facing and admin-facing O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#16619 opened Nov 9, 2023 by DMRobertson
rooms table has a bunch of nullable columns A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#16614 opened Nov 9, 2023 by clokep
Synapse gets stuck after seeing psycopg2.errors.ReadOnlySqlTransaction: cannot execute nextval() in a read-only transaction A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#16490 opened Oct 14, 2023 by MTRNord
slow cleanup in device_lists_outbound_pokes A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Performance Performance, both client-facing and admin-facing S-Major Major functionality / product severely impaired, no satisfactory workaround. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#16480 opened Oct 12, 2023 by richvdh
presence_stream has many nullable fields A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Minor Blocks non-critical functionality, workarounds exist. T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#16467 opened Oct 11, 2023 by clokep
medium in threepid_guest_access_tokens should have a NOT NULL constraint A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#16459 opened Oct 9, 2023 by reivilibre
event_id in event_search should have a NOT NULL constraint A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#16458 opened Oct 9, 2023 by reivilibre
users has a bunch of nullable columns A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#16442 opened Oct 6, 2023 by clokep
Occasional UniqueViolation in device_lists_remote_cache_unique_id A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Device-List-Tracking Telling clients about other devices. Often related to E2EE. S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#16243 opened Sep 4, 2023 by DMRobertson
All tables in Postgres should have a REPLICA IDENTITY available so that Postgres logical replication can be used A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Occasional Affects or can be seen by some users regularly or most users rarely S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#16224 opened Sep 2, 2023 by reivilibre
Migration 79/04_mitigate_stream_ordering_update_race fails because there is no unique constraint matching given keys for referenced table "events" A-Background-Updates Filling in database columns, making the database eventually up-to-date A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Major Major functionality / product severely impaired, no satisfactory workaround. X-Needs-Info This issue is blocked awaiting information from the reporter
#16192 opened Aug 27, 2023 by gpetters94
KeyError on recent background updates A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Major Major functionality / product severely impaired, no satisfactory workaround. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. X-Regression Something broke which worked on a previous release
#16054 opened Aug 2, 2023 by Fizzadar
ERROR - Failed to handle edu 'm.receipt': psycopg2.errors.SerializationFailure: could not serialize access due to concurrent update A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Frequent Affects or can be seen by most users regularly or impacts most users' first experience S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#15936 opened Jul 13, 2023 by melroy89
The cache_invalidation_stream_by_instance table is filled even when workers are not in use A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Disk-Space things which fill up the disk S-Minor Blocks non-critical functionality, workarounds exist. S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#15869 opened Jul 3, 2023 by reivilibre
Support database read-replicas A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#15718 opened Jun 5, 2023 by albertschwarzkopf
PostgreSQL database schema incompatible with AWS DMS A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#15583 opened May 12, 2023 by jaywink
Migrate localpart-only columns to full MXIDs A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks. Z-Future-Maintenance Things that can't yet be done, but will need cleaning up in a couple of months/releases
#15396 opened Apr 5, 2023 by squahtx
Have background updates that create indices report their progress A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#15087 opened Feb 16, 2023 by DMRobertson
Support psycopg3 RFC A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Performance Performance, both client-facing and admin-facing O-Occasional Affects or can be seen by some users regularly or most users rarely S-Minor Blocks non-critical functionality, workarounds exist. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#14586 opened Nov 30, 2022 by thinkwelltwd
"db_to_json" storage method is poorly named A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks. Z-Dev-Wishlist Makes developers' lives better, but doesn't have direct user impact
#14489 opened Nov 18, 2022 by anoadragon453
Long running schema deltas are killed by systemd and lead to bootlooping A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db O-Occasional Affects or can be seen by some users regularly or most users rarely S-Major Major functionality / product severely impaired, no satisfactory workaround. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#14401 opened Nov 9, 2022 by squahtx
Slow query performance(?) in list users API due to naive join to profiles table A-Admin-API A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Performance Performance, both client-facing and admin-facing O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Minor Blocks non-critical functionality, workarounds exist. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#14254 opened Oct 21, 2022 by DMRobertson
ProTip! Add no:assignee to see everything that’s not assigned.