cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alain RODRIGUEZ <arodr...@gmail.com>
Subject Re: Invalid Counter Shard errors?
Date Tue, 18 Sep 2012 14:06:27 GMT
I would like to understand or do my best helping you to understand this
issue.

I got the following (shortened) logs:

(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 3) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 0)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 6, 6) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 6, 2)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 5, 3) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 5, 5)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 45000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 15000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 13, 13) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 13, 7)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 1) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 3)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 10000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 1, -1) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 1, 1)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 6, 2) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 6, 6)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 30000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 0)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 10000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 0)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 4) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 0)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 8, 5) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 8, 8)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 62, 62) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 62, 57)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 36000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 12000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 5, 1) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 5, 5)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 2) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 4)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 5000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 15000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 10000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 45, 504000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 45, 540000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 15000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 45000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 10000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 0)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 2) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 0)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 3)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 4)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 2)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 5, 2) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 5, 5)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 28, 25) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 28, 28)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 57, 7) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 57, 57)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 19, -3) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 19, 19)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 1, -1) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 1, 1)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 3) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 0)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 1) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 3)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 28, 588000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 28, 294000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 16, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 16, 16)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 5000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 15000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, -5000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 20000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 5, 60000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 5, 36000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 2, 10000)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 4)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 3) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 0)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 4)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 4)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 4) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 4, 0)
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 0) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 3, 3)

I don't understand what the three in parentheses values are exactly. I
guess the last number is the count and the middle one is the number of
increments, is that true ? What is the first string (identical in all the
errors) ?

How can the last number (assuming it's the count) be negative knowing that
I only sum positive numbers ?

An other point is that the highest value seems to be *always* the good one
(assuming this time that the middle number is the number of increments).

I'll try to make myself clear:

I count events and accrued incomes or a costs attached to the events.

In the following line I'm sure that I'm summing cost

(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 28, 588000) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 28, 294000)

588000/28 = 21000 && 294000/28 = 10500. These are euros stored multiplying
them by 100000. So I get 0,21 euros int he first case and 0,105 euros in
the second case as unitary price. We never put 3 decimals in our prices and
we do have a lot of products that cost 0.21, which makes me think that the
first value, the highest out of the two, is the correct one.

In the following line I guess that I'm summing events (one by one so)

(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 19, -3) and
(03a227f0-a5c3-11e1-0000-b7f5e49dceff, 19, 19)

So obviously, if all my assumptions are right, the good value is again the
highest. And I don't get how the count could possibly be "-3".

So the highest value would be always the highest one making your fix
efficient (in my cas at least).

I hope this could be useful to Sylvain Lebresne or anyone working on this
bug.

Alain

Mime
View raw message