Unable to obtain session. Cassandra hasn't been started or is unavailable.
Hello! In my Pega 8.3 application, when I start it up, I get the following errors w/ Cassandra.
[service: VBD.Default] [ STANDARD] [ ] [ ] (rvice.operation.StartOperation) ERROR - Cannot start service [VBD.Default]. Will retry in 180 seconds. Remaining attempts: 2
com.pega.dsm.dnode.api.dds.service.SessionNotAvailableException: Unable to obtain session. Cassandra hasn't been started or is unavailable
Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /XXX.XXX.XX.XX:9042 (com.datastax.driver.core.exceptions.TransportException: [/XXX.XXX.XX.XX:9042] Cannot connect))
How can I fix this error and get a clean log file? Via a DSS setting?
Thanks!
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
US
what is your -DNodeType JVM setting? If you only want this node to be web node, use -DNodeType=WebUser. It is likely that your -DNodeType=Universal, which will try to start all decisioning services. If you indeed want all decisioning services to startup (which should only be used for non-production env), check if any firewall is enabled that prevents port 9042 from communicating.
Updated: 22 Jan 2020 1:57 EST
Highmark Health
US
You are correct that I was using the -DNodeType=Universal. I was able to change that as you suggested and restarted. The Cassandra error went away. I'm working with my networking folks regarding the firewall for port 9042.
Updated: 22 Jan 2020 1:57 EST
Highmark Health
US
OK. There are several connections on this server to port 9042. A couple for an example are:
server1.company.com:12345->server1.company.com:9042 (ESTABLISHED)
server1.company.com:54321->server1.company.com:9042 (ESTABLISHED)
Additional Questions:
Is port 9042 secured?
Pega is connecting via IP address. Can the IP address be changed to a hostname - ie. server1.company.com ?
Thanks!
Nordea
SE
Hi, I am still getting this exception even if have setup -DNodeType as follows where DDS was excluded:--
-DNodeType=ADM,BackgroundProcessing,Batch,RTDG,RealTime,Search,Stream,WebUser
Pegasystems Inc.
IN
Hi,
Kindly follow the below link,
https://community.pega.com/support/support-articles/cassandra-not-started-or-unavailable
Regards,
Pegasystems Inc.
IN
Hi,
Use DNodeType=BackgroundProcessing,Search,Stream,WebUser,DDS. Else, add the the Decision Data Store (DDS).
Shutdown Pega nodes/JVMs gracefully: Web and decision hub nodes Data flow nodes VBD nodes and ADM nodes DDS and Stream nodes Rest of the nodes. Shutdown the Database Server (if needed after machine patch else leave it running) Start the DB machine back up Start the App Server machine(s) back up Bring up Pega nodes Startup Order: Follow the reverse order