[Vertica][VJDBC](4236) ROLLBACK: One or more nodes did not open a data connection to this node.
I have 3 nodes cluster DB (v9.2.0) and yesterday i found there is NTP issue.
i fixed times manually (there was 1-10 minutes time shift between nodes),
few minutes later i got most queries failed.
- Each node can ping others (same as before)
- There is no networking issue (vnetperf result is fine and spread is ok!)
- All nodes are UP (i stop/start recently but it not help)
- v_monitor.error_messages has too many error such as:
One or more nodes did not open a data connection to this node. This may indicate a network configuration problem. Check that the private interfaces used for communication among the cluster hosts reside in the same subnet and are returned first by host address lookup
Recceive on v_db_node0001: query has been canceled
RecvFiles on v_db_node0002: Open failed on node [v_db_node0003] ()
DataTargetProxy on v_db_node0002: handle is canceled
Please let me know what's doing wrong?