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

Remove redundant event_edges.room_id and event_edges.is_state 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.
#12892 opened May 26, 2022 by richvdh
2 of 3 tasks
Separate datastore for devices? 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. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#12906 opened May 29, 2022 by Fizzadar
Consider storing events as pickled binary blobs in the DB A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#12959 opened Jun 5, 2022 by DMRobertson
drop unused table event_labels 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-Cleanup Things we want to get rid of, but aren't actively causing pain
#13049 opened Jun 14, 2022 by richvdh
Use PEP 675 LiteralString to refine database function annotations 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. Z-Dev-Wishlist Makes developers' lives better, but doesn't have direct user impact
#13473 opened Aug 8, 2022 by DMRobertson
Regression in federation sender instance calls to get joined profile A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Federation S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. X-Regression Something broke which worked on a previous release
#13444 opened Aug 3, 2022 by Fizzadar
User admin API returns integers instead of booleans on SQLite, or the documentation is incorrect A-Admin-API A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-SQLite Database issues specific to SQLite 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-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#13519 opened Aug 12, 2022 by squahtx
Consider adding (more?) foreign key constraints A-Corruption Things that have led to unexpected state in Synapse or the database 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.
#12817 opened May 20, 2022 by lnicola
state_groups (& state_groups_state & state_group_edges) are not fully purged alongside the rooms 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 roadmap S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#12821 opened May 20, 2022 by ShadowJonathan
Add useful sql queries to Admin API A-Admin-API A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements. Z-Help-Wanted We know exactly how to fix this issue, and would be grateful for any contribution
#12682 opened May 9, 2022 by H-Shay
getting rid of the replication "stream" tables 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-Cleanup Things we want to get rid of, but aren't actively causing pain
#13456 opened Aug 4, 2022 by richvdh
Consider only inserting events we actually want to purge into events_to_purge A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements. Z-Cleanup Things we want to get rid of, but aren't actively causing pain
#13419 opened Jul 29, 2022 by babolivier
Split out mutable event content from event cache into new caches that are keyed by room ID A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Memory-Usage T-Other Questions, user support, anything else. Z-Time-Tracked Element employees should track their time spent on this issue/PR.
#13916 opened Sep 26, 2022 by anoadragon453
register_background_index_update does not create partial indexes on sqlite 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.
#13636 opened Aug 26, 2022 by richvdh
"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
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
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
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
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
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
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
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
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
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
ProTip! Find all open issues with in progress development work with linked:pr.