[Csync2] asymetric database sizes

[Lars Ellenberg]

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 
> or4.pitux.com_dotqmail.db
> -rw-r-----    1 root     root          20M Mar 12 16:08 
> or4.pitux.com_sys.db
>
> 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 
> op1.pitux.com_dotqmail.db
> -rw-r-----    1 root     root         4.9M Mar 12 16:08 
> op1.pitux.com_sys.db
>
> 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
# done

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 :