Databases
StackOverflow2013
Postsdbo
POCassandra secondary index get_indexed_slices timing out
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCassandra secondary index get_indexed_slices timing out
    primarykey
    data
    text
    <p>I am using Cassandra 0.8 with 2 secondary indexes for columns like "DeviceID" and "DayOfYear". I have these two indexes in order to retrieve data for a device within a range of dates. Whenever I get a date filter, I convert this into DayOfYear and search using indexed slices using .net Thrift API. Currently I cannot upgrade the DB as well.</p> <p>My problem is I usually do not have any issues retrieving rows using the get_indexed_slices query for the current date (using current day of year). But whenever I query for yesterday's day of year (which is one of the indexed column), I get a time out for the first time I make the query. And most of the times, it returns when I query the second time and 100% during the third time.</p> <p>Both these columns are created as double data type in the column family and I generally get 1 record per minute. I have 3 nodes in the cluster and the nodetool reports suggest that the nodes are up and running, though the load distribution report from nodetool looks like this. <code></p> <p>Starting NodeTool Address DC Rack Status State Load Owns<br> xxx.xx.xxx.xx datacenter1 rack1 Up Normal 7.59 GB 51.39%<br> xxx.xx.xxx.xx datacenter1 rack1 Up Normal 394.24 MB 3.81%<br> xxx.xx.xxx.xx datacenter1 rack1 Up Normal 4.42 GB 44.80%<br> </code> and my configuration in YAML is as below.</p> <p><code> hinted_handoff_enabled: true<br /> max_hint_window_in_ms: 3600000 # one hour<br /> hinted_handoff_throttle_delay_in_ms: 50<br /> partitioner: org.apache.cassandra.dht.RandomPartitioner<br /> commitlog_sync: periodic<br /> commitlog_sync_period_in_ms: 120000<br /> flush_largest_memtables_at: 0.75<br /> reduce_cache_sizes_at: 0.85<br /> reduce_cache_capacity_to: 0.6<br /> concurrent_reads: 32<br /> concurrent_writes: 24<br /> sliced_buffer_size_in_kb: 64<br /> rpc_keepalive: true<br /> rpc_server_type: sync<br /> thrift_framed_transport_size_in_mb: 15<br /> thrift_max_message_length_in_mb: 16<br /> incremental_backups: true<br /> snapshot_before_compaction: false<br /> column_index_size_in_kb: 64<br /> in_memory_compaction_limit_in_mb: 64<br /> multithreaded_compaction: false<br /> compaction_throughput_mb_per_sec: 16<br /> compaction_preheat_key_cache: true<br /> rpc_timeout_in_ms: 50000<br /> index_interval: 128 </code></p> <p>Is there something I may be missing? Are there any problems in the config?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USMuthu
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCassandra secondary index get_indexed_slices timing out
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThere was a mistake on my version mentioned. The installed version is 1.0.5 and not .8. Sorry for the trouble.
      singulars
      1. POCassandra secondary index get_indexed_slices timing out
      1. USMuthu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload