Sat Aug 18, 2018 9:42 pm
Login Register Lost Password? Contact Us


Cassandra for Workunit Storage configuration help

Post questions specific to installation or configuration for the HPCC Systems platform

Mon Sep 26, 2016 2:19 pm Change Time Zone

I am trying to setup Cassandra as dali store. I have completed the configuration as per the documentation. Dali is not starting after making the changes.

Please help me figure out what I am missing. I have attached the steps as screen shots.

Cassandra is up and running.

VirtualBox version 5.1.6
HPCCSystemsVM-amd64-6.0.4-1
Cassandra 3.2.1
Attachments
1.jpg
1.jpg (216.58 KiB) Viewed 817 times
balajisampath
 
Posts: 63
Joined: Mon Jul 22, 2013 6:29 pm

Tue Sep 27, 2016 2:36 pm Change Time Zone

Hi,

Would you be able to post the contents of the dali log? It should be located here:

/var/log/HPCCSystems/mydali/server/DaServer.log
clo
 
Posts: 51
Joined: Thu May 12, 2011 11:57 am

Tue Sep 27, 2016 3:53 pm Change Time Zone

this are the last few lines of the log

00000009 2016-09-27 15:40:45.823 8251 8251 "store loaded"
0000000A 2016-09-27 15:40:45.823 8251 8251 "loading external Environment from: /etc/HPCCSystems/environment.xml"
0000000B 2016-09-27 15:40:50.853 8251 8260 "cassandra: ERROR - Host 127.0.0.1 had the following error on startup: 'Connection timeout'"
0000000C 2016-09-27 15:40:50.854 8251 8260 "cassandra: WARN - Lost connection on host 127.0.0.1"
0000000D 2016-09-27 15:40:50.857 8251 8251 "ERROR: 0: Exception - Failed to load main store : cassandra: failed to connect (No hosts available for the control connection)"
0000000E 2016-09-27 15:40:50.857 8251 8251 "Failed to load main store"
0000000F 2016-09-27 15:40:50.857 8251 8251 "ERROR: 0: /var/lib/jenkins2/workspace/CE-Candidate-6.0.4-1/CE/ubuntu-14.04-amd64/HPCC-Platform/dali/server/daserver.cpp(398) : Failed whilst starting servers : cassandra: failed to connect (No hosts available for the control connection)"
00000016 2016-09-27 15:40:50.858 8251 8251 "Suspending subscriptions"
00000017 2016-09-27 15:40:50.858 8251 8251 "Suspended subscriptions"
00000018 2016-09-27 15:40:50.858 8251 8251 "Suspending 0"
00000019 2016-09-27 15:40:50.858 8251 8251 "Stopping 6"
0000001A 2016-09-27 15:40:50.858 8251 8251 "Stopping 5"
0000001B 2016-09-27 15:40:50.858 8251 8251 "Stopping 4"
0000001C 2016-09-27 15:40:50.858 8251 8251 "Stopping 3"
0000001D 2016-09-27 15:40:50.858 8251 8251 "Stopping 2"
0000001E 2016-09-27 15:40:50.858 8251 8251 "Stopping 1"
0000001F 2016-09-27 15:40:50.859 8251 8251 "Stopping 0"
00000020 2016-09-27 15:40:50.860 8251 8259 "BackupHandler stopped"
00000021 2016-09-27 15:40:50.862 8251 8251 "ERROR: 0: /var/lib/jenkins2/workspace/CE-Candidate-6.0.4-1/CE/ubuntu-14.04-amd64/HPCC-Platform/dali/server/daserver.cpp(439) : Exception : cassandra: failed to connect (No hosts available for the control connection)"
balajisampath
 
Posts: 63
Joined: Mon Jul 22, 2013 6:29 pm

Tue Sep 27, 2016 4:23 pm Change Time Zone

Just to be thorough, can you please verify that our cassandra is running?

Try `sudo service cassandra start` and then restart the hpccsystems platform.
clo
 
Posts: 51
Joined: Thu May 12, 2011 11:57 am

Tue Sep 27, 2016 4:58 pm Change Time Zone

hpccdemo@HPCCSystemsVM-amd64-6:~$ sudo service cassandra start
hpccdemo@HPCCSystemsVM-amd64-6:~$ cqlsh
Connected to Test Cluster at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.2.1 | CQL spec 3.4.0 | Native protocol v4]
Use HELP for help.
cqlsh> use hpcc;
cqlsh:hpcc> exit
hpccdemo@HPCCSystemsVM-amd64-6:~$ sudo /opt/HPCCSystems/sbin/hpcc-run.sh -a hpcc-init start
192.168.56.101: Running sudo /etc/init.d/hpcc-init start
Starting mydafilesrv ... [ OK ]
Starting mydali ... [ FAILED ]
Starting mydfuserver ... [ OK ]
Waiting on sentinel file creation
Starting myeclagent ... [ OK ]
Waiting on sentinel file creation
Starting myeclccserver ...

-----------------------------------------------------------------------------------
also tried this to ensure its running
hpccdemo@HPCCSystemsVM-amd64-6:~$ nodetool status
Datacenter: datacenter1
=======================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
-- Address Load Tokens Owns Host ID Rack
UN 127.0.0.1 108.91 KB 256 ? 2b7dd353-8462-41eb-a93a-cee1167581ac rack1

Note: Non-system keyspaces don't have the same replication settings, effective ownership information is meaningless
hpccdemo@HPCCSystemsVM-amd64-6:~$
balajisampath
 
Posts: 63
Joined: Mon Jul 22, 2013 6:29 pm

Wed Sep 28, 2016 9:15 am Change Time Zone

This could be related to an issue setting the proper Cassandra protocol version - there is some info in
https://track.hpccsystems.com/browse/HPCC-15879

If so, adding an option "protocol_version" with value 3 to the dali cassandra plugin settings may help
richardkchapman
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 108
Joined: Fri Jun 17, 2011 8:59 am

Wed Sep 28, 2016 12:42 pm Change Time Zone

0000001C 2016-09-28 12:39:22.550 6117 6117 "Stopping 1"
0000001D 2016-09-28 12:39:22.550 6117 6117 "Stopping 0"
0000001E 2016-09-28 12:39:22.550 6117 6125 "BackupHandler stopped"
0000001F 2016-09-28 12:39:22.550 6117 6117 "ERROR: 0: /var/lib/jenkins2/workspace/CE-Candidate-6.0.4-1/CE/ubuntu-14.04-amd64/HPCC-Platform/dali/server/daserver.cpp(439) : Exception : cassandra: While setting option protocol_version: Bad parameters"
Attachments
2.jpg
2.jpg (27.33 KiB) Viewed 778 times
balajisampath
 
Posts: 63
Joined: Mon Jul 22, 2013 6:29 pm

Wed Sep 28, 2016 12:47 pm Change Time Zone

Looks like the version of the cassandra client library included in 6.0.4 only supports protocol versions 1 and 2.


protocol_version=2 might work?
richardkchapman
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 108
Joined: Fri Jun 17, 2011 8:59 am

Wed Sep 28, 2016 12:53 pm Change Time Zone

with option 2

00000021 2016-09-28 12:52:00.108 14959 14959 "ERROR: 0: /var/lib/jenkins2/workspace/CE-Candidate-6.0.4-1/CE/ubuntu-14.04-amd64/HPCC-Platform/dali/server/daserver.cpp(439) : Exception : cassandra: failed to connect (No hosts available for the control connection)"
balajisampath
 
Posts: 63
Joined: Mon Jul 22, 2013 6:29 pm

Wed Sep 28, 2016 12:59 pm Change Time Zone

attaching the entire log
Attachments
DaServer.zip
(104.43 KiB) Downloaded 112 times
Last edited by balajisampath on Wed Sep 28, 2016 1:58 pm, edited 1 time in total.
balajisampath
 
Posts: 63
Joined: Mon Jul 22, 2013 6:29 pm

Next

Return to Installation

Who is online

Users browsing this forum: No registered users and 1 guest

cron