If your node is not connected to spread, follow the below steps to troubleshoot the connection issue.
| Step | Task | Results |
|---|---|---|
| 1 | Check whether the spread.conf file in the catalog folder is identical across all the nodes in the cluster.
$ cat spread.conf |
If the spread.conf flies are identical across all nodes, go to Step 2.
If the spread.conf flies are not identical across all nodes, do the following:
|
| 2 | Check whether the spread port (default is 4803) is listening using either of the following:
$ netstat -ap | grep 4803
OR
$ telnet <spread IP address> 4803
Each node in your cluster has its own spread port. To verify the port used by spread in your cluster:
|
If the spread is not listening, go to Step 3. If the spread is listening, go to Step 4. |
| 3 | Check that the firewall is not enabled.
# iptables –L |
If the firewall is enabled, either disable the firewall OR ask the network administrator to open the port. |
| 4 | Check whether the /etc/hosts file has all the IP addresses of the cluster. | If the file is correct with all the IP addresses of the cluster, go to Step 5. If the file is not correct, fix the /etc/hosts files to include all the nodes in the cluster and go to Step 5. |
| 5 | Check whether the UDP transmit packet contains errors.
$ netstat -s |
If the UDP transmit packet contains errors, go to Step 6. If the UDP transmit packet does not contains errors, go to Step 7. |
| 6 | Verify the packet contains errors using the following command to look at the UDP transmits.
$ /opt/vertica/bin/vnetperf |
If there are errors contact your local administrator or system administrator. |
| 7 | Check whether spread groups form using spuser.
$ /opt/vertica/spread/bin/spuser -s 4803@host_IP
$ j test-spread
|
If the number of nodes match, your spread must be connected and the checklist is complete. If the number of the nodes do not match, start this checklist again to find an alternative path. If the number of members continues to not match the number of nodes, contact Vertica support. |
Learn More
Learn more about Spread in the Vertica Documentation and Spread Debugging in the Vertica Knowledge Base.About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
