You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Radim Kolar (Created) (JIRA)" <ji...@apache.org> on 2012/03/26 07:08:35 UTC
[jira] [Created] (CASSANDRA-4083) cqlsh fails to list counter CF
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
[jira] [Resolved] (CASSANDRA-4083) cqlsh fails to list counter CF
Posted by "paul cannon (Resolved) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
paul cannon resolved CASSANDRA-4083.
------------------------------------
Resolution: Duplicate
This turns out to be the same issue addressed by CASSANDRA-4003.
> 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
[jira] [Commented] (CASSANDRA-4083) cqlsh fails to list counter CF
Posted by "paul cannon (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4083?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13238485#comment-13238485 ]
paul cannon commented on CASSANDRA-4083:
----------------------------------------
Item (1) is as intended; all current (at least all official) cassandra interfaces include row keys with only tombstone columns in them when fetching a range of keys. This behavior is apparently useful for some applications. Changing the behavior, or adding some sort of option or CQL syntax to omit those, would be doable but would need a separate dedicated JIRA ticket and some discussion.
I'll put in a fix for item (2).
> 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
[jira] [Assigned] (CASSANDRA-4083) cqlsh fails to list counter CF
Posted by "Jonathan Ellis (Assigned) (JIRA)" <ji...@apache.org>.
[ 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