Skip to content

Instantly share code, notes, and snippets.

@eevans

eevans/gist:81650261c2b1b5b99f83112865fef24b Secret

Created February 17, 2017 22:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save eevans/81650261c2b1b5b99f83112865fef24b to your computer and use it in GitHub Desktop.
Save eevans/81650261c2b1b5b99f83112865fef24b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
cassandra@cqlsh> select * from system_traces.sessions where session_id = 9f18fa80-f4ae-11e6-8dc7-ed97e191b93a;
session_id | client | command | coordinator | duration | parameters | request | started_at
--------------------------------------+-------------+---------+-------------+----------+-----------------------------------------------------------------------------------------------+-----------------------------+--------------------------
9f18fa80-f4ae-11e6-8dc7-ed97e191b93a | 10.64.32.79 | QUERY | 10.64.0.231 | 31376 | {'consistency_level': 'LOCAL_QUORUM', 'page_size': '1', 'serial_consistency_level': 'SERIAL'} | Execute CQL3 prepared query | 2017-02-17 01:15:51+0000
(1 rows)
cassandra@cqlsh>
Raw
gistfile2.txt
cassandra@cqlsh> show SESSION 9f18fa80-f4ae-11e6-8dc7-ed97e191b93a
Tracing session: 9f18fa80-f4ae-11e6-8dc7-ed97e191b93a
activity | timestamp | source | source_elapsed
--------------------------------------------------------------------------------------------------+----------------------------+--------------+----------------
Execute CQL3 prepared query | 2017-02-17 01:15:51.208000 | 10.64.0.231 | 0
reading data from /10.64.32.132 [SharedPool-Worker-2] | 2017-02-17 01:15:51.208000 | 10.64.0.231 | 396
reading digest from /10.64.0.116 [SharedPool-Worker-2] | 2017-02-17 01:15:51.208000 | 10.64.0.231 | 601
Sending READ message to /10.64.32.132 [MessagingService-Outgoing-/10.64.32.132] | 2017-02-17 01:15:51.208000 | 10.64.0.231 | 671
Sending READ message to /10.64.0.116 [MessagingService-Outgoing-/10.64.0.116] | 2017-02-17 01:15:51.208000 | 10.64.0.231 | 688
READ message received from /10.64.0.231 [MessagingService-Incoming-/10.64.0.231] | 2017-02-17 01:15:51.211000 | 10.64.32.132 | 629
Executing single-partition query on data [SharedPool-Worker-4] | 2017-02-17 01:15:51.212000 | 10.64.32.132 | 1392
Acquiring sstable references [SharedPool-Worker-4] | 2017-02-17 01:15:51.212000 | 10.64.32.132 | 1527
Merging memtable tombstones [SharedPool-Worker-4] | 2017-02-17 01:15:51.212000 | 10.64.32.132 | 1648
Bloom filter allows skipping sstable 1311 [SharedPool-Worker-4] | 2017-02-17 01:15:51.212000 | 10.64.32.132 | 1837
Bloom filter allows skipping sstable 1310 [SharedPool-Worker-4] | 2017-02-17 01:15:51.213000 | 10.64.32.132 | 1970
Bloom filter allows skipping sstable 1309 [SharedPool-Worker-4] | 2017-02-17 01:15:51.213000 | 10.64.32.132 | 2025
Bloom filter allows skipping sstable 1304 [SharedPool-Worker-4] | 2017-02-17 01:15:51.213000 | 10.64.32.132 | 2046
Bloom filter allows skipping sstable 1295 [SharedPool-Worker-4] | 2017-02-17 01:15:51.213000 | 10.64.32.132 | 2064
Bloom filter allows skipping sstable 1286 [SharedPool-Worker-4] | 2017-02-17 01:15:51.213000 | 10.64.32.132 | 2081
Bloom filter allows skipping sstable 1277 [SharedPool-Worker-4] | 2017-02-17 01:15:51.213000 | 10.64.32.132 | 2097
Key cache hit for sstable 1125 [SharedPool-Worker-4] | 2017-02-17 01:15:51.213001 | 10.64.32.132 | 2124
Seeking to partition beginning in data file [SharedPool-Worker-4] | 2017-02-17 01:15:51.213001 | 10.64.32.132 | 2183
Key cache hit for sstable 837 [SharedPool-Worker-4] | 2017-02-17 01:15:51.214000 | 10.64.32.132 | 3557
Seeking to partition beginning in data file [SharedPool-Worker-4] | 2017-02-17 01:15:51.214000 | 10.64.32.132 | 3588
Bloom filter allows skipping sstable 584 [SharedPool-Worker-4] | 2017-02-17 01:15:51.215000 | 10.64.32.132 | 4858
Bloom filter allows skipping sstable 375 [SharedPool-Worker-4] | 2017-02-17 01:15:51.216000 | 10.64.32.132 | 4882
READ message received from /10.64.0.231 [MessagingService-Incoming-/10.64.0.231] | 2017-02-17 01:15:51.216000 | 10.64.0.116 | 1549
Key cache hit for sstable 204 [SharedPool-Worker-4] | 2017-02-17 01:15:51.216000 | 10.64.32.132 | 4916
Seeking to partition beginning in data file [SharedPool-Worker-4] | 2017-02-17 01:15:51.216000 | 10.64.32.132 | 4931
Key cache hit for sstable 205 [SharedPool-Worker-4] | 2017-02-17 01:15:51.217000 | 10.64.32.132 | 6273
Seeking to partition beginning in data file [SharedPool-Worker-4] | 2017-02-17 01:15:51.217000 | 10.64.32.132 | 6422
Key cache hit for sstable 206 [SharedPool-Worker-4] | 2017-02-17 01:15:51.218000 | 10.64.32.132 | 7756
Seeking to partition beginning in data file [SharedPool-Worker-4] | 2017-02-17 01:15:51.218000 | 10.64.32.132 | 7774
Executing single-partition query on data [SharedPool-Worker-1] | 2017-02-17 01:15:51.219000 | 10.64.0.116 | 4875
Acquiring sstable references [SharedPool-Worker-1] | 2017-02-17 01:15:51.219000 | 10.64.0.116 | 5069
Merging memtable tombstones [SharedPool-Worker-1] | 2017-02-17 01:15:51.219000 | 10.64.0.116 | 5167
Bloom filter allows skipping sstable 207 [SharedPool-Worker-4] | 2017-02-17 01:15:51.220000 | 10.64.32.132 | 8980
Bloom filter allows skipping sstable 6308 [SharedPool-Worker-1] | 2017-02-17 01:15:51.220000 | 10.64.0.116 | 5317
Key cache hit for sstable 208 [SharedPool-Worker-4] | 2017-02-17 01:15:51.220000 | 10.64.32.132 | 9052
Bloom filter allows skipping sstable 6299 [SharedPool-Worker-1] | 2017-02-17 01:15:51.220000 | 10.64.0.116 | 5417
Seeking to partition beginning in data file [SharedPool-Worker-4] | 2017-02-17 01:15:51.220000 | 10.64.32.132 | 9097
Bloom filter allows skipping sstable 6290 [SharedPool-Worker-1] | 2017-02-17 01:15:51.220000 | 10.64.0.116 | 5473
Bloom filter allows skipping sstable 6281 [SharedPool-Worker-1] | 2017-02-17 01:15:51.220001 | 10.64.0.116 | 5501
Bloom filter allows skipping sstable 6248 [SharedPool-Worker-1] | 2017-02-17 01:15:51.220001 | 10.64.0.116 | 5522
Key cache hit for sstable 6108 [SharedPool-Worker-1] | 2017-02-17 01:15:51.220001 | 10.64.0.116 | 5589
Seeking to partition beginning in data file [SharedPool-Worker-1] | 2017-02-17 01:15:51.220001 | 10.64.0.116 | 5655
Key cache hit for sstable 210 [SharedPool-Worker-4] | 2017-02-17 01:15:51.221000 | 10.64.32.132 | 10325
Seeking to partition beginning in data file [SharedPool-Worker-4] | 2017-02-17 01:15:51.221000 | 10.64.32.132 | 10345
Bloom filter allows skipping sstable 211 [SharedPool-Worker-4] | 2017-02-17 01:15:51.222000 | 10.64.32.132 | 11476
Key cache hit for sstable 5788 [SharedPool-Worker-1] | 2017-02-17 01:15:51.222000 | 10.64.0.116 | 7415
Key cache hit for sstable 212 [SharedPool-Worker-4] | 2017-02-17 01:15:51.222000 | 10.64.32.132 | 11554
Seeking to partition beginning in data file [SharedPool-Worker-1] | 2017-02-17 01:15:51.222000 | 10.64.0.116 | 7615
Seeking to partition beginning in data file [SharedPool-Worker-4] | 2017-02-17 01:15:51.222000 | 10.64.32.132 | 11590
Bloom filter allows skipping sstable 213 [SharedPool-Worker-4] | 2017-02-17 01:15:51.224000 | 10.64.32.132 | 12915
Bloom filter allows skipping sstable 214 [SharedPool-Worker-4] | 2017-02-17 01:15:51.224000 | 10.64.32.132 | 12945
Bloom filter allows skipping sstable 215 [SharedPool-Worker-4] | 2017-02-17 01:15:51.224000 | 10.64.32.132 | 12977
Bloom filter allows skipping sstable 216 [SharedPool-Worker-4] | 2017-02-17 01:15:51.224000 | 10.64.32.132 | 12995
Skipped 0/23 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-4] | 2017-02-17 01:15:51.224000 | 10.64.32.132 | 13096
Merging data from memtables and 8 sstables [SharedPool-Worker-4] | 2017-02-17 01:15:51.224000 | 10.64.32.132 | 13115
Read 1 live and 0 tombstone cells [SharedPool-Worker-4] | 2017-02-17 01:15:51.224001 | 10.64.32.132 | 13686
Enqueuing response to /10.64.0.231 [SharedPool-Worker-4] | 2017-02-17 01:15:51.225000 | 10.64.32.132 | 13982
REQUEST_RESPONSE message received from /10.64.32.132 [MessagingService-Incoming-/10.64.32.132] | 2017-02-17 01:15:51.225000 | 10.64.0.231 | 17534
Sending REQUEST_RESPONSE message to /10.64.0.231 [MessagingService-Outgoing-/10.64.0.231] | 2017-02-17 01:15:51.225000 | 10.64.32.132 | 14161
Processing response from /10.64.32.132 [SharedPool-Worker-1] | 2017-02-17 01:15:51.225000 | 10.64.0.231 | 17660
Bloom filter allows skipping sstable 5507 [SharedPool-Worker-1] | 2017-02-17 01:15:51.226000 | 10.64.0.116 | 11648
Bloom filter allows skipping sstable 5269 [SharedPool-Worker-1] | 2017-02-17 01:15:51.226000 | 10.64.0.116 | 11685
Key cache hit for sstable 5245 [SharedPool-Worker-1] | 2017-02-17 01:15:51.226000 | 10.64.0.116 | 11708
Seeking to partition beginning in data file [SharedPool-Worker-1] | 2017-02-17 01:15:51.226000 | 10.64.0.116 | 11733
Key cache hit for sstable 5241 [SharedPool-Worker-1] | 2017-02-17 01:15:51.228000 | 10.64.0.116 | 13539
Seeking to partition beginning in data file [SharedPool-Worker-1] | 2017-02-17 01:15:51.228000 | 10.64.0.116 | 13596
Key cache hit for sstable 5242 [SharedPool-Worker-1] | 2017-02-17 01:15:51.229000 | 10.64.0.116 | 14948
Seeking to partition beginning in data file [SharedPool-Worker-1] | 2017-02-17 01:15:51.229000 | 10.64.0.116 | 14973
Bloom filter allows skipping sstable 5239 [SharedPool-Worker-1] | 2017-02-17 01:15:51.231000 | 10.64.0.116 | 16450
Key cache hit for sstable 5247 [SharedPool-Worker-1] | 2017-02-17 01:15:51.231000 | 10.64.0.116 | 16520
Seeking to partition beginning in data file [SharedPool-Worker-1] | 2017-02-17 01:15:51.231000 | 10.64.0.116 | 16538
Key cache hit for sstable 5246 [SharedPool-Worker-1] | 2017-02-17 01:15:51.232000 | 10.64.0.116 | 17651
Seeking to partition beginning in data file [SharedPool-Worker-1] | 2017-02-17 01:15:51.232000 | 10.64.0.116 | 17670
Key cache hit for sstable 5244 [SharedPool-Worker-1] | 2017-02-17 01:15:51.233000 | 10.64.0.116 | 18821
Seeking to partition beginning in data file [SharedPool-Worker-1] | 2017-02-17 01:15:51.233000 | 10.64.0.116 | 18842
Bloom filter allows skipping sstable 5238 [SharedPool-Worker-1] | 2017-02-17 01:15:51.237000 | 10.64.0.116 | 22477
Bloom filter allows skipping sstable 5240 [SharedPool-Worker-1] | 2017-02-17 01:15:51.237000 | 10.64.0.116 | 22502
Skipped 0/18 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2017-02-17 01:15:51.237000 | 10.64.0.116 | 22587
Merging data from memtables and 8 sstables [SharedPool-Worker-1] | 2017-02-17 01:15:51.237000 | 10.64.0.116 | 22610
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2017-02-17 01:15:51.237000 | 10.64.0.116 | 23195
Enqueuing response to /10.64.0.231 [SharedPool-Worker-1] | 2017-02-17 01:15:51.238000 | 10.64.0.116 | 23680
Sending REQUEST_RESPONSE message to /10.64.0.231 [MessagingService-Outgoing-/10.64.0.231] | 2017-02-17 01:15:51.238000 | 10.64.0.116 | 23884
REQUEST_RESPONSE message received from /10.64.0.116 [MessagingService-Incoming-/10.64.0.116] | 2017-02-17 01:15:51.239000 | 10.64.0.231 | 30890
Processing response from /10.64.0.116 [SharedPool-Worker-1] | 2017-02-17 01:15:51.239000 | 10.64.0.231 | 31031
Request complete | 2017-02-17 01:15:51.239376 | 10.64.0.231 | 31376
cassandra@cqlsh>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment