[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
transaction_id = :t_id
AND statement_id = :s_id
AND counter_name ILIKE 'execution%'
3 DESC LIMIT 20;
Any suggestions on this?