bugfix: order the state blocks so recreating state snapshots works correctly
* Logging
* Revert "Logging"
This reverts commit
* bugfix: order the state blocks so recreating state snapshots works correctly
MODIFY
roomserver/storage/postgres/state_block_table.go
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

MODIFY
roomserver/storage/sqlite3/state_block_table.go
roomserver/storage/sqlite3/state_block_table.go
@@ -57,7 +57,7 @@ const insertStateDataSQL = `
const bulkSelectStateBlockEntriesSQL = "" +
"SELECT state_block_nid, event_nids" +
- " FROM roomserver_state_block WHERE state_block_nid IN ($1)"
+ " FROM roomserver_state_block WHERE state_block_nid IN ($1) ORDER BY state_block_nid ASC"
type stateBlockStatements struct {
db *sql.DB

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