[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?
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.