benbjohnson / litestream

Streaming replication for SQLite.
https://litestream.io
Apache License 2.0
11.12k stars 256 forks source link

Timestamp issue while restoring #583

Closed arjunpola closed 7 months ago

arjunpola commented 7 months ago

I am using Litestream version 0.3.9 on Windows and have setup a service to continuously backup to AWS S3. Upon trying to restore I was successfully able to restore on Windows but was not able to restore on MAC OSX & Linux.

The issue seemed to be related to WAL start and end times not being recorded correctly across the platforms.

on WINDOWS 10

Screenshot 2024-04-25 at 11 38 21 AM

on MAC OSX

Screenshot 2024-04-25 at 11 35 57 AM

Looking to get help on how the WAL timestamps can be normalised across platforms.

arjunpola commented 7 months ago

This issue does not occur in the newer version.