Re: [sqlite] sqlite3 datbase disk image malformed

2009-03-07 Thread John LeSueur
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

2009-03-06 Thread Peter van Dijk
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

2009-03-05 Thread donnied
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

2009-03-04 Thread Tito Ciuro
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

2009-03-04 Thread Dan
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

2009-03-04 Thread Tito Ciuro
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

2009-03-04 Thread D. Richard Hipp
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