Issues with convene/dendrite on AAMD64 build #5

New issue

Open

opened 2026-03-10 15:20:55 +00:00 by nathan · 5 comments

nathan commented

2026-03-10 15:20:55 +00:00

Owner

performance of matrix dendrite server is slow
see multiple "database is locked" and 30s timeout in dendrite.log
could be issue with sqlite configuration?

- performance of matrix dendrite server is slow - see multiple "database is locked" and 30s timeout in dendrite.log - could be issue with sqlite configuration?

nathan commented

2026-03-10 15:23:27 +00:00

Author

Owner

related tickets: https://github.com/matrix-org/matrix-rust-sdk/issues/5362 https://github.com/NixOS/nixpkgs/issues/243621

~~acute referenced this issue 2026-03-24 12:43:40 +00:00~~

Main Page unreachable after admin changes #8

nathan commented

2026-03-24 15:14:08 +00:00

Author

Owner

postgresql seems to be the answer

nathan commented

2026-03-24 15:35:48 +00:00

Author

Owner

this is for Echo project work/timeline so can happen in early April

nathan commented

2026-07-13 20:29:29 +00:00

Author

Owner

Good news is that the problem only happens with low quality "USB Flash" drives that have slow, blocking read/write times. On faster external SSD drives, it is fine.

Still, we should investigate switching out postgres for sqlite in the Dendrite install

Good news is that the problem only happens with low quality "USB Flash" drives that have slow, blocking read/write times. On faster external SSD drives, it is fine. Still, we should investigate switching out postgres for sqlite in the Dendrite install

acute was assigned by nathan

2026-07-13 20:29:34 +00:00

nathan added the

enhancement

label

2026-07-13 20:29:39 +00:00

nathan added this to the Butter Box project

2026-07-13 20:29:46 +00:00

acute commented

2026-07-27 11:38:52 +00:00

Owner

The default sqlite config in dendrite is to have a 1 single connection due to a bug where enabling more leads to the server becoming unresponsive: github.com/element-hq/dendrite@08cac1ccf0/roomserver/storage/sqlite3/storage.go (L39)

I also see that WAL is disabled there, I wonder if enabling it might still make a difference to a very slow disk? It would reduce the number of disk operations for a write, but adds an extra file lookup for a read, not ideal for a chat app.

I expect postgres to have more more disk i/o and RAM overhead, but it will be beneficial for RPI builds and faster USB drives.

The default sqlite config in dendrite is to have a 1 single connection due to a bug where enabling more leads to the server becoming unresponsive: https://github.com/element-hq/dendrite/blob/08cac1ccf0a45471132ad24a29e3ec15643675fa/roomserver/storage/sqlite3/storage.go#L39 I also see that WAL is disabled there, I wonder if enabling it might still make a difference to a very slow disk? It would reduce the number of disk operations for a write, but adds an extra file lookup for a read, not ideal for a chat app. I expect postgres to have more more disk i/o and RAM overhead, but it will be beneficial for RPI builds and faster USB drives.