[DRBD-user] Postgres disk always inconsistent

Cory Coager ccoager at davisvision.com
Mon Jan 10 20:53:48 CET 2011

Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.


I have a two node cluster setup with Pacemaker and DRBD to run Postgres. 
  For whatever reason, drbd is almost always in an inconsistent state 
everyday multiple times a day doing a big sync.  Why is this happening?

Both nodes are Ubuntu 10.04.1 running drbd 8.3.7-1ubuntu2.1.

drbd status:
version: 8.3.7 (api:88/proto:86-91)
GIT-hash: ea9e28dbff98e331a62bcbcc63a6135808fe2917 build by root at node2, 
2010-10-04 11:05:44
m:res       cs          ro                 ds                     p 
mounted        fstype
...         sync'ed:    18.2%              (18424/22492)M
0:postgres  SyncSource  Primary/Secondary  UpToDate/Inconsistent  C 
/mnt/postgres  ext4


config:
common {
   protocol C;
}
resource postgres {
   startup {
     wfc-timeout 0;
     degr-wfc-timeout 120;
   }
   handlers {
     fence-peer "/usr/lib/drbd/crm-fence-peer.sh";
     after-resync-target "/usr/lib/drbd/crm-unfence-peer.sh";
     #split-brain "/usr/local/scripts/splitbrain.sh";
   }
   disk {
     fencing resource-only;
     on-io-error detach;
   }
   net {
     data-integrity-alg sha1;
     after-sb-0pri discard-younger-primary;
     after-sb-1pri discard-secondary;
     after-sb-2pri disconnect;
   }
   syncer {
     rate 125M;
     verify-alg sha1;
   }
   on node1 {
     device    /dev/drbd0;
     disk      /dev/cciss/c0d0p3;
     address   a.b.c.d:7789;
     meta-disk internal;
   }
   on node2 {
     device    /dev/drbd0;
     disk      /dev/cciss/c0d0p3;
     address   a.b.c.e:7789;
     meta-disk internal;
   }
}



------------------------------------------------------------------------
The information contained in this communication is intended
only for the use of the recipient(s) named above. It may
contain information that is privileged or confidential, and
may be protected by State and/or Federal Regulations. If
the reader of this message is not the intended recipient,
you are hereby notified that any dissemination,
distribution, or copying of this communication, or any of
its contents, is strictly prohibited. If you have received
this communication in error, please return it to the sender
immediately and delete the original message and any copy
of it from your computer system. If you have any questions
concerning this message, please contact the sender.
------------------------------------------------------------------------




More information about the drbd-user mailing list