Re: Timeout for only one keyspace in cluster

2018-07-23 Thread learner dba
ation level. On Monday, July 23, 2018, 12:01:15 PM CDT, Jonathan Haddad wrote: You don’t get this guarantee with counters.  Do not use them for unique values. Use a UUID instead.  On Mon, Jul 23, 2018 at 9:11 AM learner dba wrote: James, Yes, counter is implemented due to valid reason

Re: Timeout for only one keyspace in cluster

2018-07-23 Thread learner dba
, James On Mon, Jul 23, 2018 at 10:57 AM, learner dba wrote: Thanks a lot Ben. This makes sense but feel bad that we don't have a solution yet. We can try consistency level one but that will be against general rule for having local_quorum for production. Also, consistency ONE will not guar

Re: Timeout for only one keyspace in cluster

2018-07-23 Thread learner dba
11:20 Goutham reddy wrote: Hi,As it is a single partition key, try to update the key with only partition key instead of passing other columns. And try to set consistency level ONE.  Cheers,Goutham. On Fri, Jul 20, 2018 at 6:57 AM learner dba wrote: Anybody has any ideas about this? This is happ

Re: Timeout for only one keyspace in cluster

2018-07-23 Thread learner dba
ONE.  Cheers,Goutham. On Fri, Jul 20, 2018 at 6:57 AM learner dba wrote: Anybody has any ideas about this? This is happening in production and we really need to fix it. On Thursday, July 19, 2018, 10:41:59 AM CDT, learner dba wrote: Our foreignid is unique idetifier and we did check

Re: Timeout for only one keyspace in cluster

2018-07-20 Thread learner dba
Anybody has any ideas about this? This is happening in production and we really need to fix it. On Thursday, July 19, 2018, 10:41:59 AM CDT, learner dba wrote: Our foreignid is unique idetifier and we did check for wide partitions; cfhistorgrams show all partitions are evenly sized

Re: Timeout for only one keyspace in cluster

2018-07-19 Thread learner dba
Our foreignid is unique idetifier and we did check for wide partitions; cfhistorgrams show all partitions are evenly sized: Percentile  SSTables     Write Latency      Read Latency    Partition Size        Cell Count                               (micros)          (micros)           (bytes)  

Timeout for only one keyspace in cluster

2018-07-18 Thread learner dba
Hi, We have a cluster with multiple keyspaces. All queries are performing good but write operation on few tables in one specific keyspace gets write timeout. Table has counter column and counter update query times out always. Any idea? CREATE TABLE x.y (     foreignid uuid,     timebucket text

Re: RE: RE: [EXTERNAL] Cluster is unbalanced

2018-06-20 Thread learner dba
s://issues.apache.org/jira/browse/CASSANDRA-10430 On Wed, Jun 20, 2018 at 9:59 AM, learner dba wrote: Partition key has value as:  MWY4MmI0MTQtYTk2YS00YmRjLTkxND MtOWU0MjM1OWU2NzUy other column is blob. On Tuesday, June 19, 2018, 6:07:59 PM EDT, Joshua Galbraith wrote: > id text

Re: RE: RE: [EXTERNAL] Cluster is unbalanced

2018-06-20 Thread learner dba
ral use case? On Tue, Jun 19, 2018 at 1:18 PM, learner dba wrote: Hi Sean, Here is create table: CREATE TABLE ks.cf (     id text PRIMARY KEY,     accessdata blob ) WITH bloom_filter_fp_chance = 0.01     AND caching = {'keys': 'ALL', 'rows_per_partition': '

Re: Cluster is unbalanced

2018-06-20 Thread learner dba
': '3', 'maikaiprodv2': '3'}                data |           True | {'class': 'org.apache.cassandra.locator.NetworkTopologyStrategy', 'iwakaluaint': '3', 'maikaiprodv2': '3'} Keyspaces with replica 1, a

Re: RE: RE: [EXTERNAL] Cluster is unbalanced

2018-06-19 Thread learner dba
important decisions for a Cassandra table.   Also, I have seen the use of racks in the topology cause an imbalance in the “first” node of the rack.   To help you more, we would need the create table statement(s) for your keyspace and the topology of the cluster (like with nodetool stat

Re: Timestamp on hints file and system.hints table data

2018-06-19 Thread learner dba
to repair, assuming you haven't repaired already since that hint file was created. On 18 June 2018 at 13:56, learner dba wrote: Yes Kurt, system log is flooded with hints sent and replayed messages.  On Monday, June 18, 2018, 7:30:34 AM EDT, kurt greaves wrote: Not sure what to ma

Re: RE: [EXTERNAL] Cluster is unbalanced

2018-06-19 Thread learner dba
tokens? On Mon, Jun 18, 2018 at 6:07 PM, learner dba wrote: Hi Sean, Are you using any rack aware topology? --> we are using gossip file Are you using any rack aware topology? --> we are using gossip file What are your partition keys? --> Partition key is uniqIs it possible that your

Re: RE: [EXTERNAL] Cluster is unbalanced

2018-06-18 Thread learner dba
rtition key)?     Sean Durity lord of the (C*) rings (Staff Systems Engineer – Cassandra) MTC 2250 #cassandra - for the latest news and updates   From: learner dba Sent: Monday, June 18, 2018 2:06 PM To: User cassandra.apache.org Subject: [EXTERNAL] Cluster is unbalanced   Hi,  

Cluster is unbalanced

2018-06-18 Thread learner dba
Hi, Data volume varies a lot in our two DC cluster:  Load       Tokens       Owns    20.01 GiB  256          ?       65.32 GiB  256          ?       60.09 GiB  256          ?       46.95 GiB  256          ?       50.73 GiB  256          ?      kaiprodv2 = /Leaving/Joining/Moving  

Re: Timestamp on hints file and system.hints table data

2018-06-18 Thread learner dba
Yes Kurt, system log is flooded with hints sent and replayed messages.  On Monday, June 18, 2018, 7:30:34 AM EDT, kurt greaves wrote: Not sure what to make of that. Are there any log messages regarding the file and replaying hints? Sounds like maybe it's corrupt (although not sure why

How to identify which table causing Maximum Memory usage limit

2018-06-05 Thread learner dba
Hi, We see this message often, cluster has multiple keyspaces and column families;  How do I know which CF is causing this? Or it could be something else?Do we need to worry about this message? INFO  [CounterMutationStage-1] 2018-06-05 13:36:35,983 NoSpamLogger.java:91 - Maximum memory usage rea