This repository has been archived by the owner on Apr 26, 2024. It is now read-only.
-
-
Notifications
You must be signed in to change notification settings - Fork 2.1k
Issues: matrix-org/synapse
Author
Label
Projects
Milestones
Assignee
Sort
Issues list
Remove redundant 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.
event_edges.room_id
and event_edges.is_state
columns
A-Database
#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 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
event_labels
A-Database
#13049
opened Jun 14, 2022 by
richvdh
Use PEP 675 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
LiteralString
to refine database function annotations
A-Database
#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
#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 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
events_to_purge
A-Database
#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
#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
#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 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.
device_lists_outbound_pokes
A-Database
#16480
opened Oct 12, 2023 by
richvdh
Synapse gets stuck after seeing 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.
psycopg2.errors.ReadOnlySqlTransaction: cannot execute nextval() in a read-only transaction
A-Database
#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 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
79/04_mitigate_stream_ordering_update_race
fails because there is no unique constraint matching given keys for referenced table "events"
A-Background-Updates
#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.