juhapoutiainen Software, Support, and Training for Apache Cassandra en-US Tue, 21 May 2013 19:43:03 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/opscenter-agent-error-getting-shorttime-node-details#post-9085 Wed, 20 Feb 2013 16:46:52 +0000 nickmbailey 9085@http://www.datastax.com/support-forums/ <p>I was incorrect before. The error getting compaction information is actually causing some of the other information to break as well. For now, restarting the agent should resolve the issue. That should be fixed in an upcoming release though. </p> http://www.datastax.com/support-forums/topic/how-to-list-all-rows-in-one-column-family-using-astyanax-here#post-9069 Tue, 19 Feb 2013 06:42:14 +0000 juha.poutiainen 9069@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>1. you need ordered partitioner<br /> (<a href="http://www.datastax.com/docs/1.0/cluster_architecture/partitioning" rel="nofollow">http://www.datastax.com/docs/1.0/cluster_architecture/partitioning</a>)</p> <p>2. composite key and secondary index is not necessarily the same thing. Check at least chapter "Clustering, compound keys, and more" (<a href="http://www.datastax.com/dev/blog/schema-in-cassandra-1-1" rel="nofollow">http://www.datastax.com/dev/blog/schema-in-cassandra-1-1</a>) </p> http://www.datastax.com/support-forums/topic/opscenter-agent-error-getting-shorttime-node-details#post-9062 Mon, 18 Feb 2013 11:23:51 +0000 juha.poutiainen 9062@http://www.datastax.com/support-forums/ <p>Here's list of items I found without further investigations:</p> <p>DASHBOARD:<br /> -storage capacity shows Used: 0 bytes, Free: 0 bytes, Total: 0 bytes ... while nodetool prints something else</p> <p>[snip@snip ~]$ nodetool ring</p> <p>Datacenter: datacenter1<br /> ==========<br /> Replicas: 2</p> <p>Address Rack Status State Load Owns Token<br /> 56713727820156407428984779325531226112<br /> 192.168.10.101 rack1 Up Normal 7.84 GB 66.67% 0<br /> 192.168.10.103 rack1 Up Normal 7.78 GB 66.67% 113427455640312814857969558651062452224<br /> 192.168.10.102 rack1 Up Normal 7.74 GB 66.67% 56713727820156407428984779325531226112</p> <p>-Disk IOPS: shows "no data"</p> <p>DATA EXPLORER:<br /> -shows keyspace but no CFs inside. From CLI &amp; CQLS CFs are visible. </p> http://www.datastax.com/support-forums/topic/opscenter-agent-error-getting-shorttime-node-details#post-9020 Thu, 14 Feb 2013 14:47:14 +0000 nickmbailey 9020@http://www.datastax.com/support-forums/ <p>That is a problem parsing compaction information on the agent. Thank you for the bug report, we'll look more into why that is happening. Is there anything else wrong with the agent operation besides the stack trace in the logs? That bug may prevent some compactions from showing in the UI but besides that things should work normally. </p> http://www.datastax.com/support-forums/topic/opscenter-agent-error-getting-shorttime-node-details#post-9019 Thu, 14 Feb 2013 12:28:54 +0000 juha.poutiainen 9019@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>have DSC1.2 3 node cluster with 1 keyspace &amp; one cf. Opscenter installed. Played around with virtual nodes, but as it's not supported by opscenter yet reverted to old configuration.<br /> This is test cluster so there's no damage done.</p> <p>At the same time when I reverted configs opscenter stopped working with agents correctly. No disk space stats available and exceptions in /var/log/opscenter-agent/agent.log</p> <p>Any ideas to get this monster back online?</p> <p> INFO [qtp983837745-36] 2013-02-14 12:20:18,810 New JMX connection (127.0.0.1:7199)<br /> INFO [qtp983837745-36] 2013-02-14 12:20:18,827 HTTP: :get /cluster/datacenter - 200<br /> INFO [qtp983837745-41] 2013-02-14 12:20:18,872 New JMX connection (127.0.0.1:7199)<br /> INFO [qtp983837745-41] 2013-02-14 12:20:18,887 HTTP: :get /cluster/rack - 200<br /> INFO [pool-5-thread-2] 2013-02-14 12:20:22,125 New JMX connection (127.0.0.1:7199)<br /> ERROR [pool-5-thread-2] 2013-02-14 12:20:22,144 Error getting shorttime node details<br /> java.lang.RuntimeException: java.lang.NumberFormatException: null<br /> at clojure.lang.LazySeq.sval(LazySeq.java:47)<br /> at clojure.lang.LazySeq.seq(LazySeq.java:56)<br /> at clojure.lang.RT.seq(RT.java:450)<br /> at clojure.core$seq.invoke(core.clj:122)<br /> at clojure.core$r.invoke(core.clj:793)<br /> at clojure.core$into.invoke(core.clj:2614)<br /> at opsagent.nodedetails.tasks$get_compaction_status.invoke(tasks.clj:79)<br /> at opsagent.nodedetails.tasks$get_tasks.invoke(tasks.clj:98)<br /> at opsagent.nodedetails$run_shorttime_collection$fn__2244.invoke(nodedetails.clj:171)<br /> at opsagent.jmx$jmx_wrap.doInvoke(jmx.clj:102)<br /> at clojure.lang.RestFn.invoke(RestFn.java:410)<br /> at opsagent.nodedetails$run_shorttime_collection.invoke(nodedetails.clj:165)<br /> at opsagent.nodedetails$start_pool$fn__2270.invoke(nodedetails.clj:232)<br /> at clojure.lang.AFn.run(AFn.java:24)<br /> at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)<br /> at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)<br /> at java.util.concurrent.FutureTask.runAndReset(Unknown Source)<br /> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(Unknown Source)<br /> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(Unknown Source)<br /> at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)<br /> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)<br /> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)<br /> at java.lang.Thread.run(Unknown Source)<br /> Caused by: java.lang.NumberFormatException: null<br /> at java.lang.Long.parseLong(Unknown Source)<br /> at java.lang.Long.parseLong(Unknown Source)<br /> at opsagent.nodedetails.tasks$parse_compaction_info.invoke(tasks.clj:68)<br /> at clojure.core$map$fn__3699.invoke(core.clj:2096)<br /> at clojure.lang.LazySeq.sval(LazySeq.java:42)<br /> ... 22 more </p> http://www.datastax.com/support-forums/topic/how-to-list-all-rows-in-one-column-family-using-astyanax-here#post-8914 Mon, 04 Feb 2013 22:59:03 +0000 mwang168 8914@http://www.datastax.com/support-forums/ <p>Hi, kind of newbie to Cassandra. Using Astynax here. I have a CF which are using Composite Key (id and updateDate). Try to page through all rows (in millions) to dump its content, how do I do it in Astyanax?</p> <p>Coming from RDBMS world, find a lot of restriction of this Non-SQLDB. Also have some other questions:</p> <p>1. is there a way to range query on row key (id)? How do I do it?<br /> 2. Is composite key better than secondary index? I just want to have range query on updateDate?</p> <p>THanks. </p>