[Csync2] csync2 db asymetry

[Lars Ellenberg]

On Fri, Dec 19, 2008 at 10:28:26AM +0100, Vincent Régnard wrote:
> Hi all,
> 
> I already posted that topic earlier, but problem persists after
> maintenance and clean up.
> 
> Because I noticed inconsitencies between databases and observed an
> asymmetry in databases size I don't really appreciate, I recently
> regenerated my csync2 dbs from scratch (with TIUX etc..). But, with
> freshly rebuild dbs and a synchronized file system, I still have the
> database size asymmetry observed earlier. csync2 databases are all
> approximately 10-15% larger on master side.
> 
> #-C           or4        op1        ratio
> maildir       237128704  216787968  1,09
> sys           3743744    3363840    1,11
> obmdocuments  5020672    4268032    1,18
> dotqmail      7578624    6509568    1,16
> 
> What could be the reason of such a relatively systematic difference ?

compare the dumpfiles,
maybe you find something.

> The host name only differ that way: master is or4, slave is op1, so
> string hostname difference should not be the reason. Files and file
> attributes are obviously the same.

inode numbers are not, probably.
just a thought...

> System and file system where dbs are stored are the same
> 
> If the difference has to do with compression or history, why is it
> always bigger on the same side (master) and not randomly bigger one side
> and also the other ?

this is most likely a sqlite question.

-- 
: Lars Ellenberg
: LINBIT | Your Way to High Availability
: DRBD/HA support and consulting http://www.linbit.com

DRBD® and LINBIT® are registered trademarks of LINBIT, Austria.