My Oracle Support Banner

After Upgrade to Mammoth 4.4.0 Impala Error in Hue of "Memory limit exceeded Query did not have enough memory to get the minimum required buffers in the block manager" (Doc ID 2134103.1)

Last updated on DECEMBER 27, 2019

Applies to:

Big Data Appliance Integrated Software - Version 4.4.0 and later
Linux x86-64

Symptoms

In Hue an Impala query raises:

Memory limit exceeded Query did not have enough memory to get the minimum required buffers in the block manager.

 

The Impala daemon log after the startup shows:

W0502 10:35:28.278945 28772 <TEMP_FILE>:<POSITION1>] Could not remove and recreate directory /tmp/impala-scratch: cannot use it for scratch. Error was: Encountered error removing directory '/tmp/impala-scratch': Operation not permitted
E0502 10:35:28.279000 28772 <TEMP_FILE>:<POSITION2>] Running without spill to disk: could not use any scratch directories in list: /tmp. See previous warnings for information on causes.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.