Vertica connection is closed when running copy command. Vertica log shows “FATAL connection is closed "
We are running Vertica 10.0.1 /RHEL 7.9 with Vertica ADO.net driver 9.1 hosted on Azure VM
Error captured from .net application is pasted below . Issue occurs when loading large volume data in client environment,
2021-08-27 03:50:57,177 | [1] | ERROR | e3768fa6-953c-e2dc-e053-0a3c8f0a3bba | 83d4745b-32fc-4701-a555-d85b6d18e69b | [0] Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.Security._SslStream.StartWriting(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security._SslStream.ProcessWrite(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.BufferedStream.Flush()
at Vertica.Data.Internal.IO.VStream.flush()
at Vertica.Data.Internal.IO.ProtocolStream.ReadMessage()
2021-08-27 14:54:56,167 | [1] | ERROR | e3768fa6-953c-e2dc-e053-0a3c8f0a3bba | dace5206-a03f-4c1f-8ef9-47e58fd7bf8e | [0] The connection is closed