cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "peng xiao (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-11815) com.datastax.driver.core.exceptions.UnavailableException: Not enough replica available for query at consistency ONE (1 required but only 0 alive)
Date Tue, 17 May 2016 11:54:12 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-11815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15286447#comment-15286447
] 

peng xiao commented on CASSANDRA-11815:
---------------------------------------

cqlsh> select * from system.schema_keyspaces;


 keyspace_name     | durable_writes | strategy_class                              | strategy_options
-------------------+----------------+---------------------------------------------+----------------------------
    cookieresource |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
    messagemanager |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
           sfs_dc2 |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
 peoplephonenumber |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
      crawlertasks |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
      bcms_crawler |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
          mailbill |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
         OpsCenter |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
  usercenter_admin |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
            system |           True |  org.apache.cassandra.locator.LocalStrategy |      
                  {}
       carrierdata |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
      usercontacts |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
     system_traces |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
     ecommercedata |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
               sfs |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}
          bankdata |           True | org.apache.cassandra.locator.SimpleStrategy | {"replication_factor":"3"}

change to :

keyspace_name     | durable_writes | strategy_class                                      
| strategy_options
-------------------+----------------+------------------------------------------------------+----------------------------
    cookieresource |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
    messagemanager |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
           sfs_dc2 |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
 peoplephonenumber |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
      crawlertasks |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
      bcms_crawler |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
          mailbill |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
         OpsCenter |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
  usercenter_admin |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
            system |           True |           org.apache.cassandra.locator.LocalStrategy
|                         {}
       carrierdata |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
      usercontacts |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
     system_traces |           True |          org.apache.cassandra.locator.SimpleStrategy
| {"replication_factor":"3"}
     ecommercedata |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
               sfs |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}
          bankdata |           True | org.apache.cassandra.locator.NetworkTopologyStrategy
|      {"DC2":"3","DC1":"3"}

All the applications will be throwing errror Not enough replica available for query at consistency
ONE (1 required but only 0 alive)

> com.datastax.driver.core.exceptions.UnavailableException: Not enough replica available
for query at consistency ONE (1 required but only 0 alive)
> -------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-11815
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11815
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: peng xiao
>            Priority: Critical
>
> Hi,
> We are trying to to add a new Data Center as per the following link.
> http://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_add_dc_to_cluster_t.html
> The problem is that when I run the following command in the original cluster:
> ALTER KEYSPACE carrierdata WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1':3,'DC2':3};
> We will get the following error:
> 2016-05-17 19:38:32.920 ERROR 28583 --- [daed440b-2f19-48a5-8bad-77f7169bc32e-string]
[io-11235-exec-4] c.e.c.s.s.filter.GlobalExceptionHandler  : com.datastax.driver.core.exceptions.UnavailableException:
Not enough replica available for query at consistency ONE (1 required but only 0 alive)
> 	at com.datastax.driver.core.exceptions.UnavailableException.copy(UnavailableException.java:79)
> 	at com.datastax.driver.core.DefaultResultSetFuture.extractCauseFromExecutionException(DefaultResultSetFuture.java:269)
> 	at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:183)
> 	at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:52)
> 	at com.datastax.driver.mapping.MethodMapper.invoke(MethodMapper.java:148)
> 	at com.datastax.driver.mapping.AccessorInvocationHandler.invoke(AccessorInvocationHandler.java:65)
> 	at com.sun.proxy.$Proxy139.getAccounts(Unknown Source)
> 	at com.enniu.cloud.services.data.ecommerce.dao.cassandra.ECommerceDaoCassandraImpl.getECommerceSummaries(ECommerceDaoCassandraImpl.java:310)
> Could you please advise?
> Thanks,
> Peng Xiao



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message