Sync does not handle existing database correctly

Question

Sync does not handle existing database correctly

Opened this issue 5 months ago · 4 comments

penberg commented 5 months ago

Steps to reproduce:

Create a local hello.db
Import the database with https://turso.tech/blog/migrating-and-importing-sqlite-to-turso-just-got-easier
Sync the database

Expected results:

Sync fails to overwrite an existing database with no metadata

Current results:

Sync succeeds.

Answer 1 · 2025-06-07T15:32:04.000Z

Should the expected/current result points be swapped?

Answer 2 · 2025-07-09T21:02:42.000Z

I've noticed that after import, sync does not work at all.

Answer 3 · 2025-07-09T23:24:01.000Z

Yes looks like any sync after importing a database is not working. Repro is the same, writes to either local or remote will fail to push/pull on first sync.

Answer 4 · 2025-09-21T10:29:57.000Z

Yes, This is a massive problem, this will surely cause production data to be coruptted.

I lose some crusial lab data because i thought the sync is not throwing error so i have a backup, turns out it's not.

If the exsing DB state doesn't match the cloud state, at least it should throw somethign, not pass silently. (altest in rust libsql client)
In case of remote replication make sure to delete .* (wal files etc).