cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Sterligov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-8203) Unexpected null static column
Date Tue, 28 Oct 2014 19:26:34 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-8203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alexander Sterligov updated CASSANDRA-8203:
-------------------------------------------
    Description: 
I'm using static column.
When I select whole table (with large limit) some of rows contain null static column value,
but it cannot happen accoring to application logic.
When I select same row using keys, static column has non-null value as expected.

Schema:
{quote}
cqlsh:iss> describe table target_state;

CREATE TABLE iss.target_state (
    cell ascii,
    host ascii,
    service ascii,
    active ascii,
    cell_etag timeuuid static,
    etag timeuuid,
    states map<ascii, ascii>,
    PRIMARY KEY (cell, host, service)
) WITH CLUSTERING ORDER BY (host ASC, service ASC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = '\{"keys":"ALL", "rows_per_partition":"NONE"}'
    AND comment = ''
    AND compaction = \{'min_threshold': '4', 'unchecked_tombstone_compaction': 'true', 'tombstone_compaction_interval':
'43200', 'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'max_threshold':
'32'}
    AND compression = \{'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 86400
    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 = '99.0PERCENTILE';
{quote}

Whole table query:
{quote}
cqlsh:iss> select cell, host, service, cell_etag, etag from target_state LIMIT 50000;
{quote}

Contains in the middle of results:
{quote}
60630000000065955650000000063097470000054552016:ya(200,15) |  ams1-0003.search.yandex.net
|   18265 |                                 null | 737a05e0-5532-11e4-bf0b-efa731c31cd0
{quote}

Row query gives non-null cell_etag column:
{quote}
cqlsh:iss> select host, service, cell_etag, etag from target_state where cell = '60630000000065955650000000063097470000054552016:ya(200,15)'
and host = 'ams1-0003.search.yandex.net' and service = '18265';

 host                        | service | cell_etag                            | etag
-----------------------------+---------+--------------------------------------+--------------------------------------
 ams1-0003.search.yandex.net |   18265 | bc635e60-5ec3-11e4-bdfd-9f65487c7454 | 737a05e0-5532-11e4-bf0b-efa731c31cd0

(1 rows)

{quote}

  was:
Schema:
{quote}
cqlsh:iss> describe table target_state;

CREATE TABLE iss.target_state (
    cell ascii,
    host ascii,
    service ascii,
    active ascii,
    cell_etag timeuuid static,
    etag timeuuid,
    states map<ascii, ascii>,
    PRIMARY KEY (cell, host, service)
) WITH CLUSTERING ORDER BY (host ASC, service ASC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = '\{"keys":"ALL", "rows_per_partition":"NONE"}'
    AND comment = ''
    AND compaction = \{'min_threshold': '4', 'unchecked_tombstone_compaction': 'true', 'tombstone_compaction_interval':
'43200', 'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'max_threshold':
'32'}
    AND compression = \{'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 86400
    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 = '99.0PERCENTILE';
{quote}

Range query:
{quote}
cqlsh:iss> select cell, host, service, cell_etag, etag from target_state LIMIT 50000;
{quote}

Contains in the middle of results:
{quote}
60630000000065955650000000063097470000054552016:ya(200,15) |  ams1-0003.search.yandex.net
|   18265 |                                 null | 737a05e0-5532-11e4-bf0b-efa731c31cd0
{quote}

Data is unchanged, and another query gives non-null cell_etag column
{quote}
cqlsh:iss> select host, service, cell_etag, etag from target_state where cell = '60630000000065955650000000063097470000054552016:ya(200,15)'
and host = 'ams1-0003.search.yandex.net' and service = '18265';

 host                        | service | cell_etag                            | etag
-----------------------------+---------+--------------------------------------+--------------------------------------
 ams1-0003.search.yandex.net |   18265 | bc635e60-5ec3-11e4-bdfd-9f65487c7454 | 737a05e0-5532-11e4-bf0b-efa731c31cd0

(1 rows)

{quote}


> Unexpected null static column
> -----------------------------
>
>                 Key: CASSANDRA-8203
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8203
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Alexander Sterligov
>
> I'm using static column.
> When I select whole table (with large limit) some of rows contain null static column
value, but it cannot happen accoring to application logic.
> When I select same row using keys, static column has non-null value as expected.
> Schema:
> {quote}
> cqlsh:iss> describe table target_state;
> CREATE TABLE iss.target_state (
>     cell ascii,
>     host ascii,
>     service ascii,
>     active ascii,
>     cell_etag timeuuid static,
>     etag timeuuid,
>     states map<ascii, ascii>,
>     PRIMARY KEY (cell, host, service)
> ) WITH CLUSTERING ORDER BY (host ASC, service ASC)
>     AND bloom_filter_fp_chance = 0.01
>     AND caching = '\{"keys":"ALL", "rows_per_partition":"NONE"}'
>     AND comment = ''
>     AND compaction = \{'min_threshold': '4', 'unchecked_tombstone_compaction': 'true',
'tombstone_compaction_interval': '43200', 'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy',
'max_threshold': '32'}
>     AND compression = \{'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'}
>     AND dclocal_read_repair_chance = 0.1
>     AND default_time_to_live = 0
>     AND gc_grace_seconds = 86400
>     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 = '99.0PERCENTILE';
> {quote}
> Whole table query:
> {quote}
> cqlsh:iss> select cell, host, service, cell_etag, etag from target_state LIMIT 50000;
> {quote}
> Contains in the middle of results:
> {quote}
> 60630000000065955650000000063097470000054552016:ya(200,15) |  ams1-0003.search.yandex.net
|   18265 |                                 null | 737a05e0-5532-11e4-bf0b-efa731c31cd0
> {quote}
> Row query gives non-null cell_etag column:
> {quote}
> cqlsh:iss> select host, service, cell_etag, etag from target_state where cell = '60630000000065955650000000063097470000054552016:ya(200,15)'
and host = 'ams1-0003.search.yandex.net' and service = '18265';
>  host                        | service | cell_etag                            | etag
> -----------------------------+---------+--------------------------------------+--------------------------------------
>  ams1-0003.search.yandex.net |   18265 | bc635e60-5ec3-11e4-bdfd-9f65487c7454 | 737a05e0-5532-11e4-bf0b-efa731c31cd0
> (1 rows)
> {quote}



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

Mime
View raw message