element-hq / element-hq/dendrite
SQLite is not working
- 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
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