SHARE
TWEET

Cassandra Failed Select Trace

a guest Dec 13th, 2013 98 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. cqlsh:us> select * from subscribers_all limit 1;
  2.  
  3. Request did not complete within rpc_timeout.
  4.  
  5. Tracing session: e6420d80-63f6-11e3-b860-ad29953e270b
  6.  
  7.  activity                                                                      | timestamp    | source         | source_elapsed
  8. -------------------------------------------------------------------------------+--------------+----------------+----------------
  9.                                                             execute_cql3_query | 15:03:02,745 | 172.16.217.222 |              0
  10.                          Parsing select * from subscribers_all limit 1; | 15:03:02,745 | 172.16.217.222 |            141
  11.                                                            Preparing statement | 15:03:02,746 | 172.16.217.222 |            402
  12.                                                  Determining replicas to query | 15:03:02,746 | 172.16.217.222 |            548
  13.                                           Enqueuing request to /172.16.217.225 | 15:03:02,746 | 172.16.217.222 |            739
  14.                                             Sending message to /172.16.217.225 | 15:03:02,746 | 172.16.217.222 |            912
  15.                                          Message received from /172.16.217.222 | 15:03:02,747 | 172.16.217.225 |            152
  16.  Executing seq scan across 5 sstables for [min(-9223372036854775808), max(-2)] | 15:03:02,748 | 172.16.217.225 |            717
  17.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           5860
  18.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           5895
  19.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           5899
  20.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           5900
  21.                                             Read 0 live and 9 tombstoned cells | 15:03:02,753 | 172.16.217.225 |           6090
  22.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6123
  23.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6125
  24.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6127
  25.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6128
  26.                                             Read 0 live and 9 tombstoned cells | 15:03:02,753 | 172.16.217.225 |           6224
  27.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6239
  28.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6241
  29.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6243
  30.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6244
  31.                                             Read 0 live and 9 tombstoned cells | 15:03:02,753 | 172.16.217.225 |           6448
  32.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6468
  33.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6470
  34.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6471
  35.                                    Seeking to partition beginning in data file | 15:03:02,753 | 172.16.217.225 |           6473
  36.                                             Read 0 live and 9 tombstoned cells | 15:03:02,753 | 172.16.217.225 |  
  37.  
  38. .......
  39.  
  40.                          Timed out; received 0 of 1 responses for range 2 of 4 | 15:03:12,746 | 172.16.217.222 |       10001039
  41.                                                               Request complete | 15:03:12,746 | 172.16.217.222 |       10001116
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top