[ https://issues.apache.org/jira/browse/CASSANDRA-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15052660#comment-15052660 ]
Tomas Ramanauskas edited comment on CASSANDRA-10841 at 12/11/15 11:46 AM: -------------------------------------------------------------------------- I think these problems are related to changes done in CASSANDRA-6717 card {code} [cqlsh 5.0.1 | Cassandra 3.1 | CQL spec 3.3.1 | Native protocol v4] Use HELP for help. cqlsh> select * from system.schema_keyspaces; InvalidRequest: code=2200 [Invalid query] message="unconfigured table schema_keyspaces" cqlsh> select * from system_schema.keyspaces; keyspace_name | durable_writes | replication --------------------+----------------+------------------------------------------------------------------------------------------- system_auth | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '1'} system_schema | True | {'class': 'org.apache.cassandra.locator.LocalStrategy'} track | True | {'DC1': '2', 'DC2': '2', 'class': 'org.apache.cassandra.locator.NetworkTopologyStrategy'} OpsCenter | True | {'DC1': '2', 'DC2': '2', 'class': 'org.apache.cassandra.locator.NetworkTopologyStrategy'} system_distributed | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '3'} system | True | {'class': 'org.apache.cassandra.locator.LocalStrategy'} system_traces | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '2'} (7 rows) {code} was (Author: tomas0413): I think these problems are related to changes done in https://issues.apache.org/jira/browse/CASSANDRA-6717 card {code} [cqlsh 5.0.1 | Cassandra 3.1 | CQL spec 3.3.1 | Native protocol v4] Use HELP for help. cqlsh> select * from system.schema_keyspaces; InvalidRequest: code=2200 [Invalid query] message="unconfigured table schema_keyspaces" cqlsh> select * from system_schema.keyspaces; keyspace_name | durable_writes | replication --------------------+----------------+------------------------------------------------------------------------------------------- system_auth | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '1'} system_schema | True | {'class': 'org.apache.cassandra.locator.LocalStrategy'} track | True | {'DC1': '2', 'DC2': '2', 'class': 'org.apache.cassandra.locator.NetworkTopologyStrategy'} OpsCenter | True | {'DC1': '2', 'DC2': '2', 'class': 'org.apache.cassandra.locator.NetworkTopologyStrategy'} system_distributed | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '3'} system | True | {'class': 'org.apache.cassandra.locator.LocalStrategy'} system_traces | True | {'class': 'org.apache.cassandra.locator.SimpleStrategy', 'replication_factor': '2'} (7 rows) {code} > Datastax-agent 5.2.2 fails to work with Cassandra 3.1 > ----------------------------------------------------- > > Key: CASSANDRA-10841 > URL: https://issues.apache.org/jira/browse/CASSANDRA-10841 > Project: Cassandra > Issue Type: Bug > Components: Tools > Reporter: Tomas Ramanauskas > > Hello, > I had datastax-agent 5.2.2 working successfully with Cassandra 2.2.1. > I upgraded Cassandra to 3.1 version and notices that there is no data in > OpsCenter. > Here is what I see in the log file: > {code} > root@sl-prod-cass-01:~# tail /var/log/datastax-agent/agent.log > ERROR [clojure-agent-send-off-pool-5] 2015-12-11 12:25:58,020 Can't connect > to Cassandra (All host(s) tried for query failed (tried: /10.9.3.220:9042 > (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table schema_keyspaces))), retrying soon. > ERROR [clojure-agent-send-off-pool-4] 2015-12-11 12:27:02,017 Can't connect > to Cassandra (All host(s) tried for query failed (tried: /10.9.3.220:9042 > (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table schema_keyspaces))), retrying soon. > ERROR [clojure-agent-send-off-pool-5] 2015-12-11 12:27:02,039 Can't connect > to Cassandra (All host(s) tried for query failed (tried: /10.9.3.220:9042 > (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table schema_keyspaces))), retrying soon. > ERROR [clojure-agent-send-off-pool-4] 2015-12-11 12:28:06,036 Can't connect > to Cassandra (All host(s) tried for query failed (tried: /10.9.3.220:9042 > (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table schema_keyspaces))), retrying soon. > ERROR [clojure-agent-send-off-pool-5] 2015-12-11 12:28:06,047 Can't connect > to Cassandra (All host(s) tried for query failed (tried: /10.9.3.220:9042 > (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table schema_keyspaces))), retrying soon. > ERROR [clojure-agent-send-off-pool-4] 2015-12-11 12:29:10,044 Can't connect > to Cassandra (All host(s) tried for query failed (tried: /10.9.3.220:9042 > (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table schema_keyspaces))), retrying soon. > ERROR [clojure-agent-send-off-pool-5] 2015-12-11 12:29:10,055 Can't connect > to Cassandra (All host(s) tried for query failed (tried: /10.9.3.220:9042 > (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table schema_keyspaces))), retrying soon. > ERROR [clojure-agent-send-off-pool-4] 2015-12-11 12:30:14,058 Can't connect > to Cassandra (All host(s) tried for query failed (tried: /10.9.3.220:9042 > (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table schema_keyspaces))), retrying soon. > ERROR [clojure-agent-send-off-pool-5] 2015-12-11 12:30:14,071 Can't connect > to Cassandra (All host(s) tried for query failed (tried: /10.9.3.220:9042 > (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured > table schema_keyspaces))), retrying soon. > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)