frequent Sync(InvalidPushFrameConflict(n, n)) #2122
Description
Currently offline mode is untenable with horizontal scaling. When a user is making updates... and the load balancer switches from server A to server B, turso sync fails.
I'm seeing a lot of Sync(InvalidPushFrameConflict(585, 595)) errors.
If I delete the sqlite (libsql) files from the disk, the remote turso primary restores things to a working order, albeit with partially lost data (not a big deal in my use case). However, if I don't delete the files from disk... the DB is stuck with a bad sync and never recovers on its own.
PS: Please take this constructively. You guys are doing God's work and Turso is amazing. Hope this feedback helps.