Hi, Check the tombstone count, If is it to high, your query will be impacted.
If tombstone is a problem, you can try to reduce your "gc_grace_seconds" to reduce tombstone count(Carefully because you use cross data centers). Tchau, Petrus Silva On Fri, Feb 24, 2017 at 12:07 AM, Jan Kesten <j.kes...@enercast.de> wrote: > Hi, > > are your nodes at high load? Are there any dropped messages (nodetool > tpstats) on any node? > > Also have a look at your system clocks. C* needs them in thight sync - via > ntp for example. Side hint: if you use ntp use the same set of upstreams on > all of your nodes - ideal your own one. Using pool.ntp.org might lead to > minimal dirfts in time across your cluster. > > Another thing that could help you out is using client side timestamps: > https://docs.datastax.com/en/developer/java-driver/3.1/manua > l/query_timestamps/ (of course only when you are using a single client or > all clients are in sync via ntp). > > > > Am 24.02.2017 um 07:29 schrieb Charulata Sharma (charshar): > >> >> Hi All, >> >> In my application sometimes I cannot read data that just got inserted. >> This happens very intermittently. Both write and read use LOCAL QUOROM. >> >> We have a cluster of 12 nodes which spans across 2 Data Centers and a RF >> of 3. >> >> Has anyone encountered this problem and if yes what steps have you taken >> to solve it >> >> Thanks, >> Charu >> > > -- > Jan Kesten, mailto:j.kes...@enercast.de > Tel.: +49 561/4739664-0 FAX: -9 Mobil: +49 160 / 90 98 41 68 > enercast GmbH Universitätsplatz 12 D-34127 Kassel HRB15471 > http://www.enercast.de Online-Prognosen für erneuerbare Energien > Geschäftsführung: Thomas Landgraf (CEO), Bernd Kratz (CTO), Philipp Rinder > (CSO) > > Diese E-Mail und etwaige Anhänge können vertrauliche und/oder rechtlich > geschützte Informationen enthalten. Falls Sie nicht der angegebene > Empfänger sind oder falls diese E-Mail irrtümlich an Sie adressiert wurde, > benachrichtigen Sie uns bitte sofort durch Antwort-E-Mail und löschen Sie > diese E-Mail nebst etwaigen Anlagen von Ihrem System. Ebenso dürfen Sie > diese E-Mail oder ihre Anlagen nicht kopieren oder an Dritte weitergeben. > Vielen Dank. > > This e-mail and any attachment may contain confidential and/or privileged > information. If you are not the named addressee or if this transmission has > been addressed to you in error, please notify us immediately by reply > e-mail and then delete this e-mail and any attachment from your system. > Please understand that you must not copy this e-mail or any attachment or > disclose the contents to any other person. Thank you for your cooperation. > >