Thanks Robert. I guess the issue is resolved now after doing the mentioned step. Can you tell me how to verify the current tombstone counts in order to do a regular check?
Thanks Aravindan Thangavelu -----Robert Coli <[email protected]> wrote: ----- To: "[email protected]" <[email protected]> From: Robert Coli <[email protected]> Date: 08/23/2014 03:30AM Subject: Re: .TombstoneOverwhelmingException On Fri, Aug 22, 2014 at 2:47 PM, Aravindan T <[email protected]> wrote: 1. Only insertion of records are done since the cassandra started. But, when looked into the system.log messages, i see this following error. ... Now, could you please tell how the tombstone got created when there are no deletes executed You stored a bunch of hints via hinted handoff. Then they got tombstoned. 2. How and where to monitor the current tombstone counts ? 3. done compaction, nodetool repair, increased the threshold count but still this tombstone is not getting resolved. How to resolve this issue? Either major compact the hints columnfamily (might not be done by nodetool compact because it's system keyspace) or : 1) nodetool drain 2) stop node 3) delete all sstables in system/hintscolumnfamily 4) start node 5) repair You should also figure out why you're storing so many hints, and stop doing so. =Rob =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
