Re: [sqlite] syncing two sqlite databases and db corruption

2013-11-13 Thread Simon Slavin
On 14 Nov 2013, at 12:56am, Mayank Kumar (mayankum) wrote: > When rsyncing , we sync both the db file and the journal file(we sync the > complete folder). > > > My question , if primary is in the middle of a transaction Wait. You're syncing by copying files, when one or

[sqlite] syncing two sqlite databases and db corruption

2013-11-13 Thread Mayank Kumar (mayankum)
Hi This is a follow up questions related to the db corruption question I asked a few days earlier. Our architecture is such that we have two roles primary and secondary and the secondary syncs(rsyncs) the sqlite db from the primary from time to time. Also the primary sometime sends records to