[
https://issues.apache.org/jira/browse/CASSANDRA-7101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13983017#comment-13983017
]
Michael Shuler commented on CASSANDRA-7101:
-------------------------------------------
Please show the output of 'nodetool status'.
Please provide the precise commands to reproduce this, console output, system
log files, when you reproduce your error.
(I assume that you meant you got this error on 2.0.6 and not to be fixed in
2.0.6 - current release is 2.0.7)
works for me (with or without durable_write):
{noformat}
mshuler@hana:~$ ccm create -s -n 1:1 -v 2.0.7 test7101
Downloading
http://archive.apache.org/dist/cassandra/2.0.7/apache-cassandra-2.0.7-src.tar.gz
to /tmp/ccm-VV7qvF.tar.gz (10.848MB)
11375316 [100.00%]
Extracting /tmp/ccm-VV7qvF.tar.gz as version 2.0.7 ...
Compiling Cassandra 2.0.7 ...
Current cluster is now: test7101
mshuler@hana:~$ ccm node1 status
Datacenter: dc1
===============
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Owns (effective) Host ID
Token Rack
UN 127.0.0.1 36.01 KB 100.0%
3fb6966c-465d-4337-bc56-78f5bf489e61 -9223372036854775808
r1
Datacenter: dc2
===============
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Owns (effective) Host ID
Token Rack
UN 127.0.0.2 36 KB 100.0%
257c8dca-8c32-4f32-8256-bf316aa0f933 0
r1
mshuler@hana:~$ ccm node1 cqlsh
Connected to test7101 at 127.0.0.1:9160.
[cqlsh 4.1.1 | Cassandra 2.0.7-SNAPSHOT | CQL spec 3.1.1 | Thrift protocol
19.39.0]
Use HELP for help.
cqlsh> CREATE KEYSPACE TestSample WITH replication = {'class':
'NetworkTopologyStrategy', 'dc1': 1, 'dc2': 1};
cqlsh> CREATE TABLE TestSample.users (user_id int PRIMARY KEY, fname text,
lname text);
cqlsh> INSERT INTO TestSample.users (user_id, fname, lname) VALUES (1745,
'john', 'smith');
cqlsh> SELECT * from TestSample.users;
user_id | fname | lname
---------+-------+-------
1745 | john | smith
(1 rows)
cqlsh>
mshuler@hana:~$ ccm clear
mshuler@hana:~$ ccm status
node1: DOWN
node2: DOWN
mshuler@hana:~$ ccm start test7101
mshuler@hana:~$ ccm node1 status
Datacenter: dc1
===============
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Owns (effective) Host ID
Token Rack
UN 127.0.0.1 35.94 KB 100.0%
6db6cda8-a4aa-4e5a-8803-87db3d7f9f82 -9223372036854775808
r1
Datacenter: dc2
===============
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Owns (effective) Host ID
Token Rack
UN 127.0.0.2 35.88 KB 100.0%
cef6466e-dfc2-440f-9617-54a905a54805 0
r1
mshuler@hana:~$ ccm node1 cqlsh
Connected to test7101 at 127.0.0.1:9160.
[cqlsh 4.1.1 | Cassandra 2.0.7-SNAPSHOT | CQL spec 3.1.1 | Thrift protocol
19.39.0]
Use HELP for help.
cqlsh> DESC KEYSPACES
system system_traces
cqlsh> CREATE KEYSPACE TestSample WITH replication = {'class':
'NetworkTopologyStrategy', 'dc1': 1, 'dc2': 1} AND durable_writes = 'false';
cqlsh> CREATE TABLE TestSample.users (user_id int PRIMARY KEY, fname text,
lname text);
cqlsh> INSERT INTO TestSample.users (user_id, fname, lname) VALUES (1745,
'john', 'smith');
cqlsh> SELECT * from TestSample.users;
user_id | fname | lname
---------+-------+-------
1745 | john | smith
(1 rows)
cqlsh>
mshuler@hana:~$ ccm remove test7101
mshuler@hana:~$
{noformat}
> Unable to complete request: one or more nodes were unavailable.
> ---------------------------------------------------------------
>
> Key: CASSANDRA-7101
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7101
> Project: Cassandra
> Issue Type: Bug
> Components: Config
> Reporter: srikanth
> Fix For: 2.0.6
>
>
> I setup multidata center cluster setup in cassandra. i created keysapce using
> network topology and created a table.but i am unable to insert data into
> tables. i am getting following error to insert data into cassandra
> "Unable to complete request: one or more nodes were unavailable.
> "
> Sample Code:
> For Creating Keyspace:
> CREATE KEYSPACE TestSample
> WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1' : 1,
> 'DC2' : 1}
> AND durable_writes = false;
> For Creating Tables:
> CREATE TABLE users (
> user_id int PRIMARY KEY,
> fname text,
> lname text
> );
> Inserting Into Tables:
> INSERT INTO users (user_id, fname, lname)
> VALUES (1745, 'john', 'smith');
--
This message was sent by Atlassian JIRA
(v6.2#6252)
