element-hq / element-hq/dendrite

SQLite is not working

Open
#3,435 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
965
Forks
101
PR merge metrics
No merged PRs in 30d

Description

*This issue was originally created by [**@paigeadelethompson**](https://github.com/paigeadelethompson) at .*

followed the documentation @ https://matrix-org.github.io/dendrite/installation/manual/database and it don't work

```
monolith-1 | time="2024-09-28T13:21:13.627063518Z" level=panic msg="failed to connect to room server db" error="near \"SEQUENCE\": syntax error"
monolith-1 | panic: (*logrus.Entry) 0xc0002682a0
```

```
database:
connection_string: file:dendrite_component.db
max_open_conns: 5
max_idle_conns: 5
conn_max_lifetime: -1
```

tried `file:///` and it dont work

Contributor guide

Open the contributing guide

Research direction

Start with the manual database documentation and the provided SQLite connection configuration, then reproduce the room-server database startup failure. Trace the migration or initialization step that produces the reported “SEQUENCE” syntax error; done means Dendrite can start with the shown SQLite configuration without that panic.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sqlite
Domain
backend, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.