Skip to content

Instantly share code, notes, and snippets.

@vishnevskiy

vishnevskiy/DELETE Secret

Last active July 6, 2016 09:43
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 vishnevskiy/36aa18c468344ea22d14f9fb9b99171d to your computer and use it in GitHub Desktop.
Save vishnevskiy/36aa18c468344ea22d14f9fb9b99171d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DELETE
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
Raw
SELECT
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