Troubleshooting R-UDF, trying to decode the log files

we're running a function which properly works when executed not concurrently but it seems to crash when multiple concurrent instances are executed.
It has been developed avoiding shared state and it is invoked on a data set of about 6M rows x 50columns.
I'm not able to decode the UDxFencedProcesses.log, can you help me to understand the meaning of problematic traces and which causes can bring to them?


  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator


    Which version of Vertica are you using? How many nodes are in your cluster? Have you tried running the UDx concurrently on a smaller data set? By crash, what do you mean? Do you get an error?


  • Options

    Hi Jim

    thank you for answering; to add some context:
    we're using Vertica 9.0.1 delivered as a cluster of 3 nodes. Unit tests include concurrent executions on smaller data sets which terminate succesfully. The behavior is that the SQL statement invoking such function hangs, without recovering its execution...

  • Options
    Jim_KnicelyJim_Knicely - Select Field - Administrator

    Are you running the SQL that calls the function locally on one of the nodes (i.e. via vsql) or remotely using some other tool like DbVisualizer?

    When the query is "hung", can you check the SESSIONS table to make sure the session is still connected and running the query?

    SELECT current_statement FROM sessions WHERE session_id = <>;

    And check these system tables for any obvious issues:


    Also, the vertica.log (on each node) need to be reviewed for errors / unexpected session disconnect (for the session running the SQL).

Leave a Comment

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