cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Job Tiel Groenestege (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-11304) Stack overflow when querying 2ndary index
Date Fri, 04 Mar 2016 14:39:40 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-11304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15179955#comment-15179955
] 

Job Tiel Groenestege commented on CASSANDRA-11304:
--------------------------------------------------

Modified some column-names - manually - for readability so I could accidentally have created
duplicate row names; the original names are a bit longer (but I assume that is not the issue
here)

{quote}
CREATE TABLE keyspace.tablename (
    t ascii,
    time timestamp,
    aid ascii,
    adid int,
    ap int,
    adc ascii,
    aiseid ascii,
    aisip boolean,
    bpacn int,
    bppcn int,
    bpusn int,
    bcacn int,
    bcpcn int,
    bcun int,
    bid int,
    btom int,
    cid int,
    c ascii,
    cacacn int,
    cacpcn int,
    cacun int,
    cac2acn int,
    cac2pcn int,
    cacun int,
    cac3acn int,
    cac3pcn int,
    cac3un int,
    cac4acn int,
    cac4pcn int,
    cac4un int,
    cac5acn int,
    cac5pcn int,
    cac5un int,
    crid int,
    dcacn int,
    dcpcn int,
    dcun int,
    dt int,
    dc ascii,
    du ascii,
    est ascii,
    et bigint,
    evt ascii,
    ex ascii,
    fp uuid,
    flid int,
    grid int,
    ioid int,
    ip ascii,
    isp_id int,
    l ascii,
    liid int,
    mtk text,
    mts ascii,
    mmid int,
    mmid int,
    ns int,
    osid int,
    pracn int,
    prpcn int,
    prusn int,
    pmac1acn int,
    pmac1pcn int,
    pmac1un int,
    pmac2acn int,
    pmac2pcn int,
    pmac2un int,
    pmac3acn int,
    pmac3pcn int,
    pmac3un int,
    pmac4acn int,
    pmac4pcn int,
    pmac5un int,
    pmac5acn int,
    pmac5pcn int,
    pmac6un int,    
    pc ascii,
    rt bigint,
    tmcacn int,
    tmcpcn int,
    tmcun int,
    usid int,
    url text,
    vt bigint,
    wpacn int,
    wppcn int,
    wpusn int,
    PRIMARY KEY (uid, time, aid, adid)
) WITH CLUSTERING ORDER BY (time ASC, aid ASC, adid ASC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
    AND comment = ''
    AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
'max_threshold': '32', 'min_threshold': '4'}
    AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND crc_check_chance = 1.0
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND read_repair_chance = 0.0
    AND speculative_retry = '99PERCENTILE';
CREATE INDEX fileindex ON keyspace.tablename (fp);
{quote}

> Stack overflow when querying 2ndary index
> -----------------------------------------
>
>                 Key: CASSANDRA-11304
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11304
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core, CQL
>         Environment: 3 Node cluster / Ubuntu 14.04 / Cassandra 3.0.3
>            Reporter: Job Tiel Groenestege
>            Assignee: Sam Tunnicliffe
>
> When reading data through a secondary index _select * from tableName where secIndexField
= 'foo'_  (from a Java application) I get the following stacktrace on all nodes; after the
query read fails. It happens repeatably when  I rerun the same query:
> {quote}
> WARN  [SharedPool-Worker-8] 2016-03-04 13:26:28,041 AbstractLocalAwareExecutorService.java:169
- Uncaught exception on thread Thread[SharedPool-Worker-8,5,main]: {}
> java.lang.StackOverflowError: null
>         at org.apache.cassandra.db.rows.BTreeRow$Builder.build(BTreeRow.java:653) ~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.rows.UnfilteredSerializer.deserializeRowBody(UnfilteredSerializer.java:436)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.UnfilteredDeserializer$CurrentDeserializer.readNext(UnfilteredDeserializer.java:211)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.columniterator.SSTableIterator$ForwardIndexedReader.computeNext(SSTableIterator.java:266)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.columniterator.SSTableIterator$ForwardReader.hasNextInternal(SSTableIterator.java:153)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.columniterator.AbstractSSTableIterator$Reader.hasNext(AbstractSSTableIterator.java:340)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.columniterator.AbstractSSTableIterator.hasNext(AbstractSSTableIterator.java:219)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.columniterator.SSTableIterator.hasNext(SSTableIterator.java:32)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.utils.MergeIterator$Candidate.advance(MergeIterator.java:369)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.utils.MergeIterator$ManyToOne.advance(MergeIterator.java:189)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.utils.MergeIterator$ManyToOne.computeNext(MergeIterator.java:158)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.utils.AbstractIterator.hasNext(AbstractIterator.java:47)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.rows.UnfilteredRowIterators$UnfilteredRowMergeIterator.computeNext(UnfilteredRowIterators.java:428)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.rows.UnfilteredRowIterators$UnfilteredRowMergeIterator.computeNext(UnfilteredRowIterators.java:288)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.utils.AbstractIterator.hasNext(AbstractIterator.java:47)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.db.transform.BaseRows.hasNext(BaseRows.java:108) ~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.index.internal.composites.CompositesSearcher$1.prepareNext(CompositesSearcher.java:128)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.index.internal.composites.CompositesSearcher$1.prepareNext(CompositesSearcher.java:133)
~[apache-cassandra-3.0.3.jar:3.0.3]
>         at org.apache.cassandra.index.internal.composites.CompositesSearcher$1.prepareNext(CompositesSearcher.java:133)
~[apache-cassandra-3.0.3.jar:3.0.3]
> {quote}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message