incubator-cassandra-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <jbel...@gmail.com>
Subject Re: Secondary Index seen as empty
Date Fri, 30 Nov 2012 21:32:41 GMT
Re remote debugging, see cassandra-env.sh:

# uncomment to have Cassandra JVM listen for remote
debuggers/profilers on port 1414
# JVM_OPTS="$JVM_OPTS -Xdebug -Xnoagent
-Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=1414"

On Sat, Dec 1, 2012 at 1:22 AM, Cyril Scetbon <cyril.scetbon@free.fr> wrote:
> Hi,
>
> We got an issue here with cassandra 1.1.6 where a secondary index seems to be seen as
empty. For example, If I try to see what are the first 10 values I have :
>
> cqlsh:pns_fr> select mailendwnd from syndic limit 10;
> mailendwnd
> --------------------------
> 2012-11-29 23:30:00+0000
> 2012-11-29 02:35:00+0000
> 2012-11-29 06:35:00+0000
> 2012-11-29 00:30:00+0000
> 2012-11-29 07:10:00+0000
> 2012-11-29 02:10:00+0000
> 2012-11-29 01:55:00+0000
> 2012-11-29 23:45:00+0000
> 2012-11-29 07:25:00+0000
> 2012-11-29 06:55:00+0000
>
> However, even if there is a secondary index on mailendwnd, we can't get any record :
>
> cqlsh:pns_fr> select mailendwnd from syndic where mailendwnd = '2012-11-29 02:35:00+0000'
limit 1000;
>
> fyi, It's resolved by repairing the index and it happened a few times. I launched cassandra
in debug mode and noticed that it thinks there is no data in the index :
>
> DEBUG [Thrift:14] 2012-11-30 08:35:20,756 CassandraServer.java (line 1232) execute_cql_query
> DEBUG [Thrift:14] 2012-11-30 08:35:20,758 QueryProcessor.java (line 445) CQL statement
type: SELECT
> DEBUG [Thrift:14] 2012-11-30 08:35:20,777 StorageProxy.java (line 842) Command/ConsistencyLevel
is RangeSliceCommand{keyspace='pns_fr', column_family='syndic', super_column=null, predicate=SlicePredicate(column_names:[java.nio.HeapByteBuffer[pos=0
lim=10 cap=10]]), range=[min(-1),m
> in(-1)], row_filter =[IndexExpression(column_name:6D 61 69 6C 65 6E 64 77 6E 64, op:EQ,
value:00 00 01 3B 4A 04 64 20)], maxResults=10000, maxIsColumns=false}/ONE
> DEBUG [Thrift:14] 2012-11-30 08:35:20,778 StorageProxy.java (line 1073) restricted ranges
for query [min(-1),min(-1)] are [[min(-1),max(0)], (max(0),max(21267647932558653966460912964485513216)],
(max(21267647932558653966460912964485513216),max(42535295865117307932921825928971026432
> )], (max(42535295865117307932921825928971026432),max(63802943797675961899382738893456539648)],
(max(63802943797675961899382738893456539648),max(85070591730234615865843651857942052864)],
(max(85070591730234615865843651857942052864),max(106338239662793269832304564822427566080)],
(max
> (106338239662793269832304564822427566080),max(127605887595351923798765477786913079296)],
(max(127605887595351923798765477786913079296),max(148873535527910577765226390751398592512)],
(max(148873535527910577765226390751398592512),min(-1)]]
> DEBUG [Thrift:14] 2012-11-30 08:35:20,779 NetworkTopologyStrategy.java (line 125) /10.244.136.105,/10.244.137.238,/10.244.130.226
endpoints in datacenter us-west-2 for token 0
> DEBUG [Thrift:14] 2012-11-30 08:35:20,780 StorageProxy.java (line 869) local range slice
> DEBUG [Thrift:14] 2012-11-30 08:35:20,782 ExtendedFilter.java (line 181) adding columns
to original Filter to cover additional expressions
> DEBUG [Thrift:14] 2012-11-30 08:35:20,782 KeysSearcher.java (line 99) Primary scan clause
is mailendwnd
> DEBUG [Thrift:14] 2012-11-30 08:35:20,783 ColumnFamilyStore.java (line 1449) Filtering
org.apache.cassandra.db.index.keys.KeysSearcher$1@60ce274e for rows matching org.apache.cassandra.db.filter.ExtendedFilter$FilterWithClauses@7e76a388
> DEBUG [Thrift:14] 2012-11-30 08:35:20,784 KeysSearcher.java (line 135) Scanning index
'syndic.mailendwnd EQ 2012-11-29 02:35:00+0000' starting with
> DEBUG [Thrift:14] 2012-11-30 08:35:20,784 CollationController.java (line 227) collectAllData
> DEBUG [Thrift:14] 2012-11-30 08:35:20,784 KeysSearcher.java(line 145) fetched null
> DEBUG [Thrift:14] 2012-11-30 08:35:20,784 KeysSearcher.java (line 148) no data, all done
<----- THIS IS WHAT IT SAYS HERE
>
> I tried to remotely debug cassandra from eclipse but I wasn't able to do it. Whenever
it tries to connect to the dt_socket it fails and the port is closed on the server :( I tried
locally without any issue but I havent the data (can I copy data from one node to mine and
debug it locally, is it possible ?). I'm investigating network issues concerning that to help
you. If you have input concerning the issue before I can debug it, welcome !
>
> Regards
>
> Cyril SCETBON
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder, http://www.datastax.com
@spyced

Mime
View raw message