How to resolve materialized view creation error with UDF in RisingWave?
I'm trying to create a materialized view in RisingWave by processing a Kafka stream with a UDF, but I'm encountering an error. The query without the materialized view works fine, but when I try to create the view, I get an internal error related to RPC and gRPC. Here's the code I'm using and the error message:
Create MATERIALIZED VIEW ex_stream_mv AS select get_examples_udf(trigger) from trigger_stream;And the error message:
ERROR: QueryError: internal error: Rpc error: gRPC error (Internal error): Actor 3009 exit unexpectedly: Executor error: Chunk operation error: UDF error: failed to check UDF: status: Unknown, message: "transport error", details: [], metadata: MetadataMap { headers: {} }
...Even when creating materialized views without the UDF server, I encounter a similar error. What could be causing this issue, and how can I resolve it?
Sanjeevini Ganni
Asked on Sep 12, 2023
It seems like there might be a connectivity issue between the ComputeNode and the UDF server, or a problem with the deployment of the RisingWave cluster. To troubleshoot this issue, you should check the network connectivity between the UDF server and ComputeNode, and ensure that there are no issues with DNS or IP configurations, especially if you have a service mesh like Istio in your cluster. Additionally, providing full logs from the cluster, including the Meta and Compute nodes, can help to locate the problem. Make sure to check for any deployment-related issues as well.