We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


UDX message header check failed — Vertica Forum

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

    outputWriter.getStringRef(j).copy(inputReader.getStringRef(j));

    and output column size was set to constant

    Hope it can be helpful for someone else

Leave a Comment

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