Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-17 Thread Daniel Alm
> Richard Hipp wrote: > Do you know if the corruption is occurring when TimeMachine makes its > backup, or is occurring when the backed up database is restored? Can > you capture some unrestored TimeMachine backups to see if they are > corrupt? > > Can you send us one of your corrupted databa

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread Scott Perry
On Dec 11, 2018, at 04:01, Daniel Alm wrote: > > Hi, > > For the past half year we’ve been receiving reports from users who had > restored their SQLite-based databases from a Time Machine backup. Afterwards, > they would receive "database disk image is malformed” errors. The app also > backs

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread Simon Slavin
On 12 Dec 2018, at 2:59pm, Olivier Mascia wrote: > When TimeMachine makes copies of the files, the database file and -wal file > will be copied at different points in time, albeit they should be copied from > a filesystem snapshot, so should be consistent to each other. But this should > be ch

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread Rob Willett
sqlite-users [mailto:sqlite-users- boun...@mailinglists.sqlite.org] On Behalf Of Daniel Alm Sent: Tuesday, 11 December, 2018 05:02 To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Mach

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread Peter da Silva
On Behalf Of Daniel Alm > >Sent: Tuesday, 11 December, 2018 05:02 > >To: sqlite-users@mailinglists.sqlite.org > >Subject: [sqlite] Mac: Users receive "database disk image is > >malformed" errors after restoring database from Time Machine backup > > > >Hi,

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread Keith Medcalf
age- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Daniel Alm >Sent: Tuesday, 11 December, 2018 05:02 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Mac: Users receive "database disk image is >malformed" errors after r

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread Rob Willett
Also are they using Time Machine on a networked drive? Whilst Time Machine was not supposed to work across networks, people have made it work using 3rd party software. I know because we tried it for a laugh and abandoned it (and Time Machine) as it was wholly unreliable. However I think the

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread R Smith
On 2018/12/12 4:48 PM, Richard Hipp wrote: On 12/11/18, Daniel Alm wrote: Any suggestions on what could be the culprit or what else I could try besides downgrading all the way to SQLite 3.21 would be appreciated. Nothing about SQLite has changed that should make a difference here. Do you kn

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread Olivier Mascia
Dear Daniel, I'm extracting two points out of your report: > Le 11 déc. 2018 à 13:01, Daniel Alm a écrit : > > While our app is running in the background all the time, it is not very > write-heavy (~ one transaction per minute taking just a few milliseconds). > PRAGMA journal_mode = WAL; When

Re: [sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread Richard Hipp
On 12/11/18, Daniel Alm wrote: > Any suggestions on what could be the culprit or what else I could try > besides downgrading all the way to SQLite 3.21 would be appreciated. > Nothing about SQLite has changed that should make a difference here. Do you know if the corruption is occurring when Tim

[sqlite] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

2018-12-12 Thread Daniel Alm
Hi, For the past half year we’ve been receiving reports from users who had restored their SQLite-based databases from a Time Machine backup. Afterwards, they would receive "database disk image is malformed” errors. The app also backs up the user’s data “manually” to a ZIP file every week; those