libsql / sqld

LibSQL with extended capabilities like HTTP protocol, replication, and more.
https://libsql.org
902 stars 38 forks source link

"Error: failed to checkpoint database while recovering replication log" when reading sqlite3 db #558

Open CodingDoug opened 1 year ago

CodingDoug commented 1 year ago

If you use to sqld to create a database file, you can query it with sqlite3 no problem. If you use sqlite3 to create the file, sqld hangs with that message at startup.

haaawk commented 1 year ago

Please specify @CodingDoug what "reading sqlite3 db" means exactly

CodingDoug commented 1 year ago

To be more specific:

# Create db file
$ sqlite3 test.db

# Try to get sqld to use the file directly
$ turso dev --db-file test.db
...
Error: failed to checkpoint database while recovering replication log