Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 45C6017D9E for ; Thu, 28 May 2015 13:16:52 +0000 (UTC) Received: (qmail 95214 invoked by uid 500); 28 May 2015 13:16:49 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 95164 invoked by uid 500); 28 May 2015 13:16:49 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 95154 invoked by uid 99); 28 May 2015 13:16:49 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 May 2015 13:16:49 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id D7BF4C0F5F for ; Thu, 28 May 2015 13:16:48 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 5.9 X-Spam-Level: ***** X-Spam-Status: No, score=5.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, KAM_TIME=3, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id WHp61V4ykXEA for ; Thu, 28 May 2015 13:16:38 +0000 (UTC) Received: from mail-ie0-f171.google.com (mail-ie0-f171.google.com [209.85.223.171]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id B7F96207C2 for ; Thu, 28 May 2015 13:16:37 +0000 (UTC) Received: by iebgx4 with SMTP id gx4so37775833ieb.0 for ; Thu, 28 May 2015 06:15:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=fOFrjGLIqSvsvXnlGi8zoLz4EmUvw9oimnPQXsWfcRU=; b=KT6uZ+/KztkbY9nDX0QtwT29wo426AN6Z520AUkI3irlZQei8rw1Cs+Y77y6w8TVFE PCpy8CRNQkyCDLhDH0zSneAnjTxJUkyJe+IG0GgN2kGSZ18/uymj3Z0l7RnhcRs05Fz9 ZbltzljvH3EtI0omOvbFyO7/Fttw6529wHv0hmMHMx7K0uHfUMd7sQsxxwrUrRVrD6i6 BTSI8DwqHk/8aFNLNi2zvN78lhFQuh6W8zk/HDrEtI5kmrtZl9u/rBhbKGZ2Nca46BFR KwzYr2SDnMZcg5PLQNy+PVwx/YfCYFkPweTuxUELtIAvtUarCWWQVILkHfggGyup07vQ 83Rw== MIME-Version: 1.0 X-Received: by 10.42.83.212 with SMTP id i20mr9186420icl.91.1432818944804; Thu, 28 May 2015 06:15:44 -0700 (PDT) Received: by 10.79.0.29 with HTTP; Thu, 28 May 2015 06:15:44 -0700 (PDT) Date: Thu, 28 May 2015 18:45:44 +0530 Message-ID: Subject: cassandra.WriteTimeout: code=1100 [Coordinator node timed out waiting for replica nodes' responses] From: Sachin PK To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=485b397dd2313b8a5e051724282a --485b397dd2313b8a5e051724282a Content-Type: text/plain; charset=UTF-8 Hi I'm running Cassandra 2.1.5 ,(single datacenter ,4 node,16GB vps each node ),I have given my configuration below, I'm using python driver on my clients ,when i tried to insert 1049067 items I got an error. cassandra.WriteTimeout: code=1100 [Coordinator node timed out waiting for replica nodes' responses] message="Operation timed out - received only 0 responses." info={'received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} also I'm getting an error when I check the count of CF from cqlsh OperationTimedOut: errors={}, last_host=127.0.0.1 I've installed Datastax Ops center for monitoring nodes , it shows about 1000/sec write request even the cluster is idle . Is there any problem with my cassandra configuration cluster_name: 'Test Cluster' num_tokens: 256 hinted_handoff_enabled: true . max_hint_window_in_ms: 10800000 # 3 hours hinted_handoff_throttle_in_kb: 1024 max_hints_delivery_threads: 2 batchlog_replay_throttle_in_kb: 1024 authenticator: AllowAllAuthenticator authorizer: AllowAllAuthorizer permissions_validity_in_ms: 2000 partitioner: org.apache.cassandra.dht.Murmur3Partitioner data_file_directories: - /var/lib/cassandra/data commitlog_directory: /var/lib/cassandra/commitlog disk_failure_policy: stop commit_failure_policy: stop key_cache_size_in_mb: key_cache_save_period: 14400 row_cache_size_in_mb: 0 row_cache_save_period: 0 counter_cache_size_in_mb: counter_cache_save_period: 7200 saved_caches_directory: /var/lib/cassandra/saved_caches commitlog_sync: periodic commitlog_sync_period_in_ms: 10000 commitlog_segment_size_in_mb: 32 seed_provider: - class_name: org.apache.cassandra.locator.SimpleSeedProvider parameters: - seeds: "10.xx.xx.xx,10.xx.xx.xxx" concurrent_reads: 45 concurrent_writes: 64 concurrent_counter_writes: 32 memtable_allocation_type: heap_buffers memtable_flush_writers: 6 index_summary_capacity_in_mb: index_summary_resize_interval_in_minutes: 60 trickle_fsync: false trickle_fsync_interval_in_kb: 10240 storage_port: 7000 ssl_storage_port: 7001 listen_address: 10.xx.x.xxx start_native_transport: true native_transport_port: 9042 rpc_address: 0.0.0.0 rpc_port: 9160 broadcast_rpc_address: 10.xx.x.xxx rpc_keepalive: true rpc_server_type: sync thrift_framed_transport_size_in_mb: 15 incremental_backups: false snapshot_before_compaction: false auto_snapshot: true tombstone_warn_threshold: 1000 tombstone_failure_threshold: 100000 column_index_size_in_kb: 64 batch_size_warn_threshold_in_kb: 5 compaction_throughput_mb_per_sec: 16 sstable_preemptive_open_interval_in_mb: 50 read_request_timeout_in_ms: 5000 range_request_timeout_in_ms: 10000 write_request_timeout_in_ms: 2000 counter_write_request_timeout_in_ms: 5000 cas_contention_timeout_in_ms: 1000 truncate_request_timeout_in_ms: 60000 request_timeout_in_ms: 10000 cross_node_timeout: false endpoint_snitch: SimpleSnitch dynamic_snitch_update_interval_in_ms: 100 dynamic_snitch_reset_interval_in_ms: 600000 dynamic_snitch_badness_threshold: 0.1 request_scheduler: org.apache.cassandra.scheduler.NoScheduler server_encryption_options: internode_encryption: none keystore: conf/.keystore keystore_password: cassandra truststore: conf/.truststore truststore_password: cassandra # enable or disable client/server encryption. client_encryption_options: enabled: false keystore: conf/.keystore keystore_password: cassandra internode_compression: all inter_dc_tcp_nodelay: false --485b397dd2313b8a5e051724282a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi I'm running Cassandra 2.1.5 ,(single datacente= r ,4 node,16GB vps each node ),I have given my configuration below, I'm= using python driver on my clients ,when i tried to insert =C2=A01049067 it= ems I got an error.
=C2=A0
cassan= dra.WriteTimeout: code=3D1100 [Coordinator node timed out waiting for repli= ca nodes' responses] message=3D"Operation timed out - received onl= y 0 responses." info=3D{'received_responses': 0, 'required= _responses': 1, 'consistency': 'ONE'}

also I'= ;m getting an error when I check the count of CF from cqlsh

Ope= rationTimedOut: errors=3D{}, last_host=3D127.0.0.1

I've installe= d Datastax Ops center for monitoring =C2=A0nodes , it shows about 1000/sec = write request even the cluster is idle .

Is there= any problem with my cassandra configuration=C2=A0


cluster_name: 'Test Cluster'

num_tokens= : 256


hinted_handoff_enabled: true<= /div>
.
max_hint_window_in_ms: 10800000 # 3 hours
<= br>
hinted_handoff_throttle_in_kb: 1024

= max_hints_delivery_threads: 2

batchlog_replay_thro= ttle_in_kb: 1024

authenticator: AllowAllAuthentica= tor

authorizer: AllowAllAuthorizer

<= /div>
permissions_validity_in_ms: 2000

partiti= oner: org.apache.cassandra.dht.Murmur3Partitioner

= data_file_directories:
=C2=A0 =C2=A0 - /var/lib/cassandra/data

commitlog_directory: /var/lib/cassandra/commitlog

disk_failure_policy: stop

c= ommit_failure_policy: stop

key_cache_size_in_mb:

key_cache_save_period: 14400

row_cache_size_in_mb: 0


row_cach= e_save_period: 0

counter_cache_size_in_mb:


counter_cache_save_period: 7200
=

saved_caches_directory: /var/lib/cassandra/sa= ved_caches

commitlog_sync: periodic
comm= itlog_sync_period_in_ms: 10000

commitlog_segment_s= ize_in_mb: 32

seed_provider:

<= div>=C2=A0 =C2=A0 - class_name: org.apache.cassandra.locator.SimpleSeedProv= ider
=C2=A0 =C2=A0 =C2=A0 parameters:

= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 - seeds: "10.xx.xx.xx,10.xx.xx.xxx&= quot;

concurrent_reads: 45
concurrent_wr= ites: 64
concurrent_counter_writes: 32

m= emtable_allocation_type: heap_buffers


memtable_flush_writers: 6

index_summary_capacit= y_in_mb:

index_summary_resize_interval_in_minutes:= 60

trickle_fsync: false
trickle_fsync_i= nterval_in_kb: 10240

storage_port: 7000
=
ssl_storage_port: 7001

listen_addre= ss: 10.xx.x.xxx

start_native_transport: true
=

native_transport_port: 9042

rp= c_address: 0.0.0.0

rpc_port: 9160

broadcast_rpc_address: 10.xx.x.xxx

rpc_ke= epalive: true

rpc_server_type: sync

=
thrift_framed_transport_size_in_mb: 15

= incremental_backups: false

snapshot_before_compact= ion: false

auto_snapshot: true

tombstone_warn_threshold: 1000
tombstone_failure_threshold:= 100000

column_index_size_in_kb: 64

=
batch_size_warn_threshold_in_kb: 5

comp= action_throughput_mb_per_sec: 16

sstable_preemptiv= e_open_interval_in_mb: 50

read_request_timeout_in_= ms: 5000

range_request_timeout_in_ms: 10000
<= div>
write_request_timeout_in_ms: 2000

counter_write_request_timeout_in_ms: 5000

cas_c= ontention_timeout_in_ms: 1000

truncate_request_tim= eout_in_ms: 60000

request_timeout_in_ms: 10000

cross_node_timeout: false

en= dpoint_snitch: SimpleSnitch


dynamic= _snitch_update_interval_in_ms: 100=C2=A0

dynamic_s= nitch_reset_interval_in_ms: 600000

dynamic_snitch_= badness_threshold: 0.1

request_scheduler: org.apac= he.cassandra.scheduler.NoScheduler


= server_encryption_options:
=C2=A0 =C2=A0 internode_encryption: no= ne
=C2=A0 =C2=A0 keystore: conf/.keystore
=C2=A0 =C2=A0= keystore_password: cassandra
=C2=A0 =C2=A0 truststore: conf/.tru= ststore
=C2=A0 =C2=A0 truststore_password: cassandra

# enable or disable client/server encryption.
client_encryption_options:
=C2=A0 =C2=A0 enabled: false<= /div>
=C2=A0 =C2=A0 keystore: conf/.keystore
=C2=A0 =C2=A0 ke= ystore_password: cassandra

internode_compression: = all

inter_dc_tcp_nodelay: false




--485b397dd2313b8a5e051724282a--