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

'extrem' is misppelt throughout the schema as 'exterm'. 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-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#1754 opened Jan 3, 2017 by ara4n
My HS has accumulated thousands of unreferenced state groups 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 roadmap S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. z-p2 (Deprecated Label)
#3364 opened Jun 7, 2018 by richvdh
event_push_actions don't seem to be cleaned for some of my rooms A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Push Issues related to push/notifications S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#6060 opened Sep 18, 2019 by ara4n
Drop state_events and rejections 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-Future-Maintenance Things that can't yet be done, but will need cleaning up in a couple of months/releases
#11496 opened Dec 2, 2021 by richvdh
3 of 5 tasks
Postgres indexes differ on matrix.org 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. Z-Cleanup Things we want to get rid of, but aren't actively causing pain Z-Dev-Wishlist Makes developers' lives better, but doesn't have direct user impact
#11893 opened Feb 2, 2022 by clokep
synapse_port_db assumes events is append-only, but it is not A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db S-Tolerable Minor significance, cosmetic issues, low or no impact to users. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#12007 opened Feb 16, 2022 by richvdh
[Feature request] Room state database integrity check A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db 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.
#12489 opened Apr 18, 2022 by ShadowJonathan
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
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
stop using REPEATABLE READ everywhere 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.
#11567 opened Dec 13, 2021 by richvdh
Sometimes we have entries in event_to_state_groups for outliers, and I don't know why A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Other Questions, user support, anything else.
#12201 opened Mar 10, 2022 by richvdh
many duplicate _get_state_groups_from_groups queries leading to OOMs A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db S-Minor Blocks non-critical functionality, workarounds exist. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#10301 opened Jul 2, 2021 by richvdh
Allow using pg_repack on state_groups_state by adding a primary key or UNIQUE constraint 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.
#10308 opened Jul 3, 2021 by PeterCxy
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
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
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
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
Add a multi-postgres complement run to CI A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db S-Minor Blocks non-critical functionality, workarounds exist. T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#13530 opened Aug 15, 2022 by erikjohnston
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
allow_unsafe_locale: true still enforces the check on postgres' encoding 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.
#13709 opened Sep 4, 2022 by erkinalp
Speed up push actions/unread counting 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-Minor Blocks non-critical functionality, workarounds exist. T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements. T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#13846 opened Sep 20, 2022 by Fizzadar
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
[sqlite] Upgrade to 1.68 leads to bootlooping Synapse systemd service 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-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#14100 opened Oct 7, 2022 by axelsimon
ProTip! Type g i on any issue or pull request to go back to the issue listing page.