Execute CQL3 query | 2017-12-15 09:30:45.114000 | 127.0.0.1 | 0
Parsing update count_by_id SET count = count + 1 WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:30:45.114000 | 127.0.0.1 | 320
Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:30:45.120000 | 127.0.0.1 | 5772
Executing single-partition query on local [SharedPool-Worker-1] | 2017-12-15 09:30:45.172000 | 127.0.0.1 | 57252
Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:30:45.172000 | 127.0.0.1 | 57735
Key cache hit for sstable 689 [SharedPool-Worker-1] | 2017-12-15 09:30:45.173000 | 127.0.0.1 | 58783
Skipped 0/1 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:30:45.174000 | 127.0.0.1 | 60057
Merging data from memtables and 1 sstables [SharedPool-Worker-1] | 2017-12-15 09:30:45.175000 | 127.0.0.1 | 60454
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2017-12-15 09:30:45.178000 | 127.0.0.1 | 63600
Determining replicas for mutation [SharedPool-Worker-1] | 2017-12-15 09:30:45.185000 | 127.0.0.1 | 70529
Enqueuing counter update to /127.0.0.3 [SharedPool-Worker-1] | 2017-12-15 09:30:45.186000 | 127.0.0.1 | 71370
Sending COUNTER_MUTATION message to /127.0.0.3 [MessagingService-Outgoing-/127.0.0.3] | 2017-12-15 09:30:45.187000 | 127.0.0.1 | 73167
COUNTER_MUTATION message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:30:45.207000 | 127.0.0.3 | 637
Acquiring counter locks [SharedPool-Worker-1] | 2017-12-15 09:30:45.214000 | 127.0.0.3 | 7029
Fetching 1 counter values from cache [SharedPool-Worker-1] | 2017-12-15 09:30:45.220000 | 127.0.0.3 | 13168
Reading 1 counter values from the CF [SharedPool-Worker-1] | 2017-12-15 09:30:45.221000 | 127.0.0.3 | 14775
Executing single-partition query on count_by_id [SharedPool-Worker-1] | 2017-12-15 09:30:45.222000 | 127.0.0.3 | 15126
Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:30:45.222000 | 127.0.0.3 | 15228
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:30:45.222000 | 127.0.0.3 | 15369
Executing single-partition query on local [SharedPool-Worker-1] | 2017-12-15 09:30:45.244000 | 127.0.0.3 | 22623
Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:30:45.245000 | 127.0.0.3 | 38552
Key cache hit for sstable 30 [SharedPool-Worker-1] | 2017-12-15 09:30:45.246000 | 127.0.0.3 | 39473
Skipped 0/1 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:30:45.247000 | 127.0.0.3 | 40776
Merging data from memtables and 1 sstables [SharedPool-Worker-1] | 2017-12-15 09:30:45.248000 | 127.0.0.3 | 41457
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2017-12-15 09:30:45.249000 | 127.0.0.3 | 42225
Appending to commitlog [SharedPool-Worker-1] | 2017-12-15 09:30:45.250000 | 127.0.0.3 | 43716
Adding to count_by_id memtable [SharedPool-Worker-1] | 2017-12-15 09:30:45.253000 | 127.0.0.3 | 46891
Sending REQUEST_RESPONSE message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:30:45.265000 | 127.0.0.3 | 58624
REQUEST_RESPONSE message received from /127.0.0.3 [MessagingService-Incoming-/127.0.0.3] | 2017-12-15 09:30:45.266000 | 127.0.0.1 | 151406
Processing response from /127.0.0.3 [SharedPool-Worker-3] | 2017-12-15 09:30:45.266000 | 127.0.0.1 | 151855
Sending MUTATION message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:30:45.267000 | 127.0.0.3 | --
MUTATION message received from /127.0.0.3 [MessagingService-Incoming-/127.0.0.3] | 2017-12-15 09:30:45.268000 | 127.0.0.1 | 153962
Appending to commitlog [SharedPool-Worker-3] | 2017-12-15 09:30:45.268000 | 127.0.0.1 | 154226
Sending MUTATION message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:30:45.269000 | 127.0.0.3 | --
Adding to count_by_id memtable [SharedPool-Worker-3] | 2017-12-15 09:30:45.270000 | 127.0.0.1 | 155864
Enqueuing response to /127.0.0.3 [SharedPool-Worker-3] | 2017-12-15 09:30:45.272000 | 127.0.0.1 | 158073
Sending REQUEST_RESPONSE message to /127.0.0.3 [MessagingService-Outgoing-/127.0.0.3] | 2017-12-15 09:30:45.273000 | 127.0.0.1 | 158332
MUTATION message received from /127.0.0.3 [MessagingService-Incoming-/127.0.0.3] | 2017-12-15 09:30:45.276000 | 127.0.0.2 | 839
Appending to commitlog [SharedPool-Worker-1] | 2017-12-15 09:30:45.277000 | 127.0.0.2 | 2386
Adding to count_by_id memtable [SharedPool-Worker-1] | 2017-12-15 09:30:45.278000 | 127.0.0.2 | 2781
Enqueuing response to /127.0.0.3 [SharedPool-Worker-1] | 2017-12-15 09:30:45.280000 | 127.0.0.2 | 4534
Sending REQUEST_RESPONSE message to /127.0.0.3 [MessagingService-Outgoing-/127.0.0.3] | 2017-12-15 09:30:45.281000 | 127.0.0.2 | 5538
REQUEST_RESPONSE message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:30:45.282000 | 127.0.0.3 | --
Processing response from /127.0.0.2 [SharedPool-Worker-5] | 2017-12-15 09:30:45.282000 | 127.0.0.3 | --
REQUEST_RESPONSE message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:30:45.288000 | 127.0.0.3 | --
Processing response from /127.0.0.1 [SharedPool-Worker-5] | 2017-12-15 09:30:45.296000 | 127.0.0.3 | --
Request complete | 2017-12-15 09:30:45.308859 | 127.0.0.1 | 194859
activity | timestamp | source | source_elapsed
-------------------------------------------------------------------------------------------------+----------------------------+-----------+----------------
Execute CQL3 query | 2017-12-15 09:36:00.462000 | 127.0.0.1 | 0
Parsing select * from count_by_id WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:36:00.462000 | 127.0.0.1 | 410
Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:36:00.462000 | 127.0.0.1 | 662
reading data from /127.0.0.3 [SharedPool-Worker-1] | 2017-12-15 09:36:00.463000 | 127.0.0.1 | 1350
speculating read retry on /127.0.0.2 [SharedPool-Worker-1] | 2017-12-15 09:36:00.463000 | 127.0.0.1 | 1600
Sending READ message to /127.0.0.3 [MessagingService-Outgoing-/127.0.0.3] | 2017-12-15 09:36:00.463000 | 127.0.0.1 | 1807
Sending READ message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:36:00.464000 | 127.0.0.1 | 2095
READ message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:36:00.465000 | 127.0.0.2 | 32
Executing single-partition query on count_by_id [SharedPool-Worker-1] | 2017-12-15 09:36:00.466000 | 127.0.0.2 | 1209
READ message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:36:00.466000 | 127.0.0.3 | 31
Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:36:00.466000 | 127.0.0.2 | 1412
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:36:00.467000 | 127.0.0.2 | 1696
Merging data from memtables and 0 sstables [SharedPool-Worker-1] | 2017-12-15 09:36:00.467000 | 127.0.0.2 | 1837
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2017-12-15 09:36:00.468000 | 127.0.0.2 | 2787
Enqueuing response to /127.0.0.1 [SharedPool-Worker-1] | 2017-12-15 09:36:00.468000 | 127.0.0.2 | 3066
Executing single-partition query on count_by_id [SharedPool-Worker-3] | 2017-12-15 09:36:00.469000 | 127.0.0.3 | 3204
Acquiring sstable references [SharedPool-Worker-3] | 2017-12-15 09:36:00.469000 | 127.0.0.3 | 3361
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-3] | 2017-12-15 09:36:00.469000 | 127.0.0.3 | 3521
Merging data from memtables and 0 sstables [SharedPool-Worker-3] | 2017-12-15 09:36:00.469000 | 127.0.0.3 | 3618
REQUEST_RESPONSE message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:36:00.470000 | 127.0.0.1 | 7930
Read 1 live and 0 tombstone cells [SharedPool-Worker-3] | 2017-12-15 09:36:00.470000 | 127.0.0.3 | 3944
Processing response from /127.0.0.2 [SharedPool-Worker-3] | 2017-12-15 09:36:00.470000 | 127.0.0.1 | 8652
Enqueuing response to /127.0.0.1 [SharedPool-Worker-3] | 2017-12-15 09:36:00.470000 | 127.0.0.3 | 4086
Sending REQUEST_RESPONSE message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:36:00.471000 | 127.0.0.3 | 5113
REQUEST_RESPONSE message received from /127.0.0.3 [MessagingService-Incoming-/127.0.0.3] | 2017-12-15 09:36:00.473000 | 127.0.0.1 | --
Processing response from /127.0.0.3 [SharedPool-Worker-1] | 2017-12-15 09:36:00.475000 | 127.0.0.1 | --
Initiating read-repair [SharedPool-Worker-1] | 2017-12-15 09:36:00.476000 | 127.0.0.1 | --
Request complete | 2017-12-15 09:36:00.471932 | 127.0.0.1 | 9932
activity | timestamp | source | source_elapsed
------------------------------------------------------------------------------------------+----------------------------+-----------+----------------
Execute CQL3 query | 2017-12-15 09:39:45.185000 | 127.0.0.1 | 0
Parsing update count_by_id SET count = count + 1 WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:39:45.186000 | 127.0.0.1 | 270
Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:39:45.186000 | 127.0.0.1 | 515
Determining replicas for mutation [SharedPool-Worker-1] | 2017-12-15 09:39:45.186000 | 127.0.0.1 | 1076
Enqueuing counter update to /127.0.0.2 [SharedPool-Worker-1] | 2017-12-15 09:39:45.187000 | 127.0.0.1 | 1316
Sending COUNTER_MUTATION message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:39:45.187000 | 127.0.0.1 | 1757
COUNTER_MUTATION message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:39:45.188000 | 127.0.0.2 | 20
Acquiring counter locks [SharedPool-Worker-1] | 2017-12-15 09:39:45.188000 | 127.0.0.2 | 276
Fetching 1 counter values from cache [SharedPool-Worker-1] | 2017-12-15 09:39:45.192000 | 127.0.0.2 | 4223
Appending to commitlog [SharedPool-Worker-1] | 2017-12-15 09:39:45.192000 | 127.0.0.2 | 4497
Adding to count_by_id memtable [SharedPool-Worker-1] | 2017-12-15 09:39:45.192000 | 127.0.0.2 | 4641
Sending REQUEST_RESPONSE message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:39:45.195000 | 127.0.0.2 | 7541
Sending MUTATION message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:39:45.196000 | 127.0.0.2 | --
REQUEST_RESPONSE message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:39:45.197000 | 127.0.0.1 | 11624
Processing response from /127.0.0.2 [SharedPool-Worker-5] | 2017-12-15 09:39:45.197000 | 127.0.0.1 | 12026
MUTATION message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:39:45.197000 | 127.0.0.1 | 12115
Appending to commitlog [SharedPool-Worker-5] | 2017-12-15 09:39:45.198000 | 127.0.0.1 | 12249
Adding to count_by_id memtable [SharedPool-Worker-5] | 2017-12-15 09:39:45.198000 | 127.0.0.1 | 12443
Enqueuing response to /127.0.0.2 [SharedPool-Worker-5] | 2017-12-15 09:39:45.199000 | 127.0.0.1 | 13547
REQUEST_RESPONSE message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:39:45.200000 | 127.0.0.2 | --
Processing response from /127.0.0.1 [SharedPool-Worker-7] | 2017-12-15 09:39:45.201000 | 127.0.0.2 | --
Sending REQUEST_RESPONSE message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:39:45.205000 | 127.0.0.1 | --
Request complete | 2017-12-15 09:39:45.198520 | 127.0.0.1 | 13520
Execute CQL3 query | 2017-12-15 09:42:13.945000 | 127.0.0.1 | 0
Parsing select * from count_by_id WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:42:13.945000 | 127.0.0.1 | 130
Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:42:13.945000 | 127.0.0.1 | 293
Read-repair DC_LOCAL [SharedPool-Worker-1] | 2017-12-15 09:42:13.945000 | 127.0.0.1 | 892
reading data from /127.0.0.2 [SharedPool-Worker-1] | 2017-12-15 09:42:13.946000 | 127.0.0.1 | 1037
Sending READ message to /127.0.0.2 [MessagingService-Outgoing-/127.0.0.2] | 2017-12-15 09:42:13.946000 | 127.0.0.1 | 1266
Executing single-partition query on count_by_id [SharedPool-Worker-3] | 2017-12-15 09:42:13.946000 | 127.0.0.1 | 1569
Acquiring sstable references [SharedPool-Worker-3] | 2017-12-15 09:42:13.946000 | 127.0.0.1 | 1672
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-3] | 2017-12-15 09:42:13.946000 | 127.0.0.1 | 1766
Merging data from memtables and 0 sstables [SharedPool-Worker-3] | 2017-12-15 09:42:13.946000 | 127.0.0.1 | 1804
READ message received from /127.0.0.1 [MessagingService-Incoming-/127.0.0.1] | 2017-12-15 09:42:13.947000 | 127.0.0.2 | 21
Read 1 live and 0 tombstone cells [SharedPool-Worker-3] | 2017-12-15 09:42:13.947000 | 127.0.0.1 | 2019
Executing single-partition query on count_by_id [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 | 1431
Acquiring sstable references [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 | 1534
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 | 1622
Merging data from memtables and 0 sstables [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 | 1665
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 | 1854
Enqueuing response to /127.0.0.1 [SharedPool-Worker-1] | 2017-12-15 09:42:13.949000 | 127.0.0.2 | 1940
Sending REQUEST_RESPONSE message to /127.0.0.1 [MessagingService-Outgoing-/127.0.0.1] | 2017-12-15 09:42:13.953000 | 127.0.0.2 | 6002
REQUEST_RESPONSE message received from /127.0.0.2 [MessagingService-Incoming-/127.0.0.2] | 2017-12-15 09:42:13.956000 | 127.0.0.1 | --
Processing response from /127.0.0.2 [SharedPool-Worker-5] | 2017-12-15 09:42:13.958000 | 127.0.0.1 | --
Initiating read-repair [SharedPool-Worker-5] | 2017-12-15 09:42:13.958000 | 127.0.0.1 | --
Request complete | 2017-12-15 09:42:13.947333 | 127.0.0.1 | 2333
Or, without read-repair
Execute CQL3 query | 2017-12-15 09:43:15.999000 | 127.0.0.1 | 0
Parsing select * from count_by_id WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:43:15.999000 | 127.0.0.1 | 123
Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:43:15.999000 | 127.0.0.1 | 338
Executing single-partition query on count_by_id [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 732
Acquiring sstable references [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 813
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 887
Merging data from memtables and 0 sstables [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 927
Read 1 live and 0 tombstone cells [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 1102
Request complete | 2017-12-15 09:43:16.000361 | 127.0.0.1 | 1361
Execute CQL3 query | 2017-12-15 09:47:07.936000 | 127.0.0.1 | 0
Parsing update count_by_id SET count = count + 1 WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:47:07.936000 | 127.0.0.1 | 259
Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:47:07.936000 | 127.0.0.1 | 545
Determining replicas for mutation [SharedPool-Worker-1] | 2017-12-15 09:47:07.937000 | 127.0.0.1 | 1156
Acquiring counter locks [SharedPool-Worker-2] | 2017-12-15 09:47:07.937000 | 127.0.0.1 | 1304
Fetching 1 counter values from cache [SharedPool-Worker-2] | 2017-12-15 09:47:07.937000 | 127.0.0.1 | 1572
Appending to commitlog [SharedPool-Worker-2] | 2017-12-15 09:47:07.937001 | 127.0.0.1 | 1827
Adding to count_by_id memtable [SharedPool-Worker-2] | 2017-12-15 09:47:07.938000 | 127.0.0.1 | 1921
Request complete | 2017-12-15 09:47:07.938169 | 127.0.0.1 | 2169
Execute CQL3 query | 2017-12-15 09:43:15.999000 | 127.0.0.1 | 0
Parsing select * from count_by_id WHERE id = 1; [SharedPool-Worker-1] | 2017-12-15 09:43:15.999000 | 127.0.0.1 | 123
Preparing statement [SharedPool-Worker-1] | 2017-12-15 09:43:15.999000 | 127.0.0.1 | 338
Executing single-partition query on count_by_id [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 732
Acquiring sstable references [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 813
Skipped 0/0 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 887
Merging data from memtables and 0 sstables [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 927
Read 1 live and 0 tombstone cells [SharedPool-Worker-3] | 2017-12-15 09:43:16 | 127.0.0.1 | 1102
Request complete | 2017-12-15 09:43:16.000361 | 127.0.0.1 | 1361