Diagnose Spark connectivity

If you are unsure about the environment parameter for your Spark to the Spark APIs, please see What is the link to my environment?.

Check server status

Every Spark environment has a health check endpoint. This can be accessed by visiting the address https://excel.{environment}.coherent.global/health in your web browser. If the environment is up, you should see the following response.

{"status":"UP"}

Time your connection to the Spark servers

To help diagnose any potential firewall or connectivity issues, you can use these curl commands to time the connection to Spark to see if there are significant lags or connectivity issues.

Sample request

Make sure to replace {environment} with the environment that you are using.

Bash	PowerShell
curl --silent --write-out "\n\n---Coherent Spark connection details---\nhttp_code: %{http_code}\nlocal_ip: %{local_ip}\nlocal_port: %{local_port}\nnum_connects: %{num_connects}\nnum_redirects: %{num_redirects}\nproxy_ssl_verify_result: %{proxy_ssl_verify_result}\nremote_ip: %{remote_ip}\nremote_port: %{remote_port}\nresponse_code: %{response_code}\nsize_download: %{size_download} B\nsize_header: %{size_header} B\nsize_request: %{size_request} B\nsize_upload: %{size_upload} B\nspeed_download: %{speed_download} Bps\nspeed_up: %{speed_upload} Bps\n---Coherent Spark connection time---\ntime_appconnect: %{time_appconnect}\ntime_connect: %{time_connect}\ntime_namelookup: %{time_namelookup}\ntime_pretransfer: %{time_pretransfer}\ntime_redirect: %{time_redirect}\ntime_starttransfer: %{time_starttransfer}\n---\ntime_total: %{time_total}\n" --location 'https://excel.{environment}.coherent.global/health'	curl.exe --silent --write-out "\n\n---Coherent Spark connection details---\nhttp_code: %{http_code}\nlocal_ip: %{local_ip}\nlocal_port: %{local_port}\nnum_connects: %{num_connects}\nnum_redirects: %{num_redirects}\nproxy_ssl_verify_result: %{proxy_ssl_verify_result}\nremote_ip: %{remote_ip}\nremote_port: %{remote_port}\nresponse_code: %{response_code}\nsize_download: %{size_download} B\nsize_header: %{size_header} B\nsize_request: %{size_request} B\nsize_upload: %{size_upload} B\nspeed_download: %{speed_download} Bps\nspeed_up: %{speed_upload} Bps\n---Coherent Spark connection time---\ntime_appconnect: %{time_appconnect}\ntime_connect: %{time_connect}\ntime_namelookup: %{time_namelookup}\ntime_pretransfer: %{time_pretransfer}\ntime_redirect: %{time_redirect}\ntime_starttransfer: %{time_starttransfer}\n---\ntime_total: %{time_total}\n" --location 'https://excel.{environment}.coherent.global/health'
	Note when using PowerShell, make sure you are using curl.exe and not curl which uses the Invoke-WebRequest command.

Sample response

{"status":"UP"}

---Coherent Spark connection details---
http_code: 200
local_ip: 192.168.1.107
local_port: 59899
num_connects: 1
num_redirects: 0
proxy_ssl_verify_result: 0
remote_ip: 172.26.35.63
remote_port: 443
response_code: 200
size_download: 15 B
size_header: 204 B
size_request: 0 B
size_upload: 0 B
speed_download: 51 Bps
speed_up: 0 Bps
---Coherent Spark connection time---
time_appconnect: 0.229670
time_connect: 0.080042
time_namelookup: 0.021973
time_pretransfer: 0.229767
time_redirect: 0.000000
time_starttransfer: 0.288606
---
time_total: 0.289149