[Code: 100024, SQL State: 08S01] [Vertica][VJDBC](100024) IOException while communicating with ser

We have some security softwares installed on servers as a part of compliance since then
many queries are returning these errors.
[Code: 100024, SQL State: 08S01] [Vertica]VJDBC IOException while communicating with server: java.io.EOFException.
I kind of have idea about this error- Error 100024 which is a Network Error an error emitted by the Vertica JDBC driver.
It is most probably related to the network or firewall.
Also i checked the output of below query data attached in screenshot- with NetworkRecv as the highest counter values
SELECT
operator_name,
path_id,
SUM(counter_value)
FROM
execution_engine_profiles
WHERE
transaction_id = :t_id
AND statement_id = :s_id
AND counter_name ILIKE 'execution%'
GROUP BY
operator_name,
path_id
ORDER BY
3 DESC LIMIT 20;
Any suggestions on this?
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Please ensure all relevant ports are available as per the list here:
https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/InstallationGuide/BeforeYouInstall/EnsurePortsAreAvailable.htm
You can place all cluster nodes behind a firewall but all ports mentioned in the above doc should stay open between the cluster nodes.
Then open in the firewall only the ports to/from the outside world which are relevant for the clients connection.
For example port 5433 TCP for vsql, ODBC, JDBC, etc.