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?