Datastax DevCenter 1.3.1 MAC/OS and Cassandra 3.11.1 support request

Henry Hottelet

unread,

Dec 10, 2017, 7:58:09 PM12/10/17

to alan.bo...@datastax.com, java-dri...@lists.datastax.com

Dear Alan, and Olivier, from DataStax test engineering,

I am a development Datastax customer, and am currently using DevCenter 1.3.1 for MAC/OS, since 2014.

My goal, is to upgrade to the latest Cassandra, with the latest Datastax tools, and to support Docker with DataStax driver running internally.  I can provide more information about my system test, however, wanted to get these basic things out of the way first, by describing the triage scenario here on MACOS with MacOS High Sierra version 10.13.1.

 I know I can make all of these issues go away, by reverting back to cassandra version 2.1.5, which works on my system, without any of these errors, however, I would like to move forward here, and need assistance to upgrade.  The actions, I took, were an upgrade to use 5.1.5, however I did not see the upgrade to DevCenter, and need to know where the download link is located.  

I decided without the DevCenter upgrade, to do a standalone system test, with Docker, to help by debugging connectivity TransportExceptions I was seeing with port 9042 that is bound to 127.0.0.1 with cassandra running inside docker.  

I recently upgraded to cassandra 3.11.1, and saw your post in the newsgroup(https://groups.google.com/a/lists.datastax.com/forum/#!msg/python-driver-user/cbY5YvSqX7A/WcuB_oQUEAAJ), about an issue I am having with Cassandra and Docker.

I executed this docker script, to get cassandra 3.11.1.

Step1:

docker run --name cassandra -m 2g -p 127.0.0.1:9042:9042 -d cassandra

I then wanted to connect to the cassandra docker image, to see if I can get cqlsh, because I am seeing the same unconfigured table schema keyspaces error in DevCenter 1.3.1

Step2:

docker exec -it cassandra cqlsh 172.17.0.2

Connected to Test Cluster at 172.17.0.2:9042.

[cqlsh 5.0.1 | Cassandra 3.11.1 | CQL spec 3.4.4 | Native protocol v4]

Use HELP for help.

cqlsh> SELECT * FROM system.schema_keyspaces;

InvalidRequest: Error from server: code=2200 [Invalid query] message="unconfigured table schema_keyspaces"

I looked at the datastax documentation, and did an upgrade to the cassandra-driver for python. (https://github.com/datastax/python-driver), and executed pip install cassandra-driver

However, then found additional instructions, for upgrading (https://datastax.github.io/python-driver/installation.html), and after verifying installation, see "/usr/bin/python -c 'import cassandra; print cassandra.__version__'

Traceback (most recent call last):

  File "<string>", line 1, in <module>

ImportError: No module named cassandra"

I have a couple of questions here:

1. Is there an upgraded version of DevCenter that I can get for MACOS that addresses and solves these problems?

2. Do I really need the Python interpreter, I don’t really see why, since the error I am seeing is part of the cqsl interpreter "InvalidRequest: Error from server: code=2200 [Invalid query] message="unconfigured table schema_keyspaces””.

3. Why am I seeing this error when in Cassandra 2.1.x I was not seeing this error at all previously?

The problem I am seeing in DevCenter in addition is, "The specified host(s) could not be reached.

All host(s) tried for query failed (tried: /172.17.0.2:9042 (com.datastax.driver.core.TransportException: [/172.17.0.2:9042] Cannot connect))

[/172.17.0.2:9042] Cannot connect”, and I see the same problem within a SpringBoot app inside Docker with Datastax driver.

Note, I am seeing the same problem inside Docker with TransPortException, (see https://groups.google.com/a/lists.datastax.com/forum/#!topic/java-driver-user/QohK0Sd86-4 )

Basically, I need to get to the root of the issue here with DevCenter and CQLSH, since these issues, are fairly basic, and have to do with the installation and compatibility with Cassandra, and Datastax DevCenter. I also am seeing the errors, from the CQLSH command line, which tells me this has more to do with Cassandra 3.11.1.

Please advise.

—

Henry Hottelet

646-543-6104 (Google Voice: cell/sms)

hott...@gmail.com (Email)

http://www.linkedin.com/in/hottelet (LinkedIn)

https://technologyventureslimited.appointlet.com (Schedule appointment)

This transmission may contain information that is privileged,

confidential, legally privileged, and/or exempt from disclosure

under applicable law. If you are not the intended recipient, you

are hereby notified that any disclosure, copying, distribution, or

use of the information contained herein (including any reliance

thereon) is STRICTLY PROHIBITED. Although this transmission and any

attachments are believed to be free of any virus or other defect

that might affect any computer system into which it is received and

opened, it is the responsibility of the recipient to ensure that it

is virus free and no responsibility is accepted by Henry Hottelet

as applicable, for any loss or damage arising in any way from its use.

If you received this transmission in error, please immediately contact

the sender and destroy the material in its entirety, whether in

electronic or hard copy format. Thank you.

Kevin Gallardo

unread,

Dec 11, 2017, 1:48:45 PM12/11/17

to DataStax Java Driver for Apache Cassandra User Mailing List, alan.bo...@datastax.com

Hi,

You might want to use DevCenter 1.6 to be able to connect to Cassandra 3.0+. Indeed previous versions of DevCenter may use an old Java driver for Apache Cassandra version that is not able to connect to Cassandra 3.0+ because in 3.0+ there have been some breaking changes introduced to Cassandra system tables (some system tables have changed names or have been removed) that old driver versions cannot handle but new driver versions can and I think DevCenter 1.6 should be using one of the new driver version.

While you can check DevCenter 1.6 here, we highly recommend using the newest DataStax Studio instead, a web-based interactive developer tool based on self-documenting notebooks, which contains our latest and greatest features.

Finally, to be able to use the DataStax drivers with Cassandra 3.0+ you need to update to recent versions of the drivers, in Java the latest version is 3.3.2 and in Python it's 3.12.0.

Let me know if that helps.

Henry Hottelet

unread,

Dec 11, 2017, 1:52:53 PM12/11/17

to java-dri...@lists.datastax.com

Kevin,

The DevCenter 1.6 link, only points me to DataStax Studio.

Is DevCenter 1.6 on MAC/OS still available, and if so, how do I get it?

Note: I was able to triage, the Docker and Cassandra issues, and reached the conclusion that this upgrade is necessary (https://github.com/quantum-fusion/springboot_swagger_example-master-cassandra/issues/3)