Currently on 2.1.6 I'm seeing behavior like the following:

cqlsh:walker> select * from counter_table where field = 'test';
 field | value
-------+-------
 test  |    30
(1 rows)
cqlsh:walker> select * from counter_table where field = 'test';
 field | value
-------+-------
 test  |    90
(1 rows)
cqlsh:walker> select * from counter_table where field = 'test';
 field | value
-------+-------
 test  |    30
(1 rows)

Using tracing I can see that one node has wrong data. However running
repair on this table does not seem to have done anything, I still see the
wrong value returned from this same node.

Potentially relevant facts:
- Recently upgraded to 2.1.6 from 2.0.14
- This table has ~million rows, low contention, and fairly high increment
rate

Mainly wondering:
- Is this known or expected? I know Cassandra counters have had issues but
thought by now it should be able to keep a consistent counter or at least
repair it...
- Any way to "reset" this counter?
- Any other stuff I can check?

Reply via email to