-
-
Save vishnevskiy/36aa18c468344ea22d14f9fb9b99171d to your computer and use it in GitHub Desktop.
This file contains 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> DELETE FROM discord_relationships.relationships WHERE user_id = 116138050710536192 AND id = 153047019424972800; | |
Tracing session: 001f0ac0-435e-11e6-b02d-c138f1139d5e | |
activity | timestamp | source | source_elapsed | |
-----------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+------------+---------------- | |
Execute CQL3 query | 2016-07-06 09:42:48.940000 | 10.10.0.32 | 0 | |
Parsing DELETE FROM discord_relationships.relationships WHERE user_id = 116138050710536192 AND id = 153047019424972800; [SharedPool-Worker-2] | 2016-07-06 09:42:48.940000 | 10.10.0.32 | 117 | |
Preparing statement [SharedPool-Worker-2] | 2016-07-06 09:42:48.940000 | 10.10.0.32 | 232 | |
Determining replicas for mutation [SharedPool-Worker-2] | 2016-07-06 09:42:48.940000 | 10.10.0.32 | 375 | |
Sending MUTATION message to /10.10.0.58 [MessagingService-Outgoing-/10.10.0.58] | 2016-07-06 09:42:48.940000 | 10.10.0.32 | 603 | |
Sending MUTATION message to /10.10.0.52 [MessagingService-Outgoing-/10.10.0.52] | 2016-07-06 09:42:48.940000 | 10.10.0.32 | 660 | |
Appending to commitlog [SharedPool-Worker-6] | 2016-07-06 09:42:48.940001 | 10.10.0.32 | 690 | |
Adding to relationships memtable [SharedPool-Worker-6] | 2016-07-06 09:42:48.940001 | 10.10.0.32 | 734 | |
MUTATION message received from /10.10.0.32 [MessagingService-Incoming-/10.10.0.32] | 2016-07-06 09:42:48.941000 | 10.10.0.58 | 24 | |
REQUEST_RESPONSE message received from /10.10.0.58 [MessagingService-Incoming-/10.10.0.58] | 2016-07-06 09:42:48.941000 | 10.10.0.32 | 1691 | |
MUTATION message received from /10.10.0.32 [MessagingService-Incoming-/10.10.0.32] | 2016-07-06 09:42:48.941000 | 10.10.0.52 | 48 | |
Appending to commitlog [SharedPool-Worker-1] | 2016-07-06 09:42:48.941000 | 10.10.0.58 | 146 | |
Appending to commitlog [SharedPool-Worker-6] | 2016-07-06 09:42:48.941000 | 10.10.0.52 | 184 | |
Adding to relationships memtable [SharedPool-Worker-1] | 2016-07-06 09:42:48.941000 | 10.10.0.58 | 203 | |
Adding to relationships memtable [SharedPool-Worker-6] | 2016-07-06 09:42:48.941000 | 10.10.0.52 | 234 | |
Enqueuing response to /10.10.0.32 [SharedPool-Worker-1] | 2016-07-06 09:42:48.941000 | 10.10.0.58 | 268 | |
Enqueuing response to /10.10.0.32 [SharedPool-Worker-6] | 2016-07-06 09:42:48.941000 | 10.10.0.52 | 481 | |
Sending REQUEST_RESPONSE message to /10.10.0.32 [MessagingService-Outgoing-/10.10.0.32] | 2016-07-06 09:42:48.941000 | 10.10.0.58 | 677 | |
Sending REQUEST_RESPONSE message to /10.10.0.32 [MessagingService-Outgoing-/10.10.0.32] | 2016-07-06 09:42:48.941000 | 10.10.0.52 | 778 | |
Processing response from /10.10.0.58 [SharedPool-Worker-1] | 2016-07-06 09:42:48.942000 | 10.10.0.32 | 1818 | |
REQUEST_RESPONSE message received from /10.10.0.52 [MessagingService-Incoming-/10.10.0.52] | 2016-07-06 09:42:48.942000 | 10.10.0.32 | 1948 | |
Processing response from /10.10.0.52 [SharedPool-Worker-6] | 2016-07-06 09:42:48.942000 | 10.10.0.32 | 2008 | |
Request complete | 2016-07-06 09:42:48.942097 | 10.10.0.32 | 2097 |
This file contains 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> SELECT WRITETIME(since), WRITETIME(type) FROM discord_relationships.relationships WHERE user_id = 116138050710536192 AND id = 153047019424972800; | |
writetime(since) | writetime(type) | |
------------------+------------------ | |
1464619988173052 | 1464619988173052 | |
(1 rows) | |
Tracing session: 029c18b0-435e-11e6-b02d-c138f1139d5e | |
activity | timestamp | source | source_elapsed | |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------+------------+---------------- | |
Execute CQL3 query | 2016-07-06 09:42:53.115000 | 10.10.0.32 | 0 | |
Parsing SELECT WRITETIME(since), WRITETIME(type) FROM discord_relationships.relationships WHERE user_id = 116138050710536192 AND id = 153047019424972800; [SharedPool-Worker-2] | 2016-07-06 09:42:53.115000 | 10.10.0.32 | 114 | |
Preparing statement [SharedPool-Worker-2] | 2016-07-06 09:42:53.115000 | 10.10.0.32 | 302 | |
Executing single-partition query on relationships [SharedPool-Worker-1] | 2016-07-06 09:42:53.116000 | 10.10.0.32 | 1089 | |
Acquiring sstable references [SharedPool-Worker-1] | 2016-07-06 09:42:53.116000 | 10.10.0.32 | 1140 | |
Merging memtable contents [SharedPool-Worker-1] | 2016-07-06 09:42:53.116000 | 10.10.0.32 | 1158 | |
Merging data from sstable 4224 [SharedPool-Worker-1] | 2016-07-06 09:42:53.116000 | 10.10.0.32 | 1194 | |
reading digest from /10.10.0.58 [SharedPool-Worker-2] | 2016-07-06 09:42:53.116000 | 10.10.0.32 | 1201 | |
Key cache hit for sstable 4224 [SharedPool-Worker-1] | 2016-07-06 09:42:53.116000 | 10.10.0.32 | 1248 | |
Merging data from sstable 4216 [SharedPool-Worker-1] | 2016-07-06 09:42:53.116001 | 10.10.0.32 | 1391 | |
READ message received from /10.10.0.32 [MessagingService-Incoming-/10.10.0.32] | 2016-07-06 09:42:53.117000 | 10.10.0.58 | 24 | |
Key cache hit for sstable 4216 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.32 | 1426 | |
READ message received from /10.10.0.32 [MessagingService-Incoming-/10.10.0.32] | 2016-07-06 09:42:53.117000 | 10.10.0.52 | 25 | |
Executing single-partition query on relationships [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.58 | 183 | |
reading digest from /10.10.0.52 [SharedPool-Worker-2] | 2016-07-06 09:42:53.117000 | 10.10.0.32 | 1432 | |
Executing single-partition query on relationships [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.52 | 107 | |
Acquiring sstable references [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.58 | 212 | |
Sending READ message to /10.10.0.58 [MessagingService-Outgoing-/10.10.0.58] | 2016-07-06 09:42:53.117000 | 10.10.0.32 | 1497 | |
Acquiring sstable references [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.52 | 124 | |
Merging memtable contents [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.58 | 229 | |
Merging data from sstable 4215 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.32 | 1610 | |
Merging memtable contents [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.52 | 134 | |
Merging data from sstable 4152 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.58 | 272 | |
Sending READ message to /10.10.0.52 [MessagingService-Outgoing-/10.10.0.52] | 2016-07-06 09:42:53.117000 | 10.10.0.32 | 1625 | |
Merging data from sstable 3960 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.52 | 167 | |
Key cache hit for sstable 4152 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.58 | 298 | |
Key cache hit for sstable 4215 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.32 | 1640 | |
Key cache hit for sstable 3960 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117000 | 10.10.0.52 | 188 | |
Merging data from sstable 4144 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.58 | 407 | |
Merging data from sstable 4214 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.32 | 1759 | |
Merging data from sstable 3952 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.52 | 369 | |
Key cache hit for sstable 4144 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.58 | 427 | |
Bloom filter allows skipping sstable 4214 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.32 | 1805 | |
Key cache hit for sstable 3952 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.52 | 393 | |
Merging data from sstable 4142 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.58 | 514 | |
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.32 | 1853 | |
Merging data from sstable 3951 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.52 | 518 | |
Key cache hit for sstable 4142 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.58 | 537 | |
Key cache hit for sstable 3951 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.52 | 557 | |
Merging data from sstable 4143 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.58 | 632 | |
Key cache hit for sstable 4143 [SharedPool-Worker-1] | 2016-07-06 09:42:53.117001 | 10.10.0.58 | 654 | |
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2016-07-06 09:42:53.118000 | 10.10.0.58 | 819 | |
REQUEST_RESPONSE message received from /10.10.0.58 [MessagingService-Incoming-/10.10.0.58] | 2016-07-06 09:42:53.118000 | 10.10.0.32 | 3149 | |
Merging data from sstable 3950 [SharedPool-Worker-1] | 2016-07-06 09:42:53.118000 | 10.10.0.52 | 683 | |
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2016-07-06 09:42:53.118000 | 10.10.0.58 | 843 | |
Processing response from /10.10.0.58 [SharedPool-Worker-3] | 2016-07-06 09:42:53.118000 | 10.10.0.32 | 3312 | |
Bloom filter allows skipping sstable 3950 [SharedPool-Worker-1] | 2016-07-06 09:42:53.118000 | 10.10.0.52 | 703 | |
Enqueuing response to /10.10.0.32 [SharedPool-Worker-1] | 2016-07-06 09:42:53.118000 | 10.10.0.58 | 876 | |
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2016-07-06 09:42:53.118000 | 10.10.0.52 | 741 | |
Sending REQUEST_RESPONSE message to /10.10.0.32 [MessagingService-Outgoing-/10.10.0.32] | 2016-07-06 09:42:53.118001 | 10.10.0.58 | 1175 | |
Read 1 live and 0 tombstone cells [SharedPool-Worker-1] | 2016-07-06 09:42:53.118001 | 10.10.0.52 | 759 | |
Enqueuing response to /10.10.0.32 [SharedPool-Worker-1] | 2016-07-06 09:42:53.118001 | 10.10.0.52 | 927 | |
Sending REQUEST_RESPONSE message to /10.10.0.32 [MessagingService-Outgoing-/10.10.0.32] | 2016-07-06 09:42:53.118001 | 10.10.0.52 | 1092 | |
REQUEST_RESPONSE message received from /10.10.0.52 [MessagingService-Incoming-/10.10.0.52] | 2016-07-06 09:42:53.119000 | 10.10.0.32 | 3412 | |
Processing response from /10.10.0.52 [SharedPool-Worker-6] | 2016-07-06 09:42:53.119000 | 10.10.0.32 | 3517 | |
Request complete | 2016-07-06 09:42:53.118730 | 10.10.0.32 | 3730 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment