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
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
