Agree with Carlos. It might be the cql shell doing tricks. Please check the json.
On Mon, Nov 23, 2015 at 2:31 PM, Carlos Alonso <[email protected]> wrote: > Well, this makes me wonder how varints are compared in java vs python > because the problem may be there. > > I'd suggest getting the token, to know which server contains the missing > data. Go there and convert sstables to json, find the record and see what's > there as the tnt_id. You could also use the thrift client to list it and > see how it looks on disk and see if there's something wrong. > > If the data is there and looks fine, probably there's a problem managing > varints somewhere in the read path. > > Regarfds > > > Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso> > > On 23 November 2015 at 13:55, Ramon Rockx <[email protected]> wrote: > >> Hello Prem, >> >> On Mon, Nov 23, 2015 at 2:36 PM, Prem Yadav <[email protected]> wrote: >> >>> Can you run the trace again for the query "select * " without any >>> conditions and see if you are getting results for tnt_id=5? >>> <http://www.iqnomy.com/> >> >> >> Of course, here are the results, with trace: >> >> cqlsh> tracing on >> Now tracing requests. >> cqlsh> select * from mls.te limit 330; >> >> period | tnt_id | evt_id | >> evt_type | data >> >> -------------+------------+--------------------------------------+----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ >> ...8<... >> 62013120356 | 5 | c16bb2a0-5c1b-11e3-bf53-402d20524153 | >> 0 | >> {"v":1383387,"s":2052457,"r":95257,"pvs":3610247,"u":" >> http://www.example.com"} >> 62013120356 | 5 | 9f6cb1e0-5c1b-11e3-bf53-402d20524153 | >> 0 | >> {"v":1383387,"s":2052457,"r":95257,"pvs":3610246,"u":" >> http://www.example.com"} >> 62013120356 | 5 | 3f33f950-5c1b-11e3-bf53-402d20524153 | >> 0 | >> {"v":1383387,"s":2052457,"r":95257,"pvs":3610245,"u":" >> http://www.example.com"} >> 62013120356 | 5 | ec15e5d0-5c1a-11e3-bf53-402d20524153 | >> 0 | >> {"v":1383387,"s":2052457,"r":95257,"pvs":3610243,"u":" >> http://www.example.com"} >> 62015032164 | 2063819251 | 63d5c920-cfdb-11e4-85e9-000c2981ebb4 >> | 0 >> | >> {"v":1451223,"s":2130306,"r":104667,"u":"http://www.example.com"} >> 62015032164 | 2063819251 | 111ce010-cfdb-11e4-85e9-000c2981ebb4 >> | 0 >> | >> {"v":1451222,"s":2130305,"r":104769,"u":"http://www.example.com"} >> 62015032164 | 2063819251 | 105e7210-cfdb-11e4-85e9-000c2981ebb4 >> | 0 >> | >> {"v":1451221,"s":2130304,"r":104769,"u":"http://www.example.com"} >> 62015061055 | 2147429759 | 35b97470-0f68-11e5-8cc3-000c2981ebb4 >> | 1 >> | >> {"v":1453821,"s":2134354,"r":105462,"q":"13082ede-0843-47ee-8126-ba3767eae547"} >> 62015061055 | 2147429759 | 35a0bc50-0f68-11e5-8cc3-000c2981ebb4 >> | 0 >> | >> {"v":1453821,"s":2134354,"r":105462,"u":"http://www.example.com"} >> >> >> Tracing session: 5bf98eb0-91e8-11e5-9612-6783eab735d4 >> >> activity >> | timestamp | source | source_elapsed >> >> ------------------------------------------------------------------------------------------------+--------------+---------------+---------------- >> >> execute_cql3_query | 14:44:46,620 | 192.168.0.210 | 0 >> Parsing select * >> from mls.te limit 330; | 14:44:46,621 | 192.168.0.210 | 526 >> >> Preparing statement | 14:44:46,621 | 192.168.0.210 | 990 >> >> Determining replicas to query | 14:44:46,621 | 192.168.0.210 | >> 1174 >> Enqueuing >> request to /192.168.0.212 | 14:44:46,622 | 192.168.0.210 | 1661 >> Sending >> message to /192.168.0.212 | 14:44:46,622 | 192.168.0.210 | 1832 >> Message >> received from /192.168.0.210 | 14:44:46,631 | 192.168.0.212 >> | 25 >> Executing seq scan across 2 sstables for [min(-1), >> max(2517740252400273538161079278238384398)] | 14:44:46,631 | 192.168.0.212 >> | 476 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 33929 >> Read 6 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34013 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34027 >> Read 2 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34039 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34047 >> Read 6 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34065 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34073 >> Read 1 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34083 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34090 >> Read 74 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34249 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34257 >> Read 1 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34267 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34274 >> Read 1 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34284 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34293 >> Read 2 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34304 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34311 >> Read 3 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34324 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34331 >> Read 3 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34345 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34352 >> Read 4 live >> and 0 tombstoned cells | 14:44:46,665 | 192.168.0.212 | 34366 >> Seeking to partition >> beginning in data file | 14:44:46,665 | 192.168.0.212 | 34373 >> Read 32 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36300 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36313 >> Read 11 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36342 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36350 >> Read 3 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36363 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36371 >> Read 2 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36383 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36391 >> Read 17 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36429 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36437 >> Read 42 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36524 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36532 >> Read 8 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36553 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36561 >> Read 1 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36571 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36578 >> Read 1 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36587 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36595 >> Read 2 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36607 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36614 >> Read 83 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36794 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36801 >> Read 20 live >> and 0 tombstoned cells | 14:44:46,667 | 192.168.0.212 | 36844 >> Seeking to partition >> beginning in data file | 14:44:46,667 | 192.168.0.212 | 36853 >> Read 3 live >> and 0 tombstoned cells | 14:44:46,668 | 192.168.0.212 | 36866 >> Seeking to partition >> beginning in data file | 14:44:46,668 | 192.168.0.212 | 36874 >> Read 3 live >> and 0 tombstoned cells | 14:44:46,668 | 192.168.0.212 | 36886 >> Seeking to partition >> beginning in data file | 14:44:46,668 | 192.168.0.212 | 36893 >> Read 1 live >> and 0 tombstoned cells | 14:44:46,668 | 192.168.0.212 | 36902 >> Scanned >> 25 rows and matched 25 | 14:44:46,668 | 192.168.0.212 | 36986 >> Enqueuing >> response to /192.168.0.210 | 14:44:46,668 | 192.168.0.212 | >> 37005 >> Sending >> message to /192.168.0.210 | 14:44:46,668 | 192.168.0.212 | 37122 >> Message >> received from /192.168.0.212 | 14:44:46,672 | 192.168.0.210 | >> 52230 >> Processing >> response from /192.168.0.212 | 14:44:46,678 | 192.168.0.210 | >> 57312 >> >> Request complete | 14:44:46,696 | 192.168.0.210 | 76395 >> >> >> As you can see there are still rows with tnt_id 5 in it. >> >> Regards, >> Ramon >> >> >
