Hannu, Thanks for your response. Yes our gc grace period is at default setting, so you are right, I do not need hints which are a month old. Especially since I have scheduled repairs running on the cluster almost every day and cross DC repair running every week. The network connection is slow but we have never faced any major issues apart from some dropped mutation messages from time to time.
I will consider your advice about turning off hints. Thank you, Meg Mara From: Hannu Kröger [mailto:hkro...@gmail.com] Sent: Tuesday, June 27, 2017 11:37 AM To: Meg Mara <mm...@digitalriver.com>; user@cassandra.apache.org Subject: Re: Hints files are not getting truncated Hi, First of all, I don’t know why they get delivered so slowly. However, if your gc grace seconds is the default 10 days then those hints from May are not needed and could/should be truncated. If the hint delivery is causing problems, then one option is that you could just disable it and rely on periodic repair doing its job and getting the data synchronized. Now my question to you: Do you have repairs running periodically across the cluster and actually succeeding if the connection is flaky? Hannu On 27 June 2017 at 19:17:26, Meg Mara (mm...@digitalriver.com<mailto:mm...@digitalriver.com>) wrote: Hello, I am facing an issue with Hinted Handoff files in Cassandra v3.0.10. A DC1 node is storing large number of hints for DC2 nodes (we are facing connection timeout issues). The problem is that the hint files which are created on DC1 are not getting deleted after the 3 hour window. Hints are now being stored as flat files in the Cassandra home directory and I can see that old hints are being deleted but at a very slow pace. It still contains hints from May. max_hint_window_in_ms: 10800000 max_hints_delivery_threads: 2 Why do you suppose this is happening? Any suggestions or recommendations would be much appreciated. Thanks for your time. Meg Mara
