http://www.datastax.com/support-forums/forum/datastax-community Software, Support, and Training for Apache Cassandra en-US Mon, 20 May 2013 02:31:31 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/cassandra-startup-error#post-11154 Thu, 16 May 2013 18:27:31 +0000 pico303 11154@http://www.datastax.com/support-forums/ <p>I'm in the same situation, and seeing the same thing. I'm on a MacBook Pro. Could there be a problem when I leave Cassandra running and close the lid of my laptop, putting everything to sleep? </p> http://www.datastax.com/support-forums/topic/java-driver-invalidqueryexception-no-keyspace-has-been-specified#post-10964 Mon, 13 May 2013 08:54:56 +0000 Gibu 10964@http://www.datastax.com/support-forums/ <p>I was running the SimpleClient example provided with Java Driver for Apache Cassandra 1.0 using CQL 3. </p> <p>I spent quite some time to figure out why I was getting the error. I get the error "no keyspace has been specified" even though I explicitly mention the keyspace in the query. Later figured out that I need to explicitly set it in the "session" in the case of PreparedStatement usage as seen in the code attached. </p> <blockquote><p> log4j:WARN See <a href="http://logging.apache.org/log4j/1.2/faq.html#noconfig" rel="nofollow">http://logging.apache.org/log4j/1.2/faq.html#noconfig</a> for more info.<br /> Connected to cluster: MyCluster<br /> Datatacenter: datacenter1; Host: localhost/127.0.0.1; Rack: rack1<br /> Exception in thread "main" com.datastax.driver.core.exceptions.InvalidQueryException: no keyspace has been specified<br /> at com.datastax.driver.core.exceptions.InvalidQueryException.copy(InvalidQueryException.java:32)<br /> at com.datastax.driver.core.ResultSetFuture.extractCause(ResultSetFuture.java:242)<br /> at com.datastax.driver.core.Session.toPreparedStatement(Session.java:243)<br /> at com.datastax.driver.core.Session.prepare(Session.java:167)<br /> at com.example.cassandra.SimpleClient.loadDataUsingBoundStatements(SimpleClient.java:30)<br /> at com.example.cassandra.SimpleClient.main(SimpleClient.java:152)<br /> Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: no keyspace has been specified<br /> at com.datastax.driver.core.ResultSetFuture.convertException(ResultSetFuture.java:272)</p> </blockquote> <p>Can someone confirm if this is the expected behavior as I am setting it in the query as keyspace.table name. </p> <p>Code attached.</p> <p>Thanks<br /> Gibu<br /> ps: If its the expected behaviour, we could change the tutorial here to include that.<br /> <a href="http://www.datastax.com/doc-source/developer/java-driver/index.html#quick_start/qsSimpleClientBoundStatements_t.html" rel="nofollow">http://www.datastax.com/doc-source/developer/java-driver/index.html#quick_start/qsSimpleClientBoundStatements_t.html</a></p> <blockquote><p> //$Id$<br /> package com.example.cassandra;</p> <p>import com.datastax.driver.core.Cluster;</p> <p>import com.datastax.driver.core.Host;<br /> import com.datastax.driver.core.Row;<br /> import com.datastax.driver.core.Session;<br /> import com.datastax.driver.core.ResultSet;<br /> import com.datastax.driver.core.SimpleStatement;<br /> import com.datastax.driver.core.Metadata;<br /> import com.datastax.driver.core.*;<br /> import java.util.*;</p> <p>public class SimpleClient {<br /> private Cluster cluster;<br /> private Session session;</p> <p> public Session getSession() {</p> <p> return session;<br /> }</p> <p> public void loadDataUsingBoundStatements() {</p> <p> //Bug ? comment this line and this gives an exception that there is no keyspace set even though its set in the query.<br /> //getSession().execute("use simplex");</p> <p> PreparedStatement statement = getSession().prepare(<br /> "INSERT INTO simplex.songs " +<br /> "(id, title, album, artist, tags) " +<br /> "VALUES (?, ?, ?, ?, ?);");<br /> BoundStatement boundStatement = new BoundStatement(statement);<br /> Set&lt;String&gt; tags = new HashSet&lt;String&gt;();<br /> tags.add("jazz");<br /> tags.add("2013");<br /> getSession().execute(boundStatement.bind(<br /> UUID.fromString("756716f7-2e54-4715-9f00-91dcbea6cf50"),<br /> "La Petite Tonkinoise'",<br /> "Bye Bye Blackbird'",<br /> "Joséphine Baker",<br /> tags ) );<br /> statement = getSession().prepare(<br /> "INSERT INTO simplex.playlists " +<br /> "(id, song_id, title, album, artist) " +<br /> "VALUES (?, ?, ?, ?, ?);");<br /> boundStatement = new BoundStatement(statement);<br /> getSession().execute(boundStatement.bind(<br /> UUID.fromString("2cc9ccb7-6221-4ccb-8387-f22b6a1b354d"),<br /> UUID.fromString("756716f7-2e54-4715-9f00-91dcbea6cf50"),<br /> "La Petite Tonkinoise",<br /> "Bye Bye Blackbird",<br /> "Joséphine Baker") );<br /> }</p> <p> public void querySchema() {<br /> ResultSet results = session.execute("SELECT * FROM simplex.playlists " +<br /> "WHERE id = 2cc9ccb7-6221-4ccb-8387-f22b6a1b354d;");<br /> System.out.println("\n"+String.format("%-30s\t%-20s\t%-20s\n%s", "title", "album", "artist",<br /> "-------------------------------+-----------------------+--------------------"));<br /> for (Row row : results) {<br /> System.out.println(String.format("%-30s\t%-20s\t%-20s", row.getString("title"),<br /> row.getString("album"), row.getString("artist")));<br /> }<br /> System.out.println();</p> <p> }</p> <p> public void loadData() {<br /> session.execute(<br /> "INSERT INTO simplex.songs (id, title, album, artist, tags) " +<br /> "VALUES (" +<br /> "756716f7-2e54-4715-9f00-91dcbea6cf50," +<br /> "'La Petite Tonkinoise'," +<br /> "'Bye Bye Blackbird'," +<br /> "'Joséphine Baker'," +<br /> "{'jazz', '2013'})" +<br /> ";");<br /> session.execute(<br /> "INSERT INTO simplex.playlists (id, song_id, title, album, artist) " +<br /> "VALUES (" +<br /> "2cc9ccb7-6221-4ccb-8387-f22b6a1b354d," +<br /> "756716f7-2e54-4715-9f00-91dcbea6cf50," +<br /> "'La Petite Tonkinoise'," +<br /> "'Bye Bye Blackbird'," +<br /> "'Joséphine Baker'" +<br /> ");");</p> <p> }</p> <p> public void createSchema() { </p> <p> session.execute("CREATE KEYSPACE simplex WITH replication " +<br /> "= {'class':'SimpleStrategy', 'replication_factor':1};");</p> <p> session.execute(<br /> "CREATE TABLE simplex.songs (" +<br /> "id uuid PRIMARY KEY," +<br /> "title text," +<br /> "album text," +<br /> "artist text," +<br /> "tags set&lt;text&gt;," +<br /> "data blob" +<br /> ");");<br /> session.execute(<br /> "CREATE TABLE simplex.playlists (" +<br /> "id uuid," +<br /> "title text," +<br /> "album text, " +<br /> "artist text," +<br /> "song_id uuid," +<br /> "PRIMARY KEY (id, title, album, artist)" +<br /> ");");</p> <p> }</p> <p> public void connect(String node) {<br /> cluster = Cluster.builder()<br /> .addContactPoint(node).build();<br /> session = cluster.connect();<br /> Metadata metadata = cluster.getMetadata();<br /> System.out.printf("Connected to cluster: %s\n",<br /> metadata.getClusterName());<br /> for ( Host host : metadata.getAllHosts() ) {<br /> System.out.printf("Datatacenter: %s; Host: %s; Rack: %s\n",<br /> host.getDatacenter(), host.getAddress(), host.getRack());<br /> }<br /> }</p> <p> public void close() {<br /> cluster.shutdown();<br /> }</p> <p> public static void main(String[] args) {<br /> SimpleClient client = new SimpleClient();<br /> client.connect("localhost");<br /> try {<br /> client.createSchema();<br /> }<br /> catch(Exception alreadyExists)<br /> {</p> <p> System.out.print("Exception: Schema already exists.");<br /> }<br /> //client.loadData();<br /> client.loadDataUsingBoundStatements();<br /> client.querySchema();</p> <p> client.close();<br /> }<br /> }</p> </blockquote> http://www.datastax.com/support-forums/topic/datastax-odbc-driver-error-thrifthiveclient-unknown-errno-10053#post-10847 Thu, 09 May 2013 22:19:36 +0000 Steven Lowenthal 10847@http://www.datastax.com/support-forums/ <p>The ODBC driver for Hive only works against DataStax Enterprise addition when running Hadoop. We have a new ODBC driver which runs directly against Cassandra coming out shortly. </p> http://www.datastax.com/support-forums/topic/ec2-ami-24-issue#post-10845 Thu, 09 May 2013 20:38:41 +0000 joaquin 10845@http://www.datastax.com/support-forums/ <p>Sure, no problem.</p> <p>I've gone through and patched the code to include a non-documented workaround for Spot instances. You may now bring up clusters by using:</p> <p>--clustername DevCassandra --totalnodes 3 --version community --customreservation unique_key</p> <p>where unique_key is a private hash. Be sure to choose a long hash key to avoid other nodes from joining your cluster. If you were to choose a unique_key of "1" and someone else launched their cluster within 10 minutes of yours, using the same key, both of your clusters could merge together, depending on your firewall settings.</p> <p>Also, all instances must come up at the same time, or not at all, so do make sure to set a Launch Group when starting your Spot Instances.</p> <p>Also, if any nodes go offline, then reappear, the code is not set to have them auto-join the existing ring.</p> <p>Hope this helps!<br /> Joaquin </p> http://www.datastax.com/support-forums/topic/datastax-odbc-driver-error-thrifthiveclient-unknown-errno-10053#post-10844 Thu, 09 May 2013 18:00:17 +0000 Sven 10844@http://www.datastax.com/support-forums/ <p>For Cassandra questions, this forum is no longer the best place to look for help, it's mostly kept around for old references. I suggest subscribing to the Cassandra users list linked at the bottom of <a href="http://cassandra.apache.org/" rel="nofollow">http://cassandra.apache.org/</a>, visiting <a href="http://http://planetcassandra.org/" rel="nofollow">http://http://planetcassandra.org/</a> and using <a href="http://stackoverflow.com/search?q=cassandra" rel="nofollow">http://stackoverflow.com/search?q=cassandra</a></p> <p>Thanks,<br /> Sven </p> http://www.datastax.com/support-forums/topic/datastax-odbc-driver-error-thrifthiveclient-unknown-errno-10053#post-10843 Thu, 09 May 2013 17:53:45 +0000 brwnba2010 10843@http://www.datastax.com/support-forums/ <p>Update: Installed Datastax CE and Datastax ODBC driver on the same machine to remove the vm environment (skytap) from the equation...after updating the server address to reflect the non network data source (now 10.20.23.1), I am still seeing the same behavior. </p> http://www.datastax.com/support-forums/topic/datastax-odbc-driver-error-thrifthiveclient-unknown-errno-10053#post-10839 Thu, 09 May 2013 16:36:34 +0000 brwnba2010 10839@http://www.datastax.com/support-forums/ <p>Installed Datastax CE and then installed the Datastax ODBC driver on a client machine, Turned off Windows Firewall, here are my settings and the error message when attempting to test the ODBC driver. Note I am using Skytap VM images in this environment:</p> <p>Host is set to the ip of the host: 10.20.25.3 in my case.<br /> Port :8888<br /> Database: default<br /> Advanced setting are their default settings:</p> <p>Row fetched per block: 10000<br /> Default string column length: 255<br /> Everything else unchecked.</p> <p>ODBC Driver hangs, and then after killing with Task Manager. I get this ODBC error.</p> <p>Connector Version: V1.0.0.1007</p> <p>Running connectivity tests...</p> <p>Attempting connection<br /> Failed to establish connection<br /> SQLSTATE: HY000[DataStax][Hardy] (22) Error from ThriftHiveClient: Unknown: errno = 10053</p> <p>TESTS COMPLETED WITH ERROR. </p> http://www.datastax.com/support-forums/topic/ec2-ami-24-issue#post-10831 Thu, 09 May 2013 13:36:48 +0000 amey 10831@http://www.datastax.com/support-forums/ <p>Thanks for your help Joaquin. I tried it with Non Spot instances yesterday night and it works perfectly fine. For some reason while using Spot instances, it creates 3 different clusters when three instances are specified in arguments.<br /> I am going ahead with the solution you have recommended starting with one node cluster on Spot and then provisioning others.<br /> Would be interested to know if your team gets a chance to test it once on Spot instances and see if this can be fixed with some minor changes.</p> <p>Thanks,<br /> Amey </p> http://www.datastax.com/support-forums/topic/ec2-ami-24-issue#post-10796 Thu, 09 May 2013 00:00:52 +0000 joaquin 10796@http://www.datastax.com/support-forums/ <p>Yeah, Spot Instances may be causing issues if not the instance metadata is different, the nodes do not come up at the same time, or the networking between Spot instances are different.</p> <p>We do not support VPC, since some metadata is missing from the instances, and we typically run our AMI's with standard instances. If spot instances are a requirement, you may want to spin up one node, install OpsCenter, then have that one instance provision the rest of the spot instances for you.</p> <p>Yes, we will maintain only one AMI at a time. If we ever need to re-bake, we will destroy the old AMI and create a new one based off the same branch, with whatever major fixes are needed.</p> <p>All minor fixes, however, are pushed to the AMI during it's launch cycle. </p> http://www.datastax.com/support-forums/topic/ec2-ami-24-issue#post-10792 Wed, 08 May 2013 20:57:31 +0000 amey 10792@http://www.datastax.com/support-forums/ <p>Ok I am allowed only to use Spot Instances here at work, but I will definitely try with Non Spot instances on my personal id in sometime. Just wanted to confirm, this is the URL to launch the latest AMI correct ?</p> <p><a href="https://aws.amazon.com/amis/datastax-auto-clustering-ami-2-2" rel="nofollow">https://aws.amazon.com/amis/datastax-auto-clustering-ami-2-2</a><br /> AMI: DataStax Auto-Clustering AMI 2.4<br /> AMI ID : ami-814ec2e8 </p> http://www.datastax.com/support-forums/topic/ec2-ami-24-issue#post-10791 Wed, 08 May 2013 20:54:01 +0000 joaquin 10791@http://www.datastax.com/support-forums/ <p>Let's try non-spot instances. I've yet to test on spot instances, so that could be causing the issue. </p> http://www.datastax.com/support-forums/topic/ec2-ami-24-issue#post-10790 Wed, 08 May 2013 20:51:53 +0000 amey 10790@http://www.datastax.com/support-forums/ <p>Thanks Joaquin. Let me try to repeat the process right now. The firewall rules are as relaxed as possible. Also, would it matter if I am using Spot instances on EC2 ? </p> http://www.datastax.com/support-forums/topic/ec2-ami-24-issue#post-10789 Wed, 08 May 2013 20:48:41 +0000 joaquin 10789@http://www.datastax.com/support-forums/ <p>I just tried a launch with similar parameters without issue:</p> <p>Cluster started with these options:<br /> --clustername 'dev' --totalnodes 3 --version Community</p> <p>Raiding complete.<br /> Waiting for nodetool...<br /> The cluster is now in it's finalization phase. This should only take a moment...</p> <p>Note: You can also use CTRL+C to view the logs if desired:<br /> AMI log: ~/datastax_ami/ami.log<br /> Cassandra log: /var/log/cassandra/system.log</p> <p>Datacenter: us-east<br /> ===================<br /> Status=Up/Down<br /> |/ State=Normal/Leaving/Joining/Moving<br /> -- Address Load Tokens Owns (effective) Host ID Rack<br /> UN 10.241.85.220 100.03 KB 256 30.5% bb7761f8-9f1e-4851-8815-1b4521f206e4 1c<br /> UN 10.46.218.52 ? 256 32.2% 43f7f497-b8ed-4b11-9d73-c9ffedc7781a 1c<br /> UN 10.96.250.185 51.13 KB 256 37.3% ca9915b0-b8ae-4a73-8125-e727faeab13e 1c</p> <p>....</p> <p>Perhaps your firewall settings are too strict? Make sure the following ports are open between each node in the cluster:<br /> <a href="http://www.datastax.com/docs/1.2/install/install_ami#creating-an-ec2-security-group-for-datastax-community-edition" rel="nofollow">http://www.datastax.com/docs/1.2/install/install_ami#creating-an-ec2-security-group-for-datastax-community-edition</a> </p> http://www.datastax.com/support-forums/topic/ec2-ami-24-issue#post-10788 Wed, 08 May 2013 20:39:18 +0000 amey 10788@http://www.datastax.com/support-forums/ <p>Sorry that was a typo.... Here is the startup log from one of the machines.. just hiding some IP addresses.</p> <p>Cluster started with these options:<br /> --clustername DevCassandra --totalnodes 3 --version community</p> <p>Waiting for nodetool...<br /> The cluster is now in it's finalization phase. This should only take a moment...</p> <p>Note: You can also use CTRL+C to view the logs if desired:<br /> AMI log: ~/datastax_ami/ami.log<br /> Cassandra log: /var/log/cassandra/system.log</p> <p>Datacenter: us-east<br /> ===================<br /> Status=Up/Down<br /> |/ State=Normal/Leaving/Joining/Moving<br /> -- Address Load Tokens Owns (effective) Host ID Rack<br /> UN 10.47.xx.xxx 67.14 KB 256 100.0% 1d610ec1-ae34-4a73-8a1f-96db8993afe5 1c</p> <p> Please wait 60 seconds if this is the cluster's first start...</p> <p>Tools:<br /> Run: datastax_tools<br /> Demos:<br /> Run: datastax_demos<br /> Support:<br /> Run: datastax_support</p> <p>------------------------------------<br /> DataStax AMI for DataStax Enterprise<br /> and DataStax Community<br /> AMI version 2.4<br /> DataStax Community version 1.2.4-1</p> <p>------------------------------------</p> <p>ubuntu@ip-10-47-xx-xxx:~$ </p> http://www.datastax.com/support-forums/topic/ec2-ami-24-issue#post-10787 Wed, 08 May 2013 20:16:45 +0000 joaquin 10787@http://www.datastax.com/support-forums/ <p>Hello Amey,</p> <p>It seems as though you're missing a space in your parameters after DevCassandra and before the double-dashes.</p> <p>Thanks,<br /> Joaquin </p>