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

SK21SK21 Vertica Customer

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file