aboutsummaryrefslogtreecommitdiff
path: root/roomserver/storage/postgres
diff options
context:
space:
mode:
authorkegsay <kegan@matrix.org>2021-07-09 10:49:49 +0100
committerGitHub <noreply@github.com>2021-07-09 10:49:49 +0100
commit3e50bac9441ae43387fee510d5838039bc07e0bb (patch)
treedbee30cb95cae88bac4e532fe94fcdef59210330 /roomserver/storage/postgres
parent816e1a402bdc69a681177c1994e07a2a907315b8 (diff)
bugfix: order the state blocks so recreating state snapshots works correctly (#1908)
* Logging * Revert "Logging" This reverts commit 23ce334182d8a70f8e0381786f9dea77a9b91ed8. * bugfix: order the state blocks so recreating state snapshots works correctly
Diffstat (limited to 'roomserver/storage/postgres')
-rw-r--r--roomserver/storage/postgres/state_block_table.go2
1 files changed, 1 insertions, 1 deletions
diff --git a/roomserver/storage/postgres/state_block_table.go b/roomserver/storage/postgres/state_block_table.go
index 4523d18b..7ae987d6 100644
--- a/roomserver/storage/postgres/state_block_table.go
+++ b/roomserver/storage/postgres/state_block_table.go
@@ -64,7 +64,7 @@ const insertStateDataSQL = "" +
const bulkSelectStateBlockEntriesSQL = "" +
"SELECT state_block_nid, event_nids" +
- " FROM roomserver_state_block WHERE state_block_nid = ANY($1)"
+ " FROM roomserver_state_block WHERE state_block_nid = ANY($1) ORDER BY state_block_nid ASC"
type stateBlockStatements struct {
insertStateDataStmt *sql.Stmt