incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcelo Elias Del Valle <mvall...@gmail.com>
Subject Re: UnavailableException() for keyspace
Date Wed, 20 Feb 2013 14:57:19 GMT
Indeed, it worked!
Thanks a lot!


2013/2/20 Abhijit Chanda <abhijit.chanda0@gmail.com>

> Try to create the keyspace using bellowed schema and do your regular
> actions.
> create keyspace dmp_input
>   with placement_strategy = 'NetworkTopologyStrategy'
>   and strategy_options = {us-east : 3}
>   and durable_writes = true;
>
> I don't think there is no need to specifying rack name while creating the
> keyspace, DC name is enough.
>
>
>
>
> On Wed, Feb 20, 2013 at 6:04 PM, Marcelo Elias Del Valle <
> mvallebr@gmail.com> wrote:
>
>> Hello Abhijit,
>>
>>      Sure, thanks for trying to help. Follows bellow the schema.
>>      Also, I executed describe cluster to make sure there was just one
>> schema version along nodes in cluster. The schema should be in sync,
>> shouldn't it?
>>
>> [default@dmp_input] describe cluster;
>> Cluster Information:
>>    Snitch: org.apache.cassandra.locator.Ec2Snitch
>>    Partitioner: org.apache.cassandra.dht.RandomPartitioner
>>    Schema versions:
>> 6fb1d283-3e7f-3fc5-9b91-69abb743a1c1: [10.76.82.94, 10.242.139.188,
>> 10.84.65.108]
>>
>>
>>
>> [default@unknown] show schema dmp_input;
>> create keyspace dmp_input
>>   with placement_strategy = 'NetworkTopologyStrategy'
>>   and strategy_options = {us-east-1b : 3}
>>   and durable_writes = true;
>>
>> use dmp_input;
>>
>> create column family Cookie
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'UTF8Type'
>>   and key_validation_class = 'UTF8Type'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family CookieCounters
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'CounterColumnType'
>>   and key_validation_class = 'UTF8Type'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family GlobalInput
>>   with column_type = 'Standard'
>>   and comparator =
>> 'CompositeType(org.apache.cassandra.db.marshal.DateType,org.apache.cassandra.db.marshal.UUIDType)'
>>   and default_validation_class = 'UTF8Type'
>>   and key_validation_class = 'LongType'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family Input
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'UTF8Type'
>>   and key_validation_class = 'UUIDType'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and column_metadata = [
>>     {column_name : 'created_ts',
>>     validation_class : DateType},
>>     {column_name : 'cookieId',
>>     validation_class : UTF8Type},
>>     {column_name : 'origin',
>>     validation_class : LongType},
>>     {column_name : 'json',
>>     validation_class : UTF8Type},
>>     {column_name : 'userId',
>>     validation_class : UUIDType}]
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family InputLookup
>>   with column_type = 'Standard'
>>   and comparator = 'UUIDType'
>>   and default_validation_class = 'UTF8Type'
>>   and key_validation_class =
>> 'CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family InputNavigation
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'UTF8Type'
>>   and key_validation_class =
>> 'CompositeType(org.apache.cassandra.db.marshal.UUIDType,org.apache.cassandra.db.marshal.LongType)'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family InputPhase
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'LongType'
>>   and key_validation_class = 'LongType'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and column_metadata = [
>>     {column_name : 'second',
>>     validation_class : LongType},
>>     {column_name : 'minute',
>>     validation_class : LongType},
>>     {column_name : 'hour',
>>     validation_class : LongType},
>>     {column_name : 'hour_avg',
>>     validation_class : DoubleType},
>>     {column_name : 'day_avg',
>>     validation_class : DoubleType},
>>     {column_name : 'day',
>>     validation_class : LongType},
>>     {column_name : 'minute_avg',
>>     validation_class : DoubleType}]
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family ModuleConfig
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'DateType'
>>   and key_validation_class = 'UTF8Type'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family User
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'UTF8Type'
>>   and key_validation_class = 'UUIDType'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and column_metadata = [
>>     {column_name : 'lastUpdate',
>>     validation_class : DateType}]
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family UserChanges
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'DateType'
>>   and key_validation_class = 'LongType'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family UserInput
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'UTF8Type'
>>   and key_validation_class =
>> 'CompositeType(org.apache.cassandra.db.marshal.UUIDType,org.apache.cassandra.db.marshal.LongType)'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>> create column family UserLookup
>>   with column_type = 'Standard'
>>   and comparator = 'UTF8Type'
>>   and default_validation_class = 'UTF8Type'
>>   and key_validation_class =
>> 'CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)'
>>   and read_repair_chance = 0.1
>>   and dclocal_read_repair_chance = 0.0
>>   and gc_grace = 864000
>>   and min_compaction_threshold = 4
>>   and max_compaction_threshold = 32
>>   and replicate_on_write = true
>>   and compaction_strategy =
>> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
>>   and caching = 'KEYS_ONLY'
>>   and column_metadata = [
>>     {column_name : 'userId',
>>     validation_class : UUIDType}]
>>   and compression_options = {'sstable_compression' :
>> 'org.apache.cassandra.io.compress.SnappyCompressor'};
>>
>>
>>
>>
>> [default@unknown] describe dmp_input;
>> Keyspace: dmp_input:
>>   Replication Strategy:
>> org.apache.cassandra.locator.NetworkTopologyStrategy
>>   Durable Writes: true
>>     Options: [us-east-1b:3]
>>   Column Families:
>>     ColumnFamily: Cookie
>>       Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.UTF8Type
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: CookieCounters
>>       Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.CounterColumnType
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: GlobalInput
>>       Key Validation Class: org.apache.cassandra.db.marshal.LongType
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.UTF8Type
>>       Columns sorted by:
>> org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.DateType,org.apache.cassandra.db.marshal.UUIDType)
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: Input
>>       Key Validation Class: org.apache.cassandra.db.marshal.UUIDType
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.UTF8Type
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Column Metadata:
>>         Column Name: created_ts
>>           Validation Class: org.apache.cassandra.db.marshal.DateType
>>         Column Name: cookieId
>>           Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>>         Column Name: origin
>>           Validation Class: org.apache.cassandra.db.marshal.LongType
>>         Column Name: json
>>           Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>>         Column Name: userId
>>           Validation Class: org.apache.cassandra.db.marshal.UUIDType
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: InputLookup
>>       Key Validation Class:
>> org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.UTF8Type
>>       Columns sorted by: org.apache.cassandra.db.marshal.UUIDType
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: InputNavigation
>>       Key Validation Class:
>> org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UUIDType,org.apache.cassandra.db.marshal.LongType)
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.UTF8Type
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: InputPhase
>>       Key Validation Class: org.apache.cassandra.db.marshal.LongType
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.LongType
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Column Metadata:
>>         Column Name: second
>>           Validation Class: org.apache.cassandra.db.marshal.LongType
>>         Column Name: minute
>>           Validation Class: org.apache.cassandra.db.marshal.LongType
>>         Column Name: hour
>>           Validation Class: org.apache.cassandra.db.marshal.LongType
>>         Column Name: hour_avg
>>           Validation Class: org.apache.cassandra.db.marshal.DoubleType
>>         Column Name: day_avg
>>           Validation Class: org.apache.cassandra.db.marshal.DoubleType
>>         Column Name: day
>>           Validation Class: org.apache.cassandra.db.marshal.LongType
>>         Column Name: minute_avg
>>           Validation Class: org.apache.cassandra.db.marshal.DoubleType
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: ModuleConfig
>>       Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.DateType
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: User
>>       Key Validation Class: org.apache.cassandra.db.marshal.UUIDType
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.UTF8Type
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Column Metadata:
>>         Column Name: lastUpdate
>>           Validation Class: org.apache.cassandra.db.marshal.DateType
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: UserChanges
>>       Key Validation Class: org.apache.cassandra.db.marshal.LongType
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.DateType
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: UserInput
>>       Key Validation Class:
>> org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UUIDType,org.apache.cassandra.db.marshal.LongType)
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.UTF8Type
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>     ColumnFamily: UserLookup
>>       Key Validation Class:
>> org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.UTF8Type,org.apache.cassandra.db.marshal.UTF8Type)
>>       Default column value validator:
>> org.apache.cassandra.db.marshal.UTF8Type
>>       Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type
>>       GC grace seconds: 864000
>>       Compaction min/max thresholds: 4/32
>>       Read repair chance: 0.1
>>       DC Local Read repair chance: 0.0
>>       Replicate on write: true
>>       Caching: KEYS_ONLY
>>       Bloom Filter FP chance: default
>>       Built indexes: []
>>       Column Metadata:
>>         Column Name: userId
>>           Validation Class: org.apache.cassandra.db.marshal.UUIDType
>>       Compaction Strategy:
>> org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
>>       Compression Options:
>>         sstable_compression:
>> org.apache.cassandra.io.compress.SnappyCompressor
>>
>> Best regards,
>> Marcelo.
>>
>>
>>
>> 2013/2/20 Abhijit Chanda <abhijit.chanda0@gmail.com>
>>
>>> It looks like some keyspace creation issue. Can you paste the keyspace
>>> creation schema?
>>>
>>>
>>> On Wed, Feb 20, 2013 at 9:09 AM, Marcelo Elias Del Valle <
>>> mvallebr@gmail.com> wrote:
>>>
>>>> Hello,
>>>>
>>>>     I have a cluster with 3 nodes, all of them configured as seeds and
>>>> with correct listen_addess. If I run nodetool ring on any of the nodes, it
>>>> seems ok:
>>>>  *$ nodetool ring*
>>>> *Address         DC          Rack        Status State   Load
>>>>  Effective-Ownership Token                                       *
>>>> *
>>>>                      113427455640312821154458202477256070485     *
>>>> *10.84.65.108    us-east     1b          Up     Normal  69.46 KB
>>>>  0.00%               0                                           *
>>>> *10.76.82.94     us-east     1b          Up     Normal  61.39 KB
>>>>  0.00%               56713727820156410577229101238628035242      *
>>>> *10.242.139.188  us-east     1b          Up     Normal  65.71 KB
>>>>  0.00%               113427455640312821154458202477256070485 *
>>>>
>>>>     However, in any of the nodes, if I connect to cassandra-cli and try
>>>> to list a CF, I get unavailableException:
>>>>
>>>> *[default@unknown] use dmp_input;
>>>> *
>>>> *[default@dmp_input] list user;*
>>>> *Using default limit of 100*
>>>> *Using default column limit of 100*
>>>> *null*
>>>> *UnavailableException()*
>>>> * at
>>>> org.apache.cassandra.thrift.Cassandra$get_range_slices_result.read(Cassandra.java:12441)
>>>> *
>>>> * at
>>>> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)*
>>>> * at
>>>> org.apache.cassandra.thrift.Cassandra$Client.recv_get_range_slices(Cassandra.java:696)
>>>> *
>>>> * at
>>>> org.apache.cassandra.thrift.Cassandra$Client.get_range_slices(Cassandra.java:680)
>>>> *
>>>> * at
>>>> org.apache.cassandra.cli.CliClient.executeList(CliClient.java:1425)*
>>>> * at
>>>> org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:273)
>>>> *
>>>> * at
>>>> org.apache.cassandra.cli.CliMain.processStatementInteractive(CliMain.java:219)
>>>> *
>>>> * at org.apache.cassandra.cli.CliMain.main(CliMain.java:346)*
>>>>
>>>>     Any hint what I could be doing wrong and what to look for?
>>>>
>>>>      I created the keyspace with NetworkTopologyStrategy and I am using
>>>> Ec2Snitch.
>>>>
>>>> Thanks in advance.
>>>>
>>>> Best regards,
>>>> --
>>>> Marcelo Elias Del Valle
>>>> http://mvalle.com - @mvallebr
>>>>
>>>
>>>
>>>
>>> --
>>> Abhijit Chanda
>>> +91-9748888395
>>>
>>
>>
>>
>> --
>> Marcelo Elias Del Valle
>> http://mvalle.com - @mvallebr
>>
>
>
>
> --
> Abhijit Chanda
> +91-9748888395
>



-- 
Marcelo Elias Del Valle
http://mvalle.com - @mvallebr

Mime
View raw message