[Csync2] asymetric database sizes
lars.ellenberg at linbit.com
Thu Mar 13 03:03:10 CET 2008
On Wed, Mar 12, 2008 at 05:31:35PM +0100, Vincent Régnard wrote:
> Hi all,
> I am a bit surprised with csync databases (/var/lib/csync2/*db) sizes which
> are very different on two hosts that are actually in sync !
> Tables on both sides have the same record numbers (lines), but database
> files are very different in size:
> host 1 (master):
> # ls -lh /var/lib/csync2/ total 442M
> -rw-r----- 1 root root 412M Mar 12 15:06 or4.pitux.com.db
> -rw-r----- 1 root root 9.9M Mar 12 15:19
> -rw-r----- 1 root root 20M Mar 12 16:08
> host 2 (slave):
> total 541M
> -rw-r----- 1 root root 533M Mar 12 15:06 op1.pitux.com.db
> -rw-r--r-- 1 root root 3.3M Mar 12 15:19
> -rw-r----- 1 root root 4.9M Mar 12 16:08
> Same configurations, same hardware, same operating system !
> Something strange ? Shouldn't these databases have the same size on both
> sides ?
maybe you have large subtrees no longer in the configuration?
# csync2 -R
maybe you have large unsynced subtrees, and you managed to
let csync2 think they are in sync?
# csync2 -TIUX?
or maybe you just need some sqlite maintenance?
# for d in /var/lib/csync2/*.db ; do
# ls -l $d ; sqlite $d vaccum ; ls -l $d
otherwise, remove and reinitialize, and see what happens.
: Lars Ellenberg Tel +43-1-8178292-55 :
: LINBIT Information Technologies GmbH Fax +43-1-8178292-82 :
: Vivenotgasse 48, A-1120 Vienna/Europe http://www.linbit.com :
More information about the Csync2