Error Message "The node may have crashed or be under too much load" Is Displayed During MRS Presto Query

Issue

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

Cause Analysis

1. Log in to the master node of the cluster and search the Presto log in the /var/log/Bigdata directory.
2. Check the process logs of the Presto worker instance on the corresponding node based on the error information.
   The log information is as follows:

   java.lang.OutOfMemoryError: Java heap space

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

Procedure

1. On Manager, search for the JVM parameter (xmx) of the worker instance.
2. Change 1024 next to xmx to 2048 and save the configuration.
3. Restart the Presto service and try again.