not a support question
Anonymous
Unregistered
Hi,
I am newbie to cassandra. I am using MAC machine. I am following Cassandra tutorial, able to create keyspace Twissandra, column family 'Users'. I am not able to Insert into user family. The CQLSH command is saying "Unable to complete request: one or more nodes were unavailable.". I have changed the Cassandra data path thru SED command .Able to see the name 'twissandra' keyspace under "casssandra-data" folder. it has 755 permissions too. .please help me.
Thanks,
Raju.
Try connecting to the keyspace through cassandra-cli program to verify that the keyspace and column family are both visible:
Anonymous
Unregistered
yeah, i have tried thru cli. It is showing the keyspace twissandra. I used the command to insert "SET users['bobby']['state']='tx';". It returned "null". Please let me know whether I used the command properly or not. I used the same schema that is mentioned in the tutorial. Also please let me know why this is not happening in CQLSH.
I had run cli keyspaces demo etc as shown in the tutorial. It worked properly.
The 'null' implies there was an exception swallowed on the operations. When you start the cli, use the option --debug this will give you more information.
Can you also post the output of 'describe keyspace Twissandra' to verify that the secondary index was created correctly?
Anonymous
Unregistered
Hi, Please find the describe twissandra --
[default@twissandra] describe twissandra;
##############
Keyspace: twissandra:
Replication Strategy: org.apache.cassandra.locator.NetworkTopologyStrategy
Durable Writes: true
Options: [DC1:3]
Column Families:
ColumnFamily: users
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
Row cache size / save period in seconds / keys to save : 0.0/0/all
Key cache size / save period in seconds: 200000.0/14400
GC grace seconds: 864000
Compaction min/max thresholds: 4/32
Read repair chance: 0.1
Replicate on write: true
Built indexes: []
Column Metadata:
Column Name: birth_year
Validation Class: org.apache.cassandra.db.marshal.LongType
Column Name: gender
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Column Name: password
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Column Name: session_token
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Column Name: state
Validation Class: org.apache.cassandra.db.marshal.UTF8Type
Compaction Strategy: org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
##############
Thanks,
Raju.
Anonymous
Unregistered
Hi,
I had run in debug mode. Please find the exception.
###############
[default@twissandra] SET users['bobby']['state']='tx';
null
UnavailableException()
at org.apache.cassandra.thrift.Cassandra$insert_result.read(Cassandra.java:15206)
at org.apache.cassandra.thrift.Cassandra$Client.recv_insert(Cassandra.java:858)
at org.apache.cassandra.thrift.Cassandra$Client.insert(Cassandra.java:830)
at org.apache.cassandra.cli.CliClient.executeSet(CliClient.java:892)
at org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:216)
at org.apache.cassandra.cli.CliMain.processStatementInteractive(CliMain.java:222)
at org.apache.cassandra.cli.CliMain.main(CliMain.java:350)
############
Thanks,
Raju
Can you tell me where you found that Keyspace creation script? It looks like you created the keyspace with a replication_factor (3) which is un-achievable on a single node.
Re-create the keyspace similar to the following:
CREATE KEYSPACE twissandra
with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy'
and strategy_options = [{replication_factor:1}];
Anonymous
Unregistered
This is the link I followed : http://www.datastax.com/docs/1.0/dml/using_cql.
Here there is nothing like replcaition factot in the command.
Thanks,
Raju.
tstarbow
Member
It is pretty annoying that the "Getting Started Using the Cassandra CLI" for Cassandra 1.0 (http://www.datastax.com/docs/1.0/dml/using_cql) code doesn't work as written. It looks like it has been fixed on 1.1 docs:
CREATE KEYSPACE twissandra
WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy'
AND strategy_options:replication_factor='1';
thobbs
Administrator
Thanks for the post! I sent a note to the docs team, so that should be fixed shortly.
rob4you
Member
The problem doesn't seem to have been fixed.
Look at this snippet:
> CREATE KEYSPACE a WITH strategy_class = 'org.apache.cassandra.locator.SimpleStrategy' AND strategy_options:replication_factor='1';
> DESCRIBE KEYSPACE a;
CREATE KEYSPACE a WITH strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor='1';
> USE a;
> CREATE TABLE t (id int PRIMARY KEY, col1 text);
> SELECT * FROM t:
Unable to complete request: one or more nodes were unavailable.
> SHOW VERSION;
[cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 3.0.0 | Thrift protocol 19.32.0]
I'm using DSE, latest release.
