[
https://issues.apache.org/jira/browse/CASSANDRA-11815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15286447#comment-15286447
]
peng xiao edited comment on CASSANDRA-11815 at 5/17/16 12:03 PM:
-----------------------------------------------------------------
cqlsh> select * from system.schema_keyspaces;
keyspace_name | durable_writes | strategy_class
| strategy_options
-------------------+----------------+---------------------------------------------+----------------------------
cookieresource | 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"}
All the applications will be throwing errror ：the application is using
LOCAL_QUORUM
Not enough replica available for query at consistency ONE (1 required but only
0 alive)
was (Author: wavelet):
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)
