I encountered an error while issuing a CREATE MATERIALIZED VIEW command with approximately 150 columns. The error message was: ExecuteError: internal error: MetadataModel error: Meta store error: internal error: grpc request error: status: ResourceExhausted, message: "grpc: received message larger than max (3424541 vs. 2097152)", details: [], metadata: MetadataMap { headers: {"content-type": "application/grpc"} } The command itself was 18,270 characters long.
Bahador Nooraei
Asked on Aug 04, 2023
To fix the 'grpc: received message larger than max' error when issuing a CREATE MATERIALIZED VIEW command with many columns, you can follow these steps:
Add an environment variable ETCD_MAX_REQUEST_BYTES and set it to a higher value, for example, 10485760.
This error is reported by etcd, and adjusting the ETCD_MAX_REQUEST_BYTES variable will increase the maximum request size allowed by etcd.
For more information, you can refer to the official documentation on configuring etcd and setting the --max-request-bytes parameter: etcd Configuration Guide
After setting the ETCD_MAX_REQUEST_BYTES environment variable, reissue the CREATE MATERIALIZED VIEW command to see if the issue is resolved.
