UDX message header check failed
Hello
Recently I wrote UDF and everything was fine untill now.
From time to time I'm getting error messages like:
SQL Error [8092] [VP001]: [Vertica]VJDBC ERROR: Failure in UDx RPC call InvokeProcessPartition() in User Defined Object [DistinctHashCounter]: Message header check failed
[Vertica]VJDBC ERROR: Failure in UDx RPC call InvokeProcessPartition() in User Defined Object [DistinctHashCounter]: Message header check failed
[Vertica]VJDBC ERROR: Failure in UDx RPC call InvokeProcessPartition() in User Defined Object [DistinctHashCounter]: Message header check failed
UDxLogs/UDxFencedProcesses.log:
12:30:38.905 [C++-v_dwh_node0010-23011:0x233c9f-12412] 0x7fda53fff700 Received SIGPIPE, ignoring
12:30:38.905 [C++-v_dwh_node0010-23011:0x233c9f-12412] 0x7fda53fff700 Received SIGPIPE, ignoring
12:30:38.905 [C++-v_dwh_node0010-23011:0x233c9f-12412] 0x7fda53fff700 Error in send(): Broken pipe
How can I fix this and where should I start?
Comments
Is there any debug options or profiling tool for such cases? I mean error message tells me like nothing about what went wrong. Does anybody faced this error or how can I debug UDF?
UPD: I managed to fixed it by extending varchar size for output column.
I was using copy like this
and output column size was set to constant
Hope it can be helpful for someone else