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

Synapse makes postgres to eat all ram until OOM A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db S-Major Major functionality / product severely impaired, no satisfactory workaround. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#9182 by olmari was closed Aug 2, 2021
Forward extremity event missing from database, leading to No state group for unknown or outlier event 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 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.
#12507 by esackbauer was closed Jan 30, 2023
Inline SQL queries using boolean parameters A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db
#15525 by hi-anshul was merged Jul 26, 2023 Loading…
4 tasks done
SQLITE3 error "UNIQUE constraint failed: temp_user_filters.user_id" after update to 1.86.0 A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#15809 by brunofontes was closed Jun 27, 2023
Add foreign key constraint to event_forward_extremities. A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db
#15751 by erikjohnston was merged Jul 5, 2023 Loading…
500 errors when leaving or kicking in a room A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Leave Leaving a room S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. X-Needs-Info This issue is blocked awaiting information from the reporter
#16191 by 45triX was closed Sep 5, 2023
Optimize filter_events_for_client for faster /messages - v1 A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Messages-Endpoint /messages client API endpoint (`RoomMessageListRestServlet`) (which also triggers /backfill) T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#14494 by MadLittleMods was closed Nov 22, 2022 Draft
3 of 4 tasks
N + 3: Read from column full_user_id rather than user_id of tables profiles and user_filters A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db
#15649 by H-Shay was merged Jun 3, 2023 Loading…
Remove old rows from the cache_invalidation_stream_by_instance table automatically. (This table is not used when Synapse is configured to use SQLite.) A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db
#15868 by reivilibre was merged Aug 8, 2023 Loading…
Define SQLite compatibility policy A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-SQLite Database issues specific to SQLite T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
#12983 by richvdh was closed Sep 14, 2022
Clean up schema for event_edges 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.
#12893 by richvdh was merged Jun 15, 2022 Loading…
synapse_port_db fails with "invalid input syntax for type bigint" A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Portdb Script for exporting sqlite data into postgres 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. X-Needs-Info This issue is blocked awaiting information from the reporter
#15225 by codiflow was closed Apr 18, 2023
Remove database differentiation in _get_state_groups_from_groups_txn - SQLite supports recursive queries 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.
#14531 by MadLittleMods was closed May 12, 2023 Draft
2 of 4 tasks
synapse.api.errors.StoreError: 404: No row found in background process http_pusher.on_new_receipts since upgrade to v1.70.0 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.
#14300 by jae1911 was closed Aug 8, 2023
User directory search fails if your query has : in it 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.
#14815 by MelBourbon was closed Feb 20, 2023
psycopg2.errors.UniqueViolation: could not create unique index "receipts_graph_unique_index" 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
#14123 by MTRNord was closed Nov 9, 2022
Running the unit tests results in sqlite3.OperationalError: object name reserved for internal use: event_search_content A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Testing Issues related to testing in complement, synapse, etc T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. z-question (Deprecated Label)
#8996 by MadLittleMods was closed Feb 10, 2021
Add basic read/write lock A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db
#15782 by erikjohnston was merged Jul 5, 2023 Loading…
Track unconverted device list outbound pokes using a position instead 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
#14516 by squahtx was merged Nov 22, 2022 Loading…
postgresql deadlock - INSERT INTO user_ips 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-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#14199 by hyossing was closed Nov 29, 2022
Intermittent sqlite3.OperationalError: table background_updates already exists on startup 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. Z-Dev-Wishlist Makes developers' lives better, but doesn't have direct user impact
#14460 by Yoric was closed Jan 24, 2023
Throws notifcation rotation-related error at 30 second interval A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Push Issues related to push/notifications A-Threads Threaded messages T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. X-Needs-Info This issue is blocked awaiting information from the reporter X-Regression Something broke which worked on a previous release
#14219 by paulvt was closed Oct 21, 2022
Some Synapse instances have been hammering their database after v1.66.0 -> v1.68.0 update 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-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 X-Release-Blocker Must be resolved before making a release
#13942 by jaywink was closed Sep 30, 2022
Optimize filter_events_for_client for faster /messages - v2 A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Messages-Endpoint /messages client API endpoint (`RoomMessageListRestServlet`) (which also triggers /backfill) A-Performance Performance, both client-facing and admin-facing T-Enhancement New features, changes in functionality, improvements in performance, or user-facing enhancements.
#14527 by MadLittleMods was merged Nov 22, 2022 Loading…
3 of 4 tasks
duplicate key value violates unique constraint "event_push_summary_unique_index2" DETAIL: Key (user_id, room_id, thread_id)=(@myuser:myserver.com, !XJcwvojEyyhGBJngjo:matrix.org, main) already exists. A-Database DB stuff like queries, migrations, new/remove columns, indexes, unexpected entries in the db A-Threads Threaded messages T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
#15736 by Cknight70 was closed Jun 7, 2023
ProTip! Adding no:label will show everything without a label.