[ 
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)

Reply via email to