You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jonathan Ellis (Assigned) (JIRA)" <ji...@apache.org> on 2012/03/26 07:24:42 UTC

[jira] [Assigned] (CASSANDRA-4083) cqlsh fails to list counter CF

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

Jonathan Ellis reassigned CASSANDRA-4083:
-----------------------------------------

    Assignee: paul cannon
    
> cqlsh fails to list counter CF
> ------------------------------
>
>                 Key: CASSANDRA-4083
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4083
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 1.0.8
>            Reporter: Radim Kolar
>            Assignee: paul cannon
>
> 1.
>   These rows displayed are tombstones, they should not be displayed at all
> 2. 
>   It fails on first counter
> cqlsh> select * from whois.ipbans;
>  KEY,80.65.56.165
>  KEY,ACA35681.ipt.aol.com
>  KEY,204.229.100.77
>  KEY,31.223.184.51
>  KEY,75.144.148.1
>  KEY,189.27.59.210
>  KEY,111.191.88.7
>  KEY,152.26.21.2
>  KEY,81.43.98.238
>  KEY,64.71.194.172
>  KEY,189.83.117.145
>  KEY,159.0.53.197
>  KEY,190.236.203.195
>  KEY,130.255.163.20
> Traceback (most recent call last):
>   File "/usr/local/bin/cqlsh", line 580, in onecmd
>     self.handle_statement(st)
>   File "/usr/local/bin/cqlsh", line 605, in handle_statement
>     return custom_handler(parsed)
>   File "/usr/local/bin/cqlsh", line 662, in do_select
>     self.perform_statement_as_tokens(parsed.matched, decoder=decoder)
>   File "/usr/local/bin/cqlsh", line 665, in perform_statement_as_tokens
>     return self.perform_statement(cqlhandling.cql_detokenize(tokens), decoder=decoder)
>   File "/usr/local/bin/cqlsh", line 692, in perform_statement
>     self.print_result(self.cursor)
>   File "/usr/local/bin/cqlsh", line 729, in print_result
>     self.print_dynamic_result(cursor)
>   File "/usr/local/bin/cqlsh", line 764, in print_dynamic_result
>     colvals = [self.myformat_value(val, casstype) for (val, casstype) in zip(row, coltypes)]
>   File "/usr/local/bin/cqlsh", line 402, in myformat_value
>     float_precision=self.display_float_precision)
>   File "/usr/local/bin/cqlsh", line 346, in format_value
>     escapedval = val.replace('\\', '\\\\')
> AttributeError: 'int' object has no attribute 'replace'
> [default@whois] list ipbans;
> Using default limit of 100
> -------------------
> RowKey: 80.65.56.165
> -------------------
> RowKey: ACA35681.ipt.aol.com
> -------------------
> RowKey: 204.229.100.77
> -------------------
> RowKey: 31.223.184.51
> -------------------
> RowKey: 75.144.148.1
> -------------------
> RowKey: 189.27.59.210
> -------------------
> RowKey: 111.191.88.7
> -------------------
> RowKey: 152.26.21.2
> -------------------
> RowKey: 81.43.98.238
> -------------------
> RowKey: 64.71.194.172
> -------------------
> RowKey: 189.83.117.145
> -------------------
> RowKey: 159.0.53.197
> -------------------
> RowKey: 190.236.203.195
> -------------------
> RowKey: 130.255.163.20
> -------------------
> RowKey: 80.248.237.157
> => (counter=hits, value=4)
> -------------------
> create column family ipbans
>  with column_type = 'Standard'
>  and comparator = 'AsciiType'
>  and default_validation_class = 'CounterColumnType'
>  and key_validation_class = 'AsciiType'
>  and rows_cached = 500.0
>  and row_cache_save_period = 0
>  and row_cache_keys_to_save = 2147483647
>  and keys_cached = 50000.0
>  and key_cache_save_period = 14400
>  and read_repair_chance = 0.2
>  and gc_grace = 86400
>  and min_compaction_threshold = 2
>  and max_compaction_threshold = 32
>  and replicate_on_write = true
>  and row_cache_provider = 'ConcurrentLinkedHashCacheProvider'
>  and compaction_strategy = 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>  and comment = 'number of queries per IP address'
>  and column_metadata = [
>    {column_name : 'hits',
>    validation_class : CounterColumnType}];

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira