Created
August 12, 2014 16:36
-
-
Save dodizzle/7cb7b1529f4f53faf183 to your computer and use it in GitHub Desktop.
consistency ONE & then ALL tracing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cqlsh:Keyspace1> consistency one; | |
| Consistency level set to ONE. | |
| cqlsh:Keyspace1> update "Counter1" set value = value + 1 where key=0x303031313738343937 AND column1 = 'C0'; | |
| Tracing session: 70a58550-223e-11e4-8d7b-55bc21215380 | |
| activity | timestamp | source | source_elapsed | |
| ----------------------------------------------------------------------------------------------------+--------------+----------------+---------------- | |
| execute_cql3_query | 16:33:50,117 | 10.186.171.105 | 0 | |
| Message received from /10.186.171.105 | 16:33:50,117 | 10.101.159.85 | 32 | |
| Acquiring switchLock read lock | 16:33:50,117 | 10.101.159.85 | 366 | |
| Parsing update "Counter1" set value = value + 1 where key=0x303031313738343937 AND column1 = 'C0'; | 16:33:50,117 | 10.186.171.105 | 40 | |
| Appending to commitlog | 16:33:50,117 | 10.101.159.85 | 382 | |
| Preparing statement | 16:33:50,117 | 10.186.171.105 | 190 | |
| Adding to Counter1 memtable | 16:33:50,117 | 10.101.159.85 | 401 | |
| Determining replicas for mutation | 16:33:50,117 | 10.186.171.105 | 310 | |
| Executing single-partition query on Counter1 | 16:33:50,117 | 10.101.159.85 | 530 | |
| Enqueuing counter update to /10.101.159.85 | 16:33:50,117 | 10.186.171.105 | 341 | |
| Acquiring sstable references | 16:33:50,117 | 10.101.159.85 | 543 | |
| Sending message to /10.101.159.85 | 16:33:50,117 | 10.186.171.105 | 393 | |
| Merging memtable tombstones | 16:33:50,117 | 10.101.159.85 | 575 | |
| Partition index with 0 entries found for sstable 250 | 16:33:50,117 | 10.101.159.85 | 647 | |
| Sending message to /10.186.171.105 | 16:33:50,117 | 10.101.159.85 | 704 | |
| Partition index with 0 entries found for sstable 248 | 16:33:50,118 | 10.101.159.85 | 1335 | |
| Message received from /10.101.159.85 | 16:33:50,118 | 10.186.171.105 | 1575 | |
| Message received from /10.101.159.85 | 16:33:50,118 | 10.147.27.164 | 20 | |
| Processing response from /10.101.159.85 | 16:33:50,118 | 10.186.171.105 | 1629 | |
| Key cache hit for sstable 243 | 16:33:50,119 | 10.101.159.85 | 2136 | |
| Key cache hit for sstable 242 | 16:33:50,119 | 10.101.159.85 | 2170 | |
| Key cache hit for sstable 222 | 16:33:50,119 | 10.101.159.85 | 2199 | |
| Key cache hit for sstable 192 | 16:33:50,119 | 10.101.159.85 | 2229 | |
| Skipped 0/6 non-slice-intersecting sstables, included 0 due to tombstones | 16:33:50,119 | 10.101.159.85 | 2255 | |
| Merging data from memtables and 6 sstables | 16:33:50,119 | 10.101.159.85 | 2271 | |
| Sending message to /10.147.27.164 | 16:33:50,119 | 10.101.159.85 | null | |
| Sending message to /10.186.171.105 | 16:33:50,119 | 10.101.159.85 | null | |
| Message received from /10.186.171.105 | 16:33:50,120 | 10.101.159.85 | null | |
| Message received from /10.101.159.85 | 16:33:50,120 | 10.186.171.105 | 6 | |
| Processing response from /10.186.171.105 | 16:33:50,120 | 10.101.159.85 | null | |
| Acquiring switchLock read lock | 16:33:50,120 | 10.186.171.105 | 47 | |
| Appending to commitlog | 16:33:50,120 | 10.186.171.105 | 56 | |
| Adding to Counter1 memtable | 16:33:50,120 | 10.186.171.105 | 70 | |
| Enqueuing response to /10.101.159.85 | 16:33:50,120 | 10.186.171.105 | 104 | |
| Sending message to /10.101.159.85 | 16:33:50,120 | 10.186.171.105 | 153 | |
| Request complete | 16:33:50,118 | 10.186.171.105 | 1665 | |
| cqlsh:Keyspace1> consistency all; | |
| Consistency level set to ALL. | |
| cqlsh:Keyspace1> update "Counter1" set value = value + 1 where key=0x303031313738343937 AND column1 = 'C0'; | |
| Tracing session: 9e671530-223e-11e4-8d7b-55bc21215380 | |
| activity | timestamp | source | source_elapsed | |
| ----------------------------------------------------------------------------------------------------+--------------+----------------+---------------- | |
| execute_cql3_query | 16:35:06,884 | 10.186.171.105 | 0 | |
| Message received from /10.186.171.105 | 16:35:06,884 | 10.101.159.85 | 52 | |
| Parsing update "Counter1" set value = value + 1 where key=0x303031313738343937 AND column1 = 'C0'; | 16:35:06,884 | 10.186.171.105 | 55 | |
| Acquiring switchLock read lock | 16:35:06,884 | 10.101.159.85 | 206 | |
| Preparing statement | 16:35:06,884 | 10.186.171.105 | 211 | |
| Appending to commitlog | 16:35:06,884 | 10.101.159.85 | 221 | |
| Determining replicas for mutation | 16:35:06,884 | 10.186.171.105 | 337 | |
| Adding to Counter1 memtable | 16:35:06,884 | 10.101.159.85 | 241 | |
| Enqueuing counter update to /10.101.159.85 | 16:35:06,884 | 10.186.171.105 | 374 | |
| Executing single-partition query on Counter1 | 16:35:06,884 | 10.101.159.85 | 355 | |
| Sending message to /10.101.159.85 | 16:35:06,884 | 10.186.171.105 | 436 | |
| Acquiring sstable references | 16:35:06,884 | 10.101.159.85 | 371 | |
| Merging memtable tombstones | 16:35:06,884 | 10.101.159.85 | 405 | |
| Partition index with 0 entries found for sstable 253 | 16:35:06,884 | 10.101.159.85 | 482 | |
| Key cache hit for sstable 250 | 16:35:06,908 | 10.101.159.85 | 23835 | |
| Key cache hit for sstable 248 | 16:35:06,908 | 10.101.159.85 | 23876 | |
| Key cache hit for sstable 243 | 16:35:06,908 | 10.101.159.85 | 23905 | |
| Key cache hit for sstable 242 | 16:35:06,908 | 10.101.159.85 | 23936 | |
| Key cache hit for sstable 222 | 16:35:06,908 | 10.101.159.85 | 23966 | |
| Key cache hit for sstable 192 | 16:35:06,908 | 10.101.159.85 | 23994 | |
| Skipped 0/7 non-slice-intersecting sstables, included 0 due to tombstones | 16:35:06,908 | 10.101.159.85 | 24021 | |
| Merging data from memtables and 7 sstables | 16:35:06,908 | 10.101.159.85 | 24038 | |
| Sending message to /10.186.171.105 | 16:35:06,908 | 10.101.159.85 | 24199 | |
| Message received from /10.186.171.105 | 16:35:06,909 | 10.101.159.85 | 25507 | |
| Message received from /10.101.159.85 | 16:35:06,909 | 10.186.171.105 | 25214 | |
| Processing response from /10.186.171.105 | 16:35:06,909 | 10.101.159.85 | 25566 | |
| Acquiring switchLock read lock | 16:35:06,910 | 10.186.171.105 | 25760 | |
| Appending to commitlog | 16:35:06,910 | 10.186.171.105 | 25775 | |
| Adding to Counter1 memtable | 16:35:06,910 | 10.186.171.105 | 25793 | |
| Enqueuing response to /10.101.159.85 | 16:35:06,910 | 10.186.171.105 | 25824 | |
| Sending message to /10.101.159.85 | 16:35:06,910 | 10.186.171.105 | 25902 | |
| Sending message to /10.147.27.164 | 16:35:06,911 | 10.101.159.85 | 27181 | |
| Message received from /10.101.159.85 | 16:35:06,960 | 10.147.27.164 | 43 | |
| Acquiring switchLock read lock | 16:35:06,961 | 10.147.27.164 | 1387 | |
| Appending to commitlog | 16:35:06,961 | 10.147.27.164 | 1414 | |
| Adding to Counter1 memtable | 16:35:06,961 | 10.147.27.164 | 1431 | |
| Enqueuing response to /10.101.159.85 | 16:35:06,961 | 10.147.27.164 | 1456 | |
| Sending message to /10.101.159.85 | 16:35:06,961 | 10.147.27.164 | 1602 | |
| Message received from /10.147.27.164 | 16:35:06,963 | 10.101.159.85 | 79256 | |
| Processing response from /10.147.27.164 | 16:35:06,963 | 10.101.159.85 | 79341 | |
| Sending message to /10.186.171.105 | 16:35:06,963 | 10.101.159.85 | 79437 | |
| Message received from /10.101.159.85 | 16:35:06,964 | 10.186.171.105 | null | |
| Processing response from /10.101.159.85 | 16:35:06,964 | 10.186.171.105 | null | |
| Request complete | 16:35:06,964 | 10.186.171.105 | 80449 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment