iconara
commented
10 years ago The consistency level shouldn't really matter unless you read immediately after you write, or you have a cluster that has experienced a long partition where hints were dropped. Once the value has been replicated (which takes milliseconds at the most under normal circumstances) any consistency level should give you the value.
There is no way for me to repeat your problem, if there was a general problem with the driver that values were lost the tests would have caught it, and other people would have reported the same problem long ago, so it must be something specific to your setup.
The only things I can think of now is that your CQL string is something else than you expect. Either there is something subtly wrong with the query, or sometimes you get some garbage in the myid variable (a space, a non-printable, the encoding is wrong, something).
Print out the CQL before each request:
query = "SELECT id FROM mytable WHERE id='#{myid}'"
p query
rows = client.execute(query)Maybe even print out the result to rule out something there:
rows = client.execute("SELECT id FROM mytable WHERE id='#{myid}'")
p rows.to_aYou could also maybe try doing it with a prepared statement, just to rule out that it's your query string that gets bad somehow?
statement = client.prepare('SELECT id FROM mytable WHERE id = ?')
rows = statement.execute(myid)
rows.each do |row|
puts "Found #{row['id']}"
end
gsiglet
Good afternoon,
I am receiving inconsistent results, when I execute the following piece of code multiple times using the same input:
Some times the id is found, other times not, although I use consistency "all". Querying from cqlsh I always get consistent results. I also tried with perl driver and I got consistent results. Any idea what might be wrong?
Using cql-rb 1.2.1, Cassandra 2.0.7
Thank you, George