Splunk Search

How to avoid excessive memory usage error?

Neonbeeflash
Explorer

Hello,

I am performing a search in Splunk Cloud but I am getting the following error, does anyone know how to resolve it.

The search:

index=sf-test-metrics domains NOT "sitefinity.com" NOT "*iriscodebasesandbox.cloudapp.net*" NOT "*.bedford*" NOT "*.regression.com*" NOT "dynamicscan.cloudapp.net" NOT "irisdmsitsandbox" NOT "*irisdmuatsandbox*" NOT "*.sandbox.sitefinity.com*" NOT "localhost" domains{}= *\.*

| spath path=modulesInfo{} output=x
| fields x, clientId, domains{}
| mvexpand x
| spath input=x
| search moduleName="AdminBridge"
| where extensionBundlesCount > 0
| dedup clientId
| table domains{}, extensionBundlesCount
| sort -extensionBundlesCount


The error:
command.mvexpand: output will be truncated at 37800 results due to excessive memory usage. Memory threshold of 500MB as configured in limits.conf / [mvexpand] / max_mem_usage_mb has been reached.

Labels (1)
0 Karma
Get Updates on the Splunk Community!

Cultivate Your Career Growth with Fresh Splunk Training

Growth doesn’t just happen—it’s nurtured. Like tending a garden, developing your Splunk skills takes the right ...

Introducing a Smarter Way to Discover Apps on Splunkbase

We’re excited to announce the launch of a foundational enhancement to Splunkbase: App Tiering.  Because we’ve ...

How to Send Splunk Observability Alerts to Webex teams in Minutes

As a Developer Evangelist at Splunk, my team and I are constantly tinkering with technology to explore its ...