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 secondary to write(incremental syncs) to its db using sqlite commands.
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 and the secondary syncs both the db and the journal file using rsync, can this corrupt the sqlite db on the secondary side or when the next write happens on the secondary side, the sqlite will detect the presence of the journal (although its copied from the primary) and revert the last transaction before doing any new writes ? -Mayank _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
