Re: [sqlite] sqlite3 datbase disk image malformed

Your rsync command might be ignoring any journal files that may be outstanding. John On Fri, Mar 6, 2009 at 10:33 AM, Derrell Lipman wrote: > On Thu, Mar 5, 2009 at 7:39 AM, Peter van Dijk > wrote: > > > On Thu, Mar 05, 2009 at 04:30:50AM -0800,

Re: [sqlite] sqlite3 datbase disk image malformed

On Thu, Mar 05, 2009 at 04:30:50AM -0800, donnied wrote: > > rsync was corrupting the database. I'll have to exclude the database from > rsync backup. I feel a need to point out that it is not, technically, rsync that was corrupting the database. The issue is that rsync does not take

Re: [sqlite] sqlite3 datbase disk image malformed

rsync was corrupting the database. I'll have to exclude the database from rsync backup. D. Richard Hipp wrote: > > > See http://www.sqlite.org/atomiccommit.html and especially section 9.0 > "Things That Can Go Wrong" > > -- View this message in context:

Re: [sqlite] sqlite3 datbase disk image malformed

Hi Dan, On Mar 4, 2009, at 9:21 AM, Dan wrote: > > On Mar 5, 2009, at 12:10 AM, Tito Ciuro wrote: > >> Hello, >> >> On Mar 4, 2009, at 6:06 AM, D. Richard Hipp wrote: >> >>> See http://www.sqlite.org/atomiccommit.html and especially section >>> 9.0 >>> "Things That Can Go Wrong" >> >> Reading

Re: [sqlite] sqlite3 datbase disk image malformed

On Mar 5, 2009, at 12:10 AM, Tito Ciuro wrote: > Hello, > > On Mar 4, 2009, at 6:06 AM, D. Richard Hipp wrote: > >> See http://www.sqlite.org/atomiccommit.html and especially section >> 9.0 >> "Things That Can Go Wrong" > > Reading the above link, I'm curious about a specific case: 4.2 Hot >

Re: [sqlite] sqlite3 datbase disk image malformed

Hello, On Mar 4, 2009, at 6:06 AM, D. Richard Hipp wrote: > See http://www.sqlite.org/atomiccommit.html and especially section 9.0 > "Things That Can Go Wrong" Reading the above link, I'm curious about a specific case: 4.2 Hot Rollback Journals. It states that: [...] The first time that any

Re: [sqlite] sqlite3 datbase disk image malformed

On Mar 4, 2009, at 7:41 AM, donnied wrote: > > I have a very small sql database (132K). I will often get error > messages > that the Disk image is malformed. I've looked over possible causes > cited > elsewhere and didn't see anything pertinent. I'm using an ext3 file > system > with 64

[sqlite] sqlite3 datbase disk image malformed

I have a very small sql database (132K). I will often get error messages that the Disk image is malformed. I've looked over possible causes cited elsewhere and didn't see anything pertinent. I'm using an ext3 file system with 64 bit Debian. The files are created with Python (first one script