How Do I Do If an Error Is Reported When an MRS Presto Query Statement Is Executed?

Question

The error message "The node may have crashed or be under too much load" is displayed when a Presto query statement is executed.

Figure 1 Error information

Fault Locating

1. Query the cluster ID, obtain the O&M authorization, log in to a master node, go to the /var/log/Bigdata directory, and search for Presto logs.

   The error information is the same as that on the fault reporting page.

2. Check the process logs of the Presto worker instance on the 192.168.0.243 node based on the error information. The log information is as follows:

   java.lang.OutOfMemoryError: Java heap space

3. Based on the error information, it is predicted that out of memory (OOM) occurs. As a result, the query error is reported.

Troubleshooting

1. On the Manager page, search for the jvm parameter (xmx) of the worker.
2. Change 1024 next to Xmx to 2048 and save the configuration.
3. Restart Presto and perform the query again. The issue is rectified and no error is reported.