Hi,
Today I created a cluster of three of your AWS Community AMIs: AMI: DataStax Auto-Clustering AMI 2.2 (ami-f7e8d083).
I set up everything as specified on http://www.datastax.com/docs/1.1/install/install_ami and https://aws.amazon.com/amis/datastax-auto-clustering-ami-2-2 page.
I have followed the numerous instructions on this website and searched the internet with every variation I could think of and I have drawn a blank.
I found http://www.datastax.com/support-forums/topic/nodes-were-unavailable that thread, but it does not seem to answer my question correctly.
I used cqlsh -3 to run these commands.
I created a keyspace and table with the following commands, but when I try to insert data it fails on me with: "Unable to complete request: one or more nodes were unavailable."
CREATE KEYSPACE demodb with strategy_class = 'NetworkTopologyStrategy' and stategy_options:replication_factor=2;
As far as I can tell this is a legitimate command, that specifies two copies of data per DC and it does not throw any warnings.
CREATE TABLE users (
user_name varchar,
password varchar,
gender varchar,
session_token varchar,
state varchar,
birth_year bigint,
PRIMARY KEY (user_name)
);
This also works correctly.
The following command is where is breaks:
INSERT INTO users
(user_name, password)
VALUES ('jsmith', 'ch@ngem3a');
I get the "Unable to complete request: one or more nodes were unavailable." error at this time.
nodetool -h localhost ring shows all the servers as up, OpsCenter has everything running monitoring, but as I have stated I cannot seem to insert into a table.
If someone could shed some light on this I would be most grateful.
(I apologise if this is in the wrong forum and should have been placed in the Cassandra forum)
Thanks,
Matthew
